topic Save row percentages by group to data set in Proc Freq in Statistical Procedures

Save row percentages by group to data set in Proc Freq

Jason2020 — Thu, 11 Mar 2021 16:59:14 GMT

I want to save percentages by gender and province. This program only saves the frequencies and total percentages across all provinces. Any suggestions?

proc freq data=j1 ;

tables province*gender / out=Freq_gender list;

run;

Have:

Cumulative Cumulative

province Gender Frequency Percent Frequency Percent

-------------------------------------------------------------------------------------------

Aga 1 546 3.21 546 3.21

Aga 2 394 2.31 940 5.52

Want:

province Gender Frequency Row Percent

-------------------------------------------------------------

Aga 1 546 58.09

Aga 2 394 41.91

Re: Save row percentages by group to data set in Proc Freq

SAS_Rob — Thu, 11 Mar 2021 17:06:02 GMT

If you add the OUTPCT option to the TABLES statement, then that should give you what you need.

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=statug&docsetTarget=statug_freq_syntax08.htm&locale=en#statug.freq.freqoutpct

Re: Save row percentages by group to data set in Proc Freq

Jason2020 — Thu, 11 Mar 2021 17:12:41 GMT

Thank you very much.
I thought I read the documentation carefully, but obviously I did not.
Thanks again.