topic How to summarize 3 level data? in SAS Procedures

How to summarize 3 level data?

RD2 — Thu, 24 May 2012 10:01:16 GMT

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.

Re: How to summarize 3 level data?

shivas — Thu, 24 May 2012 11:46:20 GMT

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

Re: How to summarize 3 level data?

ballardw — Thu, 24 May 2012 14:11:46 GMT

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