DATA Step, Macro, Functions and more

loop issue

Reply
SAS Employee
Posts: 105

loop issue

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?
Super User
Posts: 5,260

Re: loop issue

Try this:

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


/Linus
Data never sleeps
SAS Employee
Posts: 105

Re: loop issue

Thanks alot linus!!!!
I appreciate it very much,
Ask a Question
Discussion stats
  • 2 replies
  • 98 views
  • 0 likes
  • 2 in conversation