SAS

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:

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).