Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Biostatistics Biostatistics 2) The csv data file \"student1\" contains informati

ID: 3059013 • Letter: B

Question

Biostatistics Biostatistics 2) 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. CSV (Comma lmitkd 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 below your SAS program, proc means output, and SAS log. (2 points) b) Add SAS code that will output the proc means results question a) above as a pdf file. Include a title and a footnote in your output. Paste your SAS program and log below. Upload your pdf file with this assignment in Web Campus (Canvas). (2 points) 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 your SAS program, proc freq output and SAS log below. (2 points) ) d) Add SAS code that will output the one-way frequency table in question c) above as an Excel file. Include a title and a footnote in your output. Paste your SAS program and log below. Upload your Excel file with this assignment in Web Campus (Canvas). (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. Microsoft Excel The file format and extension of 'studentxds dont match. The file could be comupted or unsafe. Unless you trust its source, dont open it Do you want to open it anyway? Yes No 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 your SAS program and log below. (2 points) Page 2

Explanation / Answer

Biostatistics Biostatistics 2) 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. CSV (Comma lmitkd 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 below your SAS program, proc means output, and SAS log. (2 points) b) Add SAS code that will output the proc means results question a) above as a pdf file. Include a title and a footnote in your output. Paste your SAS program and log below. Upload your pdf file with this assignment in Web Campus (Canvas). (2 points) 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 your SAS program, proc freq output and SAS log below. (2 points) ) d) Add SAS code that will output the one-way frequency table in question c) above as an Excel file. Include a title and a footnote in your output. Paste your SAS program and log below. Upload your Excel file with this assignment in Web Campus (Canvas). (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. Microsoft Excel The file format and extension of 'studentxds dont match. The file could be comupted or unsafe. Unless you trust its source, dont open it Do you want to open it anyway? Yes No 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 your SAS program and log below. (2 points) Page 2