Any ideas on how to create a report? (picture included)

[AVUH777]

Forgot to add that I grouped by grade_level before calculating frequencies. I'm not looking for an exact way to create the report. Just an idea to eliminate the hand calculations and create a similarly formatted report.

[ballardw · Accepted solution]

An example that creates a report of similar structure using a SAS supplied data set you should be able to use:

proc tabulate data=sashelp.class;
   class sex age;
   tables age,
          sex=''*n='' all=''*(n='Total' pctn='%')
          /misstext=' '
   ;
run;

The ='' bits are suppressing default  labels.

Sex is basically the same as your Gender variable for role, Age as grade.

There are many appearance options available.

[AVUH777]

Thank you so much! This was very helpful.