Hi thank you for your reply. I'm not sure what you mean by "If you don't want to nest variable then just place them together. If you want the same statistics for each group with parentheses." Your suggestion is close to what I'm looking for but I am creating this from a summary table rather than an observation level one. My data looks something like this, albeit with more rows: data retainreport;
infile datalines delimiter=',';
input site visitcode enrolled expected retained retainedpct;
datalines;
1,1,50,40,30,.75
1,2,50,30,20,.67
1,3,50,20,10,.5
1,4,50,10,0,0
;
run;
proc tabulate data=retainreport;
class site visitcode / order=data;
classlev site;
classlev visitcode;
var enrolled expected retained retainedpct;
table (site='')*
(enrolled*f=best12. expected*f=best12. retained*f=best12. retainedpct*f=percent6.),
visitcode*(sum='');
run;
... View more