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
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;
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;
easy
I tried proc print as well, but I missed the NWAY option :smileyblush:
Thank you!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: