Proc Freq percent format SAS 9.4

Whitlea — Tue, 25 Feb 2020 17:09:12 GMT

How can I format my percent in this proc freq? I have tried every percent variable name I can think of and non of them work. If "Percent" is printed in the table being generated, why is it telling me there is no percent variable?

PROC FREQ DATA=data ;
TABLE Program*Award / nocol norow;
label Program='Program Type';
label Award='Amount Awarded';
format award dollar10. Percent f5.1 ;

RUN;

Re: Proc Freq percent format SAS 9.4

Reeza — Tue, 25 Feb 2020 17:24:42 GMT

PROC FREQ doesn't support formatting easily. I would recommend using PROC TABULATE instead, but you'll have to manually specify the percentages which is annoying as well.

@Whitlea wrote:

How can I format my percent in this proc freq? I have tried every percent variable name I can think of and non of them work. If "Percent" is printed in the table being generated, why is it telling me there is no percent variable?

PROC FREQ DATA=data ;
TABLE Program*Award / nocol norow;
label Program='Program Type';
label Award='Amount Awarded';
format award dollar10. Percent f5.1 ;

RUN;

topic Proc Freq percent format SAS 9.4 in SAS Programming

Proc Freq percent format SAS 9.4

Re: Proc Freq percent format SAS 9.4