Proc Means

[robertrao]

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: Variable AGE already exists on file WORK.MEAN_GRAFTS.

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

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

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.

[PaigeMiller · Accepted solution]

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.

[robertrao]

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;