Proc frequency how to get summary

dineshhnk — Fri, 21 Feb 2020 04:32:36 GMT

I have a dataset like vital as below.

there are total 3 trt possible values 1,0,2

My report should has below format, how can I do it ?

As proc frequency will give me only 2(40 %) and 3(60 % ), and not 0% for Trt3 and total n and %

Characteristic Trt0 Trt1 Trt3 Total

Number of Subjects 2 (40%) 3 (60%) 0 (0%) 5 (100 %)

data vital;
input subjid trt age GENDER race $ sysp diasp pulse ;
datalines ;
1 1 20 1 Asia 120 60 80
2 0 25 1 America 108 70 .
3 1 35 1 Asia 110 87 68
4 1 20 0 Indian 120 60 85
5 0 42 0 Middle 104 85 63
;
run;

Re: Proc frequency how to get summary

ed_sas_member — Fri, 21 Feb 2020 12:04:26 GMT

Hi @dineshhnk

You can use a format to define all the modalities (even if not observed) and then use the 'preloadfmt' and 'printmiss' options in proc tabulate:

data vital;
	input subjid trt age GENDER race $ sysp diasp pulse;
	datalines;
1 1 20 1 Asia 120 60 80
2 0 25 1 America 108 70 .
3 1 35 1 Asia 110 87 68
4 1 20 0 Indian 120 60 85
5 0 42 0 Middle 104 85 63
;
run;

proc format;
	value trtfmt 0='Trt0' 1='Trt1' 2='Trt2';
run;

option missing=0;

proc tabulate data=vital;
	class trt / preloadfmt;
	table (trt='Characteristic' all) * (n='Number of Subjects' pctn='%') / printmiss;
	format trt trtfmt.;
run;

All the best,

topic Proc frequency how to get summary in SAS Procedures

Proc frequency how to get summary

Re: Proc frequency how to get summary