SAS Day 37
Now, there is a question, what procedure should we apply to generate Categorical Variables (Sex, Race, Country)?
Today we will show how to use Proc Freq to summarize the Categorical Variables.
Subjid ID: 1-96
Sex: Female, Male
TRT: Treatment Group 1,2
Sample SAS Code:
%macro freq(in= , var= , out1= , out2= , sorter= ); proc freq data=&in noprint ; tables trt*&var /out=&out1 nopercent; run; proc sort data=&out1; by &var; run; proc transpose data=&out1 out=&out2(rename=(&var=label)) prefix=c; var count; by &var; id trt; run; data &out2; length label $100.; set &out2; sorter=&sorter; if sorter2=. then sorter2=2; drop _name_ _label_; run; %mend freq; %freq(in=adsl, var=sex, out1=s1, out2=s, sorter=2);
Warm Attention: This Macro Freq I generated based on my interest, maybe you can add and subtract to tailor your needs.