Answer all questions.
Notes:
a) You will work in the assigned groups for this assignment.
b) At the end of the assignment, you will evaluate yourself and your group members. If the group evaluations indicate that a group member did not participate, this will affect that individual's score on the assignment. Complete the self and group evaluation assignment on Canvas.
c) For your assignment file name, include, course code, group number, and module number; for example, CHS762_Grp1_M2
d) List the names of the group members on the header section, in the top right-hand corner of the assignment document.
e) Use Word file format (unless otherwise specified).
f) Submit a combined file (Word) for the sections of your SAS Program, SAS Log, and SAS Output. Don’t upload the SAS files; instead, copy and paste SAS program, log, and output into the Word file.
g) It is strongly recommended that you review and practice with the following SAS programs, available on Web Campus (Canvas), before attempting this assignment:
a. UNR CHS 762 Reading data into SAS sample program
b. UNR CHS 762 Proc freq and proc means sample program
c. UNR CHS 762 Creating output destinations sample program
1. The following DATA step attempts to create 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.
Note: You can use the Snipping Tool (or other similar tool such as Snagit) to copy and paste the notes from the SAS log in this Word assignment document.
i. Identify and state the number of error(s) produced by this program. Paste the SAS log here to show these error(s). Do not include any SAS start-up messages. (1 point)
ii. Identify and state the number of notes produced by this program. Paste the SAS log here to show these notes. Do not include any SAS start-up messages. (3 points)
iii. Identify and state the warning produced by this program. Paste the SAS log here to show the warning. Do not include any SAS start-up messages. (2 points)
b) 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. (2 points)
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).
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. Paste the 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 and record this value as a comment in your SAS program. Paste your commented SAS program here. (2 points)
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. (3 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 in your program. Add a PROC PRINT statement to list the data in the BODYMASS data set and submit the revised program. Include a title for the proc print. Paste your SAS program, PROC PRINT, output, and log here. (4 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) Create a SAS data file with the preceding data using the INPUT statement; use PROC PRINT to print the dataset. Include two titles for the PROC PRINT output. Paste your SAS program, log, and PROC PRINT output here. (2 points)
b) Develop a SAS program to create a SAS library named “CHS762”. Paste your SAS program and log here. (3 points)
c) Use the INFILE statement to import the text data file “County1.txt”. The County1 text file has four columns with the following variables: ID, RACE, AGE, AND COUNTY. Save the imported data as a permanent data file in the CHS762 library. Use PROC PRINT to print the data you imported. Paste the SAS program, log, and PROC PRINT output here. (3 points)
Note: The county1.txt file is tab-delimited. Refer to example on program 4 in the “UNR CHS 762 reading data into SAS sample program” SAS program.
d) Include any two comments in the SAS program, in question 3 c, that provide information about the SAS program. (1 points)
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 and 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 SAS output has zero decimal places. Paste the SAS program, PROC MEANS output, and SAS log here. (2 points)
b) Add SAS statements that will output the PROC MEANS results from question 4a as a PDF file. Include a title and a footnote in the output. Paste the SAS program and log here. Upload on Canvas the PDF file with this assignment. (2 points)
c) 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. Paste the SAS program, log, and PROC FREQ output here. (2 points)
d) Add SAS statements that will output the one-way frequency table in question 4b as an Excel file. Include a title and a footnote in the output. 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”.
e) 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 output. Paste the SAS program and log here. (2 points)
f) Add SAS statements that will output the two-way frequency table in question 4e as a RTF file. Include a title and a footnote in the output. Paste the SAS program and log here. Upload on Canvas the RTF file with this assignment. (2 points)
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
