topic Re: Removing frequencies in a table in SAS Programming

Removing frequencies in a table

carmong — Wed, 20 Mar 2024 20:08:39 GMT

I am attempting to create a table with only the row percentages. So far I have written code that has removed the column numbers and column percent's which has given me the table below:

proc freq data=pairs;
table admissiondate*def1 /NOCOL NOpercent out=freqmonth&today. outpct;
format admissiondate MONYY.;
run;

admissiondate	def1
	Associated	Associated	Total
	illness	non illness
20-Jan	1	0	1
	100	0
20-Feb	5	1	6
	83.33	16.67
20-Mar	780	63	843
	92.53	7.47
20-Apr	2770	276	3046
	90.94	9.06
20-May	2128	380	2508

How can I write a code which will provide me a table with only the row percent's like the one below?

admissiondate	def1
	Associated	Associated
	illness	non illness
20-Jan	100	0
20-Feb	83.33	16.67
20-Mar	92.53	7.47
20-Apr	90.94	9.06
20-May	84.85	15.15

Re: Removing frequencies in a table

Reeza — Wed, 20 Mar 2024 20:28:17 GMT

NOFREQ option needs to be added.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/procstat/procstat_freq_syntax08.htm#procstat.freq.freqnofreq

@carmong wrote:

I am attempting to create a table with only the row percentages. So far I have written code that has removed the column numbers and column percent's which has given me the table below:

proc freq data=pairs;
table admissiondate*def1 /NOCOL NOpercent out=freqmonth&today. outpct;
format admissiondate MONYY.;
run;

admissiondate def1

Associated Associated Total

illness non illness

20-Jan 1 0 1

100 0

20-Feb 5 1 6

83.33 16.67

20-Mar 780 63 843

92.53 7.47

20-Apr 2770 276 3046

90.94 9.06

20-May 2128 380 2508

How can I write a code which will provide me a table with only the row percent's like the one below?

admissiondate def1

Associated Associated

illness non illness

20-Jan 100 0

20-Feb 83.33 16.67

20-Mar 92.53 7.47

20-Apr 90.94 9.06

20-May 84.85 15.15

Re: Removing frequencies in a table

ballardw — Wed, 20 Mar 2024 21:34:40 GMT

Or perhaps a different procedure.

One way though the output data set will look a bit different. For one thing the percentage variable will have a different name because the data sets that Tabulate creates can have a lot more variables than the out= is allowed by Proc Freq.

proc tabulate data=pairs out=freqmonth&today.;
   class admissiondate def1;
   format admissiondate monyy.;
   table admissiondate,
         def1*rowpctn=' ';
run;

Note the rowpctn=' ' has a blank label for the statistic so the results won't show RowPctN in each column. Might not want to so if you were including other statistics like the ColPctN (freq column pct)