topic do loops and name appending in SAS Programming

do loops and name appending

SachinRuk — Fri, 15 Oct 2010 02:46:51 GMT

hi all,

some help?

data newtable;
do i=1 to 5;
y_i.=i;
end;
run;

I want to keep the variables y_1, y_2 and so on (not i)

thanks in advance,
Sachin

Re: do loops and name appending

Rambo — Fri, 15 Oct 2010 04:57:10 GMT

You could initialize an array with the name of the variables that you want.

For example, you could have said array y_(5); Then you reference the array like so in the data step: y_(i) = value;. When the array is stored in the dataset, it will actually be stored as y_1, y_2, etc.

Note; In the array statement, the number in parentheses tells sas how many elements you need in your array; for you example, it should match the number of iterations in the do loop.

Re: do loops and name appending

Cynthia_sas — Fri, 15 Oct 2010 05:03:03 GMT

And, this is a very good introduction to ARRAY processing and ARRAY concepts in SAS:
http://support.sas.com/rnd/papers/sgf07/arrays1780.pdf

cynthia

Re: do loops and name appending

SASPhile — Mon, 18 Oct 2010 14:59:13 GMT

Try this:

%macro sachin;
data newtable;
%do i=1 %to 5;
%let j=&i.;
y_&j.=&j.;
%end;
run;
%mend sachin;
%sachin;

Re: do loops and name appending

SASPhile — Mon, 18 Oct 2010 15:12:48 GMT

Applying Rambo's suggestion:

data newtable1;
array y_(5);
do i= 1 to 5;
y_(i)=i;
end;
drop i;
run;