The following DATA step attempts to crea
te a SAS dataset that contains information
from Nevada 2017 County Health Rankings and Roadmaps.
data healthrank;
State = ‘Nevada’;
Fipscode = ‘32000’
PercentPoorHealth = 17;
PercentLBW = ‘8’;
run;
a) Copy the preceding program into the SAS editor and submit it. Review the
information in the SAS log.
i. Identify and state below the number of error(s) produced by this program.
Copy and paste the SAS log here to show these error(s). Do not include
any SAS start-up messages. (1 point)
ii. Identify and state below the number of notes produced by this program.
Copy and paste the SAS log here to show these notes. Do not include any
SAS start-up messages. (1.5 points)
iii. Identify and state below the warning produced by this program. Paste the
SAS log here to show the warning. Do not include any SAS start-up
messages. (1 point)
Revise the program to fix the programming mistakes and then resubmit the revised
SAS program. Copy and paste your revised SAS program and the SAS log here.
(1 point)
c) Looking at the “NOTES” in the SAS log from question 1b, how many
observations and variables were created in this dataset? (1 point)
2. The body mass index (BMI) is a measure used as a rough indicator of an individual’s
body fat. The following program computes BMI using weight (in pounds) and height (in
inches).
/*********************************************************
Compute body mass index using pounds and inches
The two asterisks are used to square (height squared)
In SAS, a single asterisk means multiply. Two asterisks
means the values are squared.
*********************************************************/
data bodymass;
weight = 150;
height = 68;
bmi = (weight / height ** 2) * 703;
run;
a) Copy and paste the preceding program into the SAS editor and submit it. Copy and paste
the SAS program and log here. (1 point)
b) The program in question a) creates a SAS dataset named BODYMASS in SAS Work
library. View the data set. Find the value that was calculated for the BMI variable andrecord this value as a comment in your SAS program. Paste your commented SAS
program here. (1 point)
c) View the properties of this data set. Find the types and lengths for the variables and
record them as comments in your program. Paste your commented SAS program here.
(1.5 points)
Note: To view the properties, go to the SAS Explorer Work bodymass right
click on the bodymass dataset properties Columns tab
d) Choose different values for the weight and height variables for the SAS program. Add a
PROC PRINT statement to print the BODYMASS data set.
Submit the revised SAS program. Include a title for the PROC PRINT.
Copy and paste here the data step and PROC PRINT SAS programs, the data step and
PROC PRINT SAS log, and PROC PRINT table. (2 points)
3) Following is data for five students and their homework scores.
Fname Lname ID homewk1 homewk2
John Smith NV111 8 7
Mary Johnson IL222 9 7
Mark Miller UT333 10 8
Jay Chavez K444 6 10
Cynthia Ragan CA555 10 10
a) i. Create a SAS data file with the preceding data using the INPUT statement. Copy
and paste here the SAS program and SAS log. (2 points)
ii. Use PROC PRINT to print the dataset in question a I above. Include two titles on
the PROC PRINT output. Copy and paste here the SAS program and SAS log. (2
points)
b) Develop a SAS program to create a SAS library named “CHS762”. Paste your SAS
program and log here. (2 points)
c) i. Use the INFILE statement to import the “County1.txt” text data file. The County1
text file has the following four variables: ID, RACE, AGE, AND COUNTY.
Copy and paste the SAS program and SAS log here. (2 points)
Note: The county1.txt file is tab-delimited. Refer to the example on program 4 in
the “UNR CHS 762 reading data into SAS sample program” SAS program.
ii. Save the imported data as a permanent data file in the CHS762 library. Copy and
paste the SAS program and SAS log here. (1 point)
iii. Use PROC PRINT to print the data you imported. Copy and paste the SAS
program, SAS log, and PROC PRINT table here. (2 points)
d) Include any two comments in the SAS program, in question 3 c, that provide information
about the SAS program. Copy and paste here the SAS program with the comments. (1
point)
4) The csv data file “student1” contains information about students at a Western college.
The variables in the file are IDS, MAJOR, HEIGHT, ENGLISH, and STATE.
a) Import the csv data file “student1” into SAS. Copy and paste here the SAS program and
log. (2 points)
b) Use PROC MEANS to compute the mean height and mean English score (variable names
“height” and “English”). Use a PROC MEANS option so that the values on the PROC
PRINT have zero decimal places. Copy and paste the SAS program, SAS log, and PROC
MEANS table here. (2 points)
c) Add SAS statements that will output the PROC MEANS results from question 4b as a
PDF file. Include a title and a footnote in the output. Copy and paste the SAS program
and log here. Upload on Canvas the PDF file with this assignment. (2 points)
d) Use a one-way PROC FREQ to compute the number of students who were in-state and
out of state (variable name is STATE). Use PROC FREQ options such that there is no
cumulative frequency. Copy and paste the SAS program, log, and PROC FREQ table
here. (2 points)
e) Add SAS statements that will output the one-way frequency table in question 4d as an
Excel file. Include a title and a footnote in the output. Copy and paste the SAS program
and log here. Upload on Canvas the Excel file with this assignment. (2 points)
Note: The following message will appear when you click on the open the Excel file.
Ignore the message and open the Excel file by clicking “Yes”.
) Use a two-way PROC FREQ to compute the number of students by major and state
(variable names MAJOR and STATE respectively). Use PROC FREQ options such that
there is no percent, row percent, or column percent on the table. Copy and paste the SAS
program and log here. (2 points)
g) Add SAS statements that will output the two-way frequency table in question 4f as a RTF
file. Include a title and a footnote in the output. Copy and paste the SAS program and log
here. Upload on Canvas the RTF file with this assignment. (2 points)