How to summarize 3 level data?

[RD2]

data teast;

do C1='A' , 'B', 'C', 'A' , 'B', 'C' ;

  do C2= '1' , '2', '3','1' , '2', '3';

   C3=IFC(round(ranuni(0)), 'YES','NO') ;

   output;

   end;

end;

run;

How can I summarize the above dataset as following? If possible with percentage beside.

*All Sublevel (C2-C3) combination  summary for  1^st  level  C1 . 

                                                           A                          B                           C

1- YES                                                 X                           X                           X

1-NO                                                   X                           X                           X

2-YES                                                   X                           X                           X

2-NO                                                   X                           X                           X

3- YES                                                  X                           X                           X

3-NO                                                   X                           X                           X

Thanks.

[shivas · Accepted solution]

Hi,

Is this what you want..

data test;

do C1='A' , 'B', 'C', 'A' , 'B', 'C' ;

  do C2= '1' , '2', '3','1' , '2', '3';

   C3=IFC(round(ranuni(0)), 'YES','NO') ;

   output;

   end;

end;

run;

proc tabulate data=test;

class c1 c2 c3;

tables c2=''*c3='',c1*n=''

;

run;

Thanks,

Shiva

[ballardw]

Which percentage do you want? Percentage of all record count, row count or column count?