topic Re: Storing a value in a variable ? in SAS Programming

Storing a value in a variable ?

deleted_user — Mon, 26 Oct 2009 17:41:30 GMT

Hi,
I would like to store the mean of a data set variable in a variable such that I could use the value without writing it myself each time I need it.
Is this possible ?
If yes, how can I proceed ?

Thank you in advance

Re: Storing a value in a variable ?

DanielSantos — Mon, 26 Oct 2009 17:54:44 GMT

Not sure of what you need, but maybe storing the desired value into a SAS macro variable may solve your problem.

proc sql noprint;
select mean(VALUE) into :MEAN_VALUE from DATA;
quit;

the into: statement will load a value into a SAS macro variable through SQL.

See the online doc here:
http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a000543554.htm

From there, you just need to reference the SAS macro variable in your program, then at runtime this will be substituted by the actual value loaded previously.

for example:
data _null_;
put "Mean value is: &MEAN_VALUE";

/* or */

MEAN=&MEAN_VALUE;
put MEAN=;
run;

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Storing a value in a variable ?

deleted_user — Mon, 26 Oct 2009 19:36:19 GMT

Yes it was what I wanted to do, your solution worked perfectly.
Many thanks from France !