## How to summarize 3 level data?

Solved
Occasional Contributor
Posts: 16

# How to summarize 3 level data?

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  1st  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.

Accepted Solutions
Solution
‎05-24-2012 07:46 AM
Super Contributor
Posts: 350

## Re: How to summarize 3 level data?

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

All Replies
Solution
‎05-24-2012 07:46 AM
Super Contributor
Posts: 350

## Re: How to summarize 3 level data?

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

Super User
Posts: 13,583

## Re: How to summarize 3 level data?

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

🔒 This topic is solved and locked.