topic Re: How to reuse the calculated mean value of PROC for further calculation? in SAS Programming

How to reuse the calculated mean value of PROC for further calculation?

ervinodsingh — Wed, 19 Apr 2017 12:17:23 GMT

I have calculated the mean of a variable using MEAN proc, now I want to use mean value for further calculation. Please help me to reuse or save the calculated mean value for further use.

data test; 
input x ; 
cards; 
100 
200 
300 
; 
run; 

proc means data=test; 
var x; 

run;

Re: How to reuse the calculated mean value of PROC for further calculation?

RW9 — Wed, 19 Apr 2017 12:22:06 GMT

You can output to dataset from that in a variety of ways (the manual is your friend), you could do;

proc means data=test; 
  var x; 
  output out=want mean=mean;
run;

Re: How to reuse the calculated mean value of PROC for further calculation?

Reeza — Wed, 19 Apr 2017 13:33:18 GMT

Here's two ways of accomplishing this solution.

https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset

Re: How to reuse the calculated mean value of PROC for further calculation?

ervinodsingh — Wed, 19 Apr 2017 15:50:56 GMT

Thanks your solution also worked for me.