Description

• Create a library named “HW3” that points to the same location you store any SAS files for this assignment.
• Write a data set to import the LIC 702-P.txt file into your library. (This is a real data set of licensure data for dental hygienists. Notice that some of the people still have AOL e-mail accounts, which I didn’t even know still existed!) Use a fileref but pay attention to the structure of the file when reading it in. Only the dates should be numeric and they should be formatted in the data set to match the formatting in the original file.
• Using the Fish SAS data set from your ST555 library, produce a report that does the following. I’ve included a screenshot of the last two pages of a similar report for reference.
– Guaranteed to start page numbering at 1
– Prints lines of width 85 and pages of size 60
– Produces the sums shown in the report, without sums for other variables
– Requires new pages for each new value of lake type
– Tracks each lake using its name and all latitude/longitude values
– Applies the necessary formats to use at most 2 characters of printed width for latitude/longitude
– Applies the necessary formats to have the runoff factor (RF) and flushing rate (FR) columns appear as shown in my report.
• Some summary statistics have been computed via PROC MEANS for the Fish data set you just printed. Those statistics are stored in the PROGHW03 STATZ file provided on the shared drive. You need to do the following:
– For the variables HG (mercury level), ELV (elevation), and Z (depth) compute the sample size, mean, and standard deviation using PROC MEANS (without printing them to any output destination – use the NOPRINT option in the PROC MEANS statement for this). Save only the means (for all variables) to a temporary data set.
– Use PROC COMPARE to determine if there any differences between my file (BASE=) and your file (COMPARE=). The output data set should be named DIFF and only include records related to input records that do not match.
– Place a comment in your code that briefly describes any differences that appear in the data set DIFF as well as noting if there are differences between our two data sets that are not apparent by looking at the DIFF data set.