PROC MEANS output

[Kafi]

Hi everyone,

this is a beginner's question, but I can't find anything similiar in the forum.

I use proc MEANS to determine min and max values:

PROC MEANS DATA=WORK.PARCELDT MIN MAX;  

VAR WEIGHT;                             

CLASS WEEKNUM CARTON LENGHT WIDTH THICK;

The output is:

WEEKNUM     CARTON     LENGHT     WIDTH     THICK     N Obs     Minimum     Maximum

    1                       0     800     650     300     1     167000     167000

                                  1200     800     1200     1     59000     59000

                                1700     1300     960     1     675000     675000

                           17     750     750     480     102     23000     716000

But it shoud be as following:

WEEKNUM     CARTON     LENGHT     WIDTH     THICK     N Obs     Minimum     Maximum

    1                       0     800     650     300     1     167000     167000

    1                       0     1200     800     1200     1     59000     59000

    1                       0     1700     1300     960     1     675000     675000

    1                       17     750     750     480     102     23000     716000

Are there an output options for this?

Thanks!

Kathy

[Tom · Accepted solution]

Are you talking about the appearance of the report that PROC MEANS produces?  If you ask it to create a dataset the values are there, it is just that the report does not replicate the common values so that it is easier to read.

proc means data=work.parceldt nway noprint ;

  class weeknum carton lenght width thick;

  var weight;

  output out=want min= max= /autoname ;

run;

proc print data=want;

run;

[Kafi]

easy

I tried proc print as well, but I missed the NWAY option :smileyblush:

Thank you!