Create a summary report of Clinic.Diabetes.

Creating HTML output? Read this first.

Copy and paste the following program into the Program Editor window:

proc report data=clinic.diabetes nowd; column id sex weight fastgluc postgluc; where age>40; define weight / format=comma6.2 spacing=4; define sex / width=7 spacing=4 center 'Sex of/Patient'; define fastgluc / 'Fasting/Glucose'; define postgluc / 'Postprandial/Glucose' width=12; define id / order descending; run;

Modify the program to define Sex as a group variable. Submit the program and view the report. Which variable is preventing PROC REPORT from collapsing observations? Recall the program, and revise it to remove the report column that is preventing grouping. Re-submit the program and view the summary report, which should contain two rows. Return here and select Next.