topic Re: How to make a frequency table with statistics values? in SAS Studio

How to make a frequency table with statistics values?

ellpap — Sat, 01 May 2021 22:40:08 GMT

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

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

joseenrique1 — Sun, 02 May 2021 01:44:26 GMT

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;
libname a  "C:\Users\jenri\Downloads";

* 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;
	modify adsl;
	format gender gender. race race. trt treatment.;	
quit;

* Sorting by treatment;
proc sort data=a.adsl out=a.adsl;
	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;
proc freq data=a.adsl;
	table trt*gender/out=work.freq1 nocol nopercent;
run;

proc freq data=a.adsl;
	table gender/out=work.freq2 ;
run;

proc freq data=a.adsl;
	table trt*race/out=work.freq3 nocol nopercent;
run;

proc freq data=a.adsl;
	table race/out=work.freq4 ;
run;

I hope this is useful for you.

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

ellpap — Mon, 03 May 2021 19:17:57 GMT

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