Adding more decimals to the proc freq procedure

[BenBrady]

I want to add more decimal places to the percent column of the output created by proc freq in sas. I have a percent now of 87.76 but I would like this to 4 decimal places. The template for this is Base.Freq.OneWayFreqs. The code I am currently using is:

proc freq data=cat;

table food;

weight weight;

run;

[SASKiwi]

One way to get what you want is to output a table in PROC FREQ and then use PROC PRINT as this example shows:

http://support.sas.com/documentation/cdl/en/procstat/68142/HTML/default/viewer.htm#procstat_freq_exa...

[SuzanneDorinski · Accepted solution]

You can edit the template.  

* use ODS PATH statement so that you don't overwrite templates ;
* that shipped with SAS! ;

ODS PATH WORK.TEMPLAT(UPDATE) SASHELP.Tmplmst(READ);

proc template;
  edit Base.Freq.OneWayList;  
	edit Percent;
	  format=7.4 ;           
	end;
	edit CumPercent;
	  format=7.4 ;
	end;
  end;
run;

proc freq data=sashelp.class;
  tables height weight;
run;

* delete the edited template ;

proc template;
  delete Base.Freq.OneWayList;
run;