topic Re: two way proc freq -questions in SAS Programming

two way proc freq -questions

Ronein — Thu, 11 Apr 2019 04:25:33 GMT

Hello

I am using proc freq to calculate two way distribution.

I want to calculate only percentage from total.

I have some questions please:

1-In the printed output I see a row "Total frequency". How can I delete this row? I want to show only percent ...

2-The percent is displayed without % symbol. How can I add it?

DATA auto ;
LENGTH make $ 20 ;
INPUT make $ 1-17 price mpg rep78 modtype ;
CARDS;
AMC Concord        4099 22 3 2
AMC Pacer          4749 17 3 2
Audi 5000          9690 17 5 3
Audi Fox           6295 23 3 1
BMW 320i           9735 25 4 1
Buick Century      4816 20 3 2
Buick Electra      7827 15 4 2
Buick LeSabre      5788 18 3 2
Cad. Eldorado     14500 14 2 3
Olds Starfire      4195 24 1 2
Olds Toronado     10371 16 3 2
Plym. Volare       4060 18 2 2
Pont. Catalina     5798 18 4 2
Pont. Firebird     4934 18 1 1
Pont. Grand Prix   5222 19 3 2
Pont. Le Mans      4723 19 3 1
;
RUN;


Title;
proc freq data=auto ; 
table modtype*make/missing norow  nocol  nofreq  ; 
run;

Re: two way proc freq -questions

ChrisNZ — Thu, 11 Apr 2019 05:23:31 GMT

1-In the printed output I see a row "Total frequency". How can I delete this row?

The documentation is your friend.

2-The percent is displayed without % symbol. How can I add it?

This is not straight forward and requires that you customise the default output with proc template.

See

http://support.sas.com/resources/papers/freq92.pdf

https://www.lexjansen.com/nesug/nesug06/po/po09.pdf

Re: two way proc freq -questions

Ronein — Thu, 11 Apr 2019 06:17:41 GMT

Thank you.

I still didn't find solution to "How to remove total frequency row"

Re: two way proc freq -questions

andreas_lds — Thu, 11 Apr 2019 06:43:12 GMT

Have you tried using nocum-option? See: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=statug&docsetTarget=statug_freq_syntax08.htm&locale=de#statug.freq.freqnocum

Re: two way proc freq -questions

Astounding — Thu, 11 Apr 2019 08:14:37 GMT

One approach that could handle both questions: switch from PROC FREQ to PROC TABULATE. However, there is definitely a learning curve involved.