data have;
infile datalines dsd;
input treatment_group :$15. agegroup $ patientid group1 $ group2 :$20.;
datalines;
treatment,adult,1,ONE,headache
treatment,adult,1,ONE,fever
treatment,adult,1,ONE,cough
treatment,child,2,ONE,cough
treatment,child,3,TWO,heart disease
treatment,child,3,TWO,smoker
treatment,adult,4,TWO,heart disease
placebo,adult,5,ONE,headache
placebo,adult,5,ONE,cough
placebo,child,6,ONE,pneumonia
placebo,child,6,TWO,heart disease
placebo,child,7,TWO,heart disease
placebo,child,7,TWO,smoker
;
run;
proc sort data=have;
by treatment_group agegroup;
run;
proc freq data=have noprint;
by treatment_group agegroup;
tables group1*group2 / out=have2(drop=percent rename=count=event);
run;
proc sql;
create table want as
select
*
, sum(event) as total_event
from have2
group by 1,2,3
;quit;
... View more