write my assignment 10476

help with sas….

Using the clinical data set, write a SAS program that creates a temporary SAS data set called fat that contains only one observation per patient and the following seven variables:

• patient: the patient ID number
• gender: the patient’s gender (Male or Female)
• group: the patient’s treatment group (A, B, or C)
• weight1: the patient’s weight at his/her first visit
• weight2: the patient’s weight at his/her second visit (if there isn’t a second visit, set it to missing)
• weight3: the patient’s weight at his/her third visit (if there isn’t a third visit, set it to missing)
• weight4: the patient’s weight at his/her fourth visit (if there isn’t a fourth visit, set it to missing)

You can, and therefore should, accomplish the task using just one DATA step. The keys again to accomplishing the task are using a BY statement, some IF statements with some first. and last. variables, as well as a RETAIN and OUTPUT statement. Print your resulting data set.