DATA Step, Macro, Functions and more

Do-loop question

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

Do-loop question

The following SAS program is submitted:

 

Data WORK.SALES;

do Year=1 to 5;

do Month=1 to 12;

X+1;

end;

end;

run;

 

How many obersevations are written to the WORK.SALES data set?

 

Answer is 1. Is it because there is no 'output' stated in the code thats why it did not give individual value for each month, the 1 observation is the sum of individual months up to 5 years? Please help, thanks!


Accepted Solutions
Solution
‎09-27-2017 03:19 AM
Trusted Advisor
Posts: 1,822

Re: Do-loop question

Without OUTPUT staement it iterates to up the end and outputs one observation.

 

Adding OUTPUT staemant will result in 1 or 5 or 60 (=5*12) depending after which line it is entered.

View solution in original post


All Replies
Solution
‎09-27-2017 03:19 AM
Trusted Advisor
Posts: 1,822

Re: Do-loop question

Without OUTPUT staement it iterates to up the end and outputs one observation.

 

Adding OUTPUT staemant will result in 1 or 5 or 60 (=5*12) depending after which line it is entered.

Contributor
Posts: 31

Re: Do-loop question

understood, thanks!!!!
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 104 views
  • 1 like
  • 2 in conversation