Description

Scope:
General Homework Instructions:
Specific Instructions for this Assignment:

1. If you have not already done so, download the Sample Programs and Data associated with the SQL course notes. Extract these files to a folder that can be accessed from your SAS sessions. If you are using SAS Studio, this folder will need to be under SASUniversityEdition, myfolders. In your program code, assign a libref to this folder. Add the access=readonly option to your libname statement to ensure that you do not accidentally overwrite any of this data. We will refer to this as the Orion data throughout this assignment. Create another folder on your computer to which you can download assignment data files from eCampus and access them from SAS. Download the Unicornstaff data set to this folder. Create a libref, with a name of your choosing that points to this folder. Add the readonly option to this libref. You will need to create and/or designate a third folder that can be used to store the data sets and output files created in assignments this semester. This section of your program will also contain two filerefs, one for each of the PDF output files that will be described later. The filerefs will need to use the path of this third folder as the location in which to store these output files.
2. Create two user-defined formats that can be used to enhance the way values are displayed.
a. The first is to be a character format that will display the full gender name. Create the format so that upper or lower case M is displayed as Male, upper or lower case F is displayed as Female and any other values are displayed as Unknown.

b. The second format will be used to display salary ranges as defined below:
Anything $26,000 or less is displayed as Very Low.
Over $26,000 through $50,000 is Low.
Over $50,000 through $75,000 is Medium.
Over $75,000 through $100,000 is High.
Any value of more than $100,000 is Very High.
3. Write a PROC step that will send a listing of all the available styles to the default output destination.
5. Run a procedure to list all of the data sets in the Orion data library without showing the details of each data set.
The titles and footnote on your output must match the sample output files posted on eCampus.
7. Run a procedure that will print the descriptor portion of the Unicornstaff data set downloaded from eCampus.
8. Close the outputA destination so that it only contains the output of the two procedures executed above.
10. Close the second PDF destination and end the program with the appropriate housekeeping steps to ensure titles and footnotes do not carry over to the next program that is executed.
11. When you have your program running as desired without errors, close SAS then reopen it and run your program from a clean session.
12. Save or print the SAS log as a PDF file with a name like FKincheloe_HW03_log.pdf using your Net ID in place of FKincheloe.
13. Save the final version of the program and convert it to a PDF file with a name like FKincheloe_HW03_prog.pdf.
14. Post the four PDF documents on WebAssign.