topic Re: How to shorten the calculation of similar varname? in SAS Programming

How to shorten the calculation of similar varname?

ResoluteCarbon — Wed, 31 Mar 2021 08:19:09 GMT

Hi all,

Today I need to calculate the average of 4 variables: wind1,wind2,wind3,wind4.

The answer is

data storm_wingavg;
	set pg1.storm_range;
	*Add assignment statements;
	windavg=mean(wind1,wind2, wind3,wind4);
run;

But I remember there is one way using "of" or else when dealing with variables having the same prefix like this case, but I do not know the keyword to search for documents about that. Can you please hint me out?

Thanks in advance.

Re: How to shorten the calculation of similar varname?

Kurt_Bremser — Wed, 31 Mar 2021 08:21:45 GMT

Try

windavg = mean(of wind1-wind4);

Re: How to shorten the calculation of similar varname?

ResoluteCarbon — Fri, 02 Apr 2021 21:38:34 GMT

Hi @Kurt_Bremser

After learning for a while, I come back with another solution to add on in case anyone coming and search this discussion

windavg = mean(of wind1-wind4);
/*or*/
windavg=mean(of w:);
/*or*/
windavg=mean(of wind:);

Cheers,