topic Re: Reporting large numbers in SAS Programming

Reporting large numbers

bayzid — Tue, 09 May 2023 20:51:20 GMT

I have a very large number in a frequency table which SAS is abbreviating in the output as below. How can i get SAS to report all the digits?

Re: Reporting large numbers

PaigeMiller — Tue, 09 May 2023 21:05:50 GMT

see https://support.sas.com/resources/papers/proceedings17/SAS0404-2017.pdf

And hint hint hint for next time, I think you will get faster answers if you do a simple search first. I found that via a simple internet search for:

How to change formats in PROC FREQ

which took me less time than it takes to write a post here.

Re: Reporting large numbers

MayurJadhav — Tue, 09 May 2023 21:54:42 GMT

Hi @bayzid , You need to mention format after forward "table vars / "

format=comma14.

Refer this simple example where I've created 1B rows with same value (A++). It means when I run proc freq without any format, I'll also get the same value in hexadecimal format.

/* create a new dataset with 1B rows*/
data OneBillionRows (keep=rank);
	do i=1 to 1000000000;
		rank='A++';
		output;
	end;
run;

PROC FREQ without Format:

proc freq data=OneBillionRows;
   tables Rank*Rank / list all  ; 
run;

Output:

PROC FREQ with FORMAT

proc freq data=OneBillionRows;
   tables Rank*Rank / list all  format=comma14. ; 
run;

Output:

Re: Reporting large numbers

BayzidurRahman — Wed, 10 May 2023 01:32:35 GMT

Thanks very much.

Re: Reporting large numbers

bayzid — Wed, 10 May 2023 04:55:37 GMT

I am using the following code but still the same result.
proc freq data=sas.dosemed_all; tables ScheduleType/list all format=comma14.; run;

Re: Reporting large numbers

Ksharp — Wed, 10 May 2023 12:35:59 GMT

Customized CrossTabFreqs Template

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsproc/n1sbdyv873pfcmn1e3a8p2z4k055.htm

Re: Reporting large numbers

Watts — Wed, 10 May 2023 13:11:29 GMT

To format frequencies in a one-way frequency table, you can use the ONEWAY(FORMAT=) option in the TABLES statement.

proc freq data=sas.dosemed_all; 
    tables ScheduleType / oneway(format=comma14.);
run;

Re: Reporting large numbers

BayzidurRahman — Wed, 10 May 2023 13:15:32 GMT

14799  proc freq data=sas.dosemed_all;
14800      tables ScheduleType / oneway(format=comma14.);
                                 ------                -
                                 22                    22
                                 202                   200
ERROR 22-322: Syntax error, expecting one of the following: ;, AGREE, ALL, ALPHA, BDT, BIN,
              BINOMIAL, CELLCHI2, CHISQ, CL, CMH, CMH1, CMH2, COMMONRISKDIFF, COMONMRDIFF,
              CONTENTS, CONVERGE, CROSSLIST, CUMCOL, DEVIATION, EXACT, EXPECTED, FISHER,
              FORMAT, GAILSIMON, GS, JT, KAPPA, LINE, LIST, MAXITER, MAXLEVELS, MEASURES,
              MISSING, MISSPRINT, NOCOL, NOCUM, NOFREQ, NOPERCENT, NOPRINT, NOROW, NOSPARSE,
              NOWARN, ODDSRATIO, OR, OUT, OUTCUM, OUTEXPECT, OUTPCT, PEARSONRES, PEARSONRESID,
              PLCORR, PLOTS, PRINTKWTS, PRINTWTS, RELRISK, RISKDIFF, SCORE, SCORES, SCOROUT,
              SENSPEC, SPARSE, STDRES, STDRESID, TABLE, TESTF, TESTP, TOTPCT, TREND, WARN.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
ERROR 200-322: The symbol is not recognized and will be ignored.
14801  run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds

Re: Reporting large numbers

Watts — Wed, 10 May 2023 13:42:28 GMT

The ONEWAY(FORMAT=) option is available in PROC FREQ beginning in release 2020.1 (Viya 4).

Alternatively, you can change the format of frequencies in one-way tables by modifying the template. There's an example in Usage Note 37442: Modifying the OneWayFreqs template.

Re: Reporting large numbers

MayurJadhav — Wed, 10 May 2023 14:27:01 GMT

As explained by @Watts, Base.Freq.OneWayFreqs can solve this formatting problem.

Here is the same example adjusted according to what you're looking for! @bayzid

ods path reset;
ods path (prepend) work.templat(update);
ods path show;

proc template;
   edit Base.Freq.OneWayFreqs; column Line FVariable FListVariable Variable Frequency
        TestFrequency Percent TestPercent CumFrequency CumPercent;
      edit frequency;
         format=comma14.;
      end;
      edit percent;
         format=8.3;
      end;
   end;
run;
proc freq data=OneBillionRows;
   tables Rank / list all nocum  ; 
run;

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