Save row percentages by group to data set in Proc Freq

[Jason2020]

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

[SAS_Rob · Accepted solution]

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=st... 

[Jason2020]

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