loop issue

[yonib]

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?

[LinusH]

Try this:

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


/Linus

[yonib]

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