topic Re: Frequency and multiple variables in SAS Programming

Frequency and multiple variables

RandyStan — Sat, 07 Mar 2020 20:14:48 GMT

Dear All:

This is the code I wrote

Proc freq data = have;
Tables DIM;
Format DIM DIM_groups.;

0-50 = '0-50';

51-76 = '51-76'

76-100 = ''76-100'

>100 = '>100'
Run;

I also have two Variables -- VARA and VARB. I want to find the Average, MIN and MAX of those variables in each of these groups.

Can someone help?

Randy.

Re: Frequency and multiple variables

PaigeMiller — Sat, 07 Mar 2020 21:42:59 GMT

You can't mix PROC FREQ code with PROC FORMAT code. It should look like this:

proc format;
    value dim_groups 0-50='0-50' 51-76='51-76' ... ; /* You type the rest */
run;

proc freq data=have;
    tables dim;
    format dim dim_groups.;
run;

I also have two Variables -- VARA and VARB. I want to find the Average, MIN and MAX of those variables in each of these groups.

proc summary data=have;
    var vara varb;
    class dim;
    format dim dim_groups.;
    output out=stats mean= min=min_vara min_varb
        max=max_vara max_varb;
run;