topic loop issue in SAS Programming

loop issue

yonib — Mon, 26 Jan 2009 08:54:31 GMT

Hi,
for example l have the folowing data:

agent x y
A 3 5
B 2 4
C 7 3

I want my output be like this

agent x y
A 3 5
A 3 4
A 3 3
A 3 2
A 3 1
B 2 4
B 2 3
B 2 2
B 2 1
C 7 3
C 7 2
C 7 1

I try to do it without sucess ,can anybody help me?

Re: loop issue

LinusH — Mon, 26 Jan 2009 11:51:59 GMT

Try this:

data agent2(drop=y rename=(i=y));
set agent1;
do i = y to 1 by -1;
output;
end;
run;

/Linus

Re: loop issue

yonib — Mon, 26 Jan 2009 13:03:27 GMT

Thanks alot linus!!!!
I appreciate it very much,