topic Re: Using numerous variables in STD function in SAS Programming

Using numerous variables in STD function

skjhzzang — Sun, 24 Nov 2019 11:18:37 GMT

Basically, to use Standard deviation function (STD), I know that I can use it as STD = STD(Var1, Var2, Var3);

but how about if I have 100 numerical variables?

In input statement, I know that it is possible to use like this, input Var1 - Var100;

Then, for STD function, do I have to write all 100 variables into parenthesis?

Re: Using numerous variables in STD function

ed_sas_member — Sun, 24 Nov 2019 11:36:19 GMT

Hi @skjhzzang

You can use an array to do that. You can then refer to the array name e.g. myarray(*) in a function like below:

data STD std2;
	input Name : $5. Var1 Var2 Var3;
	array myarray (*) Var1 - Var3; /* Reference you variables once */

	do i=1 to dim(myarray);
		Mean=Mean(of myarray(*));
		std=round(std(of myarray(*)), 0.01);
	end;
	drop i;
	
	output std;

	if std<=150 then
		output std2;
	datalines;
MATT 145 349 48
Susan 194 578 300
Tom 394 84 291
Jayce 394 58 279
;
run;

Re: Using numerous variables in STD function

PaigeMiller — Sun, 24 Nov 2019 12:17:55 GMT

stdev=std(of var1-var100);

Re: Using numerous variables in STD function

Kurt_Bremser — Sun, 24 Nov 2019 12:24:20 GMT

If they all have the same prefix, you do not even need the array:

result = std(of var:);