Can you use drop/keep options in PROC MEANS?

[Nietzsche]

Is it possible? Cant seem to get it to work.

[PeterClemmensen]

You can use Drop / Keep Data Set Options all you want in the input / output data set. Hard to tell what is wrong without seeing your code, but I suspect you attempt to use Drop / Keep Statements. Which are not supported.

[ger15xxhcker]

Yes, you can use the DROP and KEEP options in PROC MEANS in SAS. Here is an example of how you can use them:

proc means data=mydata noprint;
var x y z;
drop xmean ymean zmean;
keep xstd ystd zstd;
run;

[PaigeMiller · Accepted solution]

---

@ger15xxhcker wrote:

Yes, you can use the DROP and KEEP options in PROC MEANS in SAS. Here is an example of how you can use them:

proc means data=mydata noprint;
var x y z;
drop xmean ymean zmean;
keep xstd ystd zstd;
run;

---

These are DROP or KEEP statements, not DROP or KEEP options. You cannot use DROP or KEEP statements in PROC MEANS. If I use:

proc means data=sashelp.class;
var height weight age;
drop age;
keep height;
run;

then the log says you can't use the DROP statements or KEEP statements:

 69         proc means data=sashelp.class;
 70         var height weight age;
 71         drop age;
 NOTE: The DROP and KEEP statements are not supported in procedure steps in this release of the SAS System. Therefore, these 
       statements are ignored.
 72         keep height;
 NOTE: The DROP and KEEP statements are not supported in procedure steps in this release of the SAS System. Therefore, these 
       statements are ignored.
 73         run;

What you can do is use the DROP or KEEP options.

proc means data=sashelp.class(drop=height);
run;