DATA Step, Macro, Functions and more

SET statement in DO loop

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

SET statement in DO loop

I recently came across some SAS code that contained a SET statement inside a DO loop.  Can someone explain to me exactly how SAS is processing the data or any papers that might help.  I understand arrays and loops, i just have never seen the set statement inside a loop before.

Thanks in Advance.

 

DATA NEW (KEEP=NAME DATE1-DATE20);

ARRAY DATES {20} DATE1-DATE20;

OBSNO + 1;

DO I=1 TO 20 UNTIL (LAST.NAME);

SET OLD;

BY NAME;

IF FIRST.NAME THEN OBSNO=1;

DATES{I} = DATE;

END;


Accepted Solutions
Solution
‎01-04-2013 01:59 PM
Super User
Super User
Posts: 7,076

Re: SET statement in DO loop

SET is an executable statement. So if you code it in a loop then it just reads one observation for each time it is called.

You have what has been termed a DOW loop.  See this earlier posting that has a link to an article on DOW loops.

https://communities.sas.com/message/140387#140387

View solution in original post


All Replies
Solution
‎01-04-2013 01:59 PM
Super User
Super User
Posts: 7,076

Re: SET statement in DO loop

SET is an executable statement. So if you code it in a loop then it just reads one observation for each time it is called.

You have what has been termed a DOW loop.  See this earlier posting that has a link to an article on DOW loops.

https://communities.sas.com/message/140387#140387

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 212 views
  • 0 likes
  • 2 in conversation