1

1

1

5000

2 1

2 1 college

2 1 college

1 1 college

2 1 high school

1 2 college

1 1 college

1 2 college

2 2 college

2 1 high school 55000

1 1 high school 40000

1 1 college 65000

1 3 college 50000

10/12/07 110 412 802
10/12/07 111 478 821
10/12/07 112 399 812
10/12/07 113 421 872
10/12/07 114 401 899
17/12/07 110 710 799
17/12/07 111 689 721
17/12/07 112 899 712
17/12/07 113 700 801
17/12/07 114 699
24/12/07 110 340 490
24/12/07 111 801 798
24/12/07 112 598 412
24/12/07 113 980 849
24/12/07 114 798 724
31/12/07 110 487 321
31/12/07 111 501 601
31/12/07 112 598 549
31/12/07 113 601 601
31/12/07 114 900 811

3/5/2020

Midterm Exam Part 2 b

https://psu.instructure.com/courses/2040447/assignments/11467183?module_item_id=28351512 1/2

Midterm Exam Part 2 b

Due Sunday by 11:59pm Points 24 Submitting a file upload

Submit Assignment

Directions

Write appropriate SAS code to answer the following questions. Follow the directions carefully. You will be
penalized if you did not complete the questions exactly as described. You are expected to work
completely alone in completing this midterm exam. I reserve the right to penalize you as many points
as I deem appropriate if I learn that you did not abide by this request. This portion of the midterm exam is
worth 24 points.

Type up your answers in a Word file named midterm_yourPSUloginid. Copy, paste and label your
SAS program code, your SAS log windows, and the resulting output into your Word document.
Make sure you label each question so it is clear which code/log/output goes with each question. Upload
your Word document as your submission for this assignment.

You will be graded on the accuracy, generalizability, and efficiency of your code. Absolutely no late
submissions will be accepted.

Questions

1. (8 points) Read the data contained in the income.dat file directly from the data file into a
temporary SAS data set called question01. The contents of the data set are: id number (idno), gender
(sex), race (race), highest education level (education), income level (income). In the same data step in
which you read the data into the SAS data set, create a new variable called category that is defined as
follows:

if income is less than 45000, then category is 1
if income is at least 45000 but less than 80000, then category is 2
if income is at least 80000, then category is 3

Print the resulting SAS data set question01.

2. (8 points) Read the data contained in the sales.dat file using a DATALINES statement into a
permanent SAS data set called question02. The data in each record are in order: date (date), store
number (store), last year’s first quarter sales (sale1), and this year’s first quarter sales (sale2). In the
same data step in which you read the data into the SAS data set, create two new variables:

https://psu.instructure.com/courses/2040447/files/106042467/download?wrap=1

https://psu.instructure.com/courses/2040447/files/106042467/download?wrap=1

https://psu.instructure.com/courses/2040447/files/106042201/download?wrap=1

https://psu.instructure.com/courses/2040447/files/106042201/download?wrap=1

3/5/2020 Midterm Exam Part 2 b

https://psu.instructure.com/courses/2040447/assignments/11467183?module_item_id=28351512 2/2

average (a numeric variable containing the average of the first and second quarter sales for each
store)
status (a character variable which equals “incomplete” if either sale1 or sale2 is missing, “no change”
if sale1 equals sale2, “improved” if sale1 is less than sale2, and “regressed” if sale1 is greater than
sale2)

Print the resulting SAS data set question02.

3. (8 points) Save this permanent SAS data set called golf.sas7bdat to a convenient location on your
computer. The data in each record are in order: golf course (name), number of holes (holes), par (par),
total yardage (yardage), and greens fees (fees). Print the resulting SAS data set ensuring that the output
is centered, your page size is no larger than 58 lines, and the line size no longer than 80 characters.
When you print the data set, do what you need to do, to make it look like this:

That is: (1) double space your output, (2) label the variables as in the above output, (3) title the output as
it appears above, (4) suppress the printing of the observation number, and (5) make sure that the
yardage contains a comma (e.g., 7,263) and the fees are preceded by a dollar sign (e.g., $125.00).

https://psu.instructure.com/courses/2040447/files/106042322/download?wrap=1