I need assistance with a SAS assignment
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; 0. 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. 0. 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) 0. 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) 0. 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) 0. 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) 0. Looking at the “NOTES” in the SAS log from question 1b, how many observations and variables were created in this dataset? (1 point) 1. 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) A single asterisk means multiply *********************************************************/ data bodymass; weight = 150; height = 68; bmi = (weight / height ** 2) * 703; run; 1. Copy and paste the preceding program into the SAS editor and submit it. Paste the program and log here. (1 point) 1. 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) 1. 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 1. 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) 1. 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 1. 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) 1. Develop a SAS program to create a SAS library named “CHS762”. Paste your SAS program and log here. (3 points) 1. 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. 1. Include any two comments in the SAS program, in question 3 c, that provide information about the SAS program. (1 points) 1. 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. 1. 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) 1. 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) 1. 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) 1. 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”. 1. 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) 1. 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) Ids,Major,Height,English,State 43783,,72.35,88.24,In state 20278,Philosophy,70.66,89.45, 20389,,70.68,96.73,In state 22820,business administration,,74.06,In state 24559,,67.43,82.61,Out of state 28980,astrophysics,68.45,70.1,In state 33312,Anthropology,68.56,78.98,In state 40274,American History,71.91,,In state 40390,Africana studies,68.84,75.65,In state 28942,,66.69,68.27,Out of state 29045,French,70.12,86,Out of state 35676,history,66.91,79.94,In state 38764,,65.21,101.95,In state 39796,,72.35,88.97,Out of state 41092,"engineering, undecided",67.12,91.79,In state 43344,Fine Arts (Painting),,70.42,In state 49688,education,79,97.23,In state 37701,,63.12,85.71,In state 44116,Exorcise Science,69.25,82.99,In state 25871,saxophone,,83.95,In state 26154,mathematics,58.8,74.88,In state 41291,,71.67,84.67,Out of state 46752,Education Administration,61.94,99.51,In state 20183,Creative writing,66.92,83.3,In state 23643,,,80.86, 40303,,59.59,84.67, 27496,,67.51,74.85,In state 26582,Journalism,73.71,85.67, 46919,,72.26,82.56,In state 20230,pre-pharma,80.11,81.6,In state 21083,,72.05,78.85,In state 21939,,66.09,87.7,In state 23017,,71.72,76.63,In state 23217,Pre Med,71.41,75.2,In state 23889,communication,70.29,81.74,In state 24985,Biology,67.27,,In state 25382,,71.72,87.54,In state 25701,Chemistry,62.36,83.97,In state 26140,Aeronautics (Air Traffic,69.02,83.15,Out of state 29142,Soc,68.67,89.48,Out of state 30056,Poli Sci,72.17,81.35,In state 30164,,69.58,71.07,In state 30953,,,72.79,In state 31227,art historyy,68.38,82.28,In state 31862,,73.25,75.44,In state 32521,Art history,77.49,76.9,In state 33055,,69.78,,In state 33153,,64.82,,In state 34417,,67.54,80.95,In state 34717,,76.97,76.47,In state 35023,,62.46,94.43,Out of state 35599,,67.29,74.07,In state 36555,,72.69,70.48,In state 38134,agricultural studies,64.9,84.95,In state 38528,,62.42,85.24,Out of state 38775,Finance,70.58,79.64,In state 38980,bio,74.92,88.44,In state 39006,Theare,67.56,89.49,In state 39341,,73.48,77.64, 39542,Engineering,73.06,75.38,In state 39715,environmental policy,,,In state 40161,Classics,61.22,87.87,Out of state 40619,media literacy,65.7,82.24,In state 41288,,69.63,79.48,Out of state 41254,ancient studies,56.54,85.53,Out of state 42023,,63.63,72.31,Out of state 42630,,84.41,71.29,In state 42850,Higher Ed,62.84,60.96,In state 42769,Psych,60.15,75.07,In state 43221,,66.17,76.23,In state 44088,Music Education,75.91,85.34,In state 44413,Pre-med,69.43,86.85,In state 44517,Environmental Science,66.07,69.81,In state 46221,liberal Studies,66.29,82.49,In state 47050,psycho,62.89,84.3,In state 47887,photograPhy,,86.59,In state 48361,sport and exercise scien,83.73,95.23,In state 49213,Geograph,74.32,89.3,In state 49326,,72.85,69.48,In state 49155,English,62.2,77.17,In state 20531,,,93.69,In state 20615,photography,66.4,85.44,In state 21492,Art Education,63.88,81.83,In state 22069,,72.57,83.19, 22567,sports medicine,64.43,80.07,In state 23767,French,66.82,77.42,In state 23937,Theatre,62.59,83.79,In state 24153,Education - Science,62.12,81,Out of state 24202,,57.4,79,Out of state 24556,finance,,84.09,In state 24656,interior design,67.11,81.68,In state 25740,,66.97,82.56,In state 26435,,58.18,77.97,In state 26707,Applied Math,77.91,83.82,Out of state 26691,,63.91,85.27,Out of state 27539,Graphic Design,74.57,85.43,In state 49947,marketting,68.32,71.12,In state 29516,,62.98,83.57,In state 30826,,65.62,86.02,In state 30989,Undecided,65.05,90.44, 32304,Aerospace engineering,67.24