topic Formatting Scientific Notation in PROC FREQ in SAS Programming

Formatting Scientific Notation in PROC FREQ

sasmaverick — Sun, 25 Dec 2016 06:13:16 GMT

I see that when I apply proc freq on a variable in a large dataset, the result gets truncated to scientific notation. Eg. for the below on a dataset of 35 Million records

Proc freq data=sales;
Tables region;
Run;

Gives me the frequencies like follows

US 2.15E8
UK. 1.59E7
EMEA 100000

I want the numbers to appear completely with a comma separator.

I tried using formats (best12. and comma12.) in the tables statment but to no avail.

Help appreciated!
Sasmaverick

Re: Formatting Scientific Notation in PROC FREQ

Reeza — Sun, 25 Dec 2016 06:29:53 GMT

Switch to proc tabulate and you can format the numbers easily. Otherwise google 'PROC FREQ TEMPLATE' for examples on how to modify the template for PROC FREQ to have it show the values as you want.

Re: Formatting Scientific Notation in PROC FREQ

Ksharp — Sun, 25 Dec 2016 06:47:53 GMT

An alternative way is using SQL.

proc sql;
create table want as
 select region,count(*) as count format=f12.
  from sales
   group by region;
quit;

Re: Formatting Scientific Notation in PROC FREQ

sasmaverick — Mon, 26 Dec 2016 09:06:35 GMT

Thank you, I was able to do it by setting default formats for frequencies by using PROC Template.