topic Re: proc freq by classes in SAS Programming

proc freq by classes

Satori — Thu, 02 Feb 2023 14:29:05 GMT

I want to run a proc freq for a numeric variable, but since there are many values I want to group them. How can I group them?

The variable is total_assets which takes virutally all values between 0 and infinity as far as I know.

What I would like is to get a table with frequencies for the variable total_assets by grouping them into:

0-5million

5-10million

10-20million

20-50million

50-100million

>100million

Any hints on how to do this?

Re: proc freq by classes

EyalGonen — Thu, 02 Feb 2023 15:00:45 GMT

You can create a user-written format that does the grouping and use it in your PROC FREQ

See example article: https://sasexamplecode.com/how-to-format-variables-in-proc-means-freq-and-tabulate-in-sas/

Re: proc freq by classes

PaigeMiller — Thu, 02 Feb 2023 15:12:32 GMT

Use a custom format

proc format;
    value assetf 0-5000000='0-5 Million'
         5000000<-10000000='5-10 Million'
         10000000<-20000000='10-20 Million'
         /* I'm lazy, you type the rest */
    ;
run;
proc freq data=have;
    tables total_assets;
    format total_assets assetf.;
run;