Directions

Write appropriate SAS code to answer the following questions. Follow the directions carefully.

Type up your answers in a Word file.Copy, paste and label your SAS program code, your SAS log windows, and the resulting output into your Word document.Make sure you label each question so it is clear which code/log/output goes with each question. Upload your Word document as your submission for this assignment.

You will be graded on the accuracy, generalizability, and efficiency of your code.Absolutely no late submissions will be accepted.

Questions

2. (8 points) Read the data contained in thequestion02.datDownload question02.datfileusing a DATALINES statementinto apermanentSAS data set calledquestion02. The data in each record are in order: id number (idno), last name (name), team color (team), starting weight in pounds (strtwght), and ending weight (endwght). In the same data step in which you read the data into the SAS data set, create a new variable calledcategorythat is defined as follows:

if ending weight is less than 120, then category is 1

if ending weight is at least 120 but less than 150, then category is 2

if ending weight is at least 150 but less than 180, then category is 3

if ending weight is at least 180, then category is 4

Print the resulting SAS data setquestion02.

Note to the Tutor : Please the below is the question02.dat file mentioned in the above question

1023 ShawR 189 165

1049 SerranoY 145 124

1219 NanceR 210 192

1246 SinhaY 194 177

1078 McKnight R 127 118

1221 BrownY 220.

Note to the Tutor : Please when you answer the question for me, please send me a copy of the SAS code that you used in answering the question and the output. Thank you

Please the google docs link to access the question itself and its data can be found at:

https://docs.google.com/document/d/11p8zKiUAWfJYAWRD2o4l09SHcX8Z-DkV/edit?usp=sharing&ouid=111784480047729475081&rtpof=true&sd=true