topic Re: Format for Proc Freq in SAS Enterprise Guide

Format for Proc Freq

deleted_user — Wed, 07 May 2008 07:40:28 GMT

Hi. I am running a proc freq and I would like to change the format of the results (e.g. I want to change the results to show only 1 decimal place and maybe a percentage sign after the value). Note that it is the results from the proc freq that I want to format, not the variable itself. Thanks.

Re: Format for Proc Freq

deleted_user — Wed, 07 May 2008 12:44:54 GMT

You can output the results of the proc freq to a dataset and then use that dataset in a proc print or proc report where you can customize the results to your hearts content.

Re: Format for Proc Freq

Cynthia_sas — Wed, 07 May 2008 14:13:58 GMT

Hi:
You can either do as Chuck suggests and create your report from a dataset created by PROC FREQ or you can change the TABLE template for this run of PROC FREQ and tell the template what format to use for the calculated statistics. This Tech Support note talks about doing something simliar (it shows one decimal place but not the percent sign):
http://support.sas.com/kb/25/058.html

cynthia

Re: Format for Proc Freq

deleted_user — Fri, 23 May 2008 15:11:07 GMT

That's great, thanks! Message was edited by: RobD