Stony Brook University

AMS 394

This is an open book exam. However, no communication is allowed between
students. Please provide complete SAS codes, necessary assumptions checking,
results and conclusions for full credit. Good luck! (Please save your codes in doc
document.)
Question 1 (30 points)
Name Sex Date_of_birth Height Weight
Alfred M 25OCT2001 72.0 122.5
Alice F 06APR2000 63.5 112.0
Carol F 14MAY1998 62.8 99.5
James M 21MAR2000 66.3 99.5
Jane F 02DEC2000 61.8 94.5
Janet F 15JUL1999 68.5 118.5
1. Write a SAS DATA step to read the data above. The list of variables is Name, Sex,
Date_of_birth, Height and Weight. Select the data on condition that Date_of_birth is
earlier than 2001 Jan 1st with an IF statement and print out the data set table after
selection with title ‘class data’.
2. Write a SAS PROC step to print out the observations on condition that the Weight less
than 100 in the data set after selection. Also change the format for Date_of_birth (e.g.
10/25/01, 04/06/00, 05/14/98).
3. Printout the whole data set without selection in descending order of their Weight, and
descending order of Name if the weights are the same.
4. Using the whole data set without selection, calculate the mean Height and mean Weight
separately for Male students an