A study on weight loss in males was conducted over a five-month period. Participants came to a clinic at the beginning of each month, and their weight as well as their responses to six survey questions regarding weight loss were obtained. The raw data file WLSurveys.dat (found in the Box folder) contains variables for subject ID, height (in), weight (lb) at each of five visits, and responses to questions 1-6 at each of five visits. Note that the first six survey responses are from visit one, the next six survey responses are from visit two, and so on, for a total of 30 survey responses.

A. Examine the raw data file data WLSurveys.dat and read it into SAS.

B. The survey questions were measured on a scale of 0 (least) to 3 (most). However, the data were recorded inconsistently by data entry clerks; and questions 2, 3, and 5 (for every visit) were accidentally recorded in the reverse order (0 = most and 3 = least). Convert questions 2, 3, and 5 for every visit so that they are measured in the same direction as the other questions.

C. Missing data were recorded as -99. Reclassify these values as a period (.) to signify missing numeric data in SAS.

D. Calculate the subject's body mass index at each of the five visits as weight (lb) divided by height (in) squared, and then multiplied by 703.

E. Researchers would like to study the subjects that are classified as overweight or obese at the final visit. Use PROC SQL to create a data set that limits the data to those patients with a final visit body mass index that is 25.0 or more, and to also produce a report showing the resulting data.

F. In a comment in your program, find the 10th observation and state the subject ID, number of question variables with missing values, and the BMI at the last visit.