Frequency and multiple variables

[RandyStan]

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.

[PaigeMiller]

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;