Calcite | Level 5

## How to make a frequency table with statistics values?

Hi,

I am trying to make a table similar to this one below with the data I have attached. I cannot seem to figure out how to use proc freq to generate the frequencies, proc means ( or proc univariate ) to generate the statistics values and then combine them in this way into a table. If anyone could give me any pointers on how to start that would be awesome! thanks so much!

Also these are the assumptions:

Treatment:

1 = Active
0 = Placebo

Gender:
1 = Male
2 = Female

Race
1 = White
2 = Black
3 = Other

2 REPLIES 2
SAS Employee

## Re: How to make a frequency table with statistics values?

Hi,

You can create a table for each purpose using PROC FREQ and PROC MEANS, and then join them with PROC SQL. You also need to create formats.

``````
* I have the data set adsl in this path;

* Defining formats;
proc format lib=work;
value gender
1 = Male
2 = Female
;
value race
1 = White
2 = Black
3 = Other
;
value treatment
1 = Active
0 = Placebo
;
run;

* Applying formats to the data set ;
proc datasets lib=a;
format gender gender. race race. trt treatment.;
quit;

* Sorting by treatment;
by trt;
run;

* Statistics ;
proc means data=a.adsl n mean std min max;
by trt;
var age;
output out=work.means1;
run;

proc means data=a.adsl n mean std min max;
var age;
output out=work.means2;
run;

* Frequencies;
table trt*gender/out=work.freq1 nocol nopercent;
run;

table gender/out=work.freq2 ;
run;

table trt*race/out=work.freq3 nocol nopercent;
run;

table race/out=work.freq4 ;
run;

``````

I hope this is useful for you.

Calcite | Level 5

## Re: How to make a frequency table with statistics values?

This is super helpful! How would you then combine them using PROC SQL?

Discussion stats
• 2 replies
• 558 views
• 0 likes
• 2 in conversation