topic Re: Proc Means in SAS Procedures

Proc Means

robertrao — Mon, 01 Oct 2012 18:00:23 GMT

Hi Team,

When i run this code I get a WARNING!!!!!

Could you explain please where I went wrong???

Thanks

proc means data=grafts nway noprint;

var age;

output out=mean_grafts n= mean= std= median= min= max=;

run;

WARNING: Variable AGE already exists on file WORK.MEAN_GRAFTS.

WARNING: The duplicate variables will not be included in the output data set of the output

statement number 1.

Re: Proc Means

PaigeMiller — Mon, 01 Oct 2012 18:05:05 GMT

YOur output statement is trying to assign the variable name AGE to the results of N=, and then it is trying to assign the variable name AGE to the results of MEAN=, and so on. Can't be done. You can't have multiple variables named AGE.

You need to give each of the statistics that you request in your OUTPUT statement a distinct name, or use the /autoname option.

Re: Proc Means

robertrao — Mon, 01 Oct 2012 18:09:35 GMT

OOPs. I used autoname this time and it worked out.

Thanks

Paige

proc means data=grafts nway noprint;

var age;

output out=mean_grafts n= mean= std= median= min= max=/autoname;

run;