DATA Step, Macro, Functions and more

looping through 0 to 11 using intnx

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

looping through 0 to 11 using intnx

Hello,

 

I don't understand why my first program works and the second no (only changing the looping).

I need to add the currently month in the loop if anyone have ideas thanks a lot.

 

%let runasofdate= 20140101;
data creation;
rundate = input(put(&runasofdate,8.),yymmdd8.);
array psc0010_begin_date(*) psc0010_begin_date0-psc0010_begin_date11;
array psc0010_end_date(*) psc0010_end_date0-psc0010_end_date11;
do i =1 to 11  ;
psc0010_begin_date(i) = intnx('month',rundate,i,'begin');
psc0010_end_date(i)= intnx ('month', rundate, i , 'end');
 
end;
run;
 
And the second program doesn't working ..
 

 

%let runasofdate= 20140101;
data creation;
rundate = input(put(&runasofdate,8.),yymmdd8.);
array psc0010_begin_date(*) psc0010_begin_date0-psc0010_begin_date11;
array psc0010_end_date(*) psc0010_end_date0-psc0010_end_date11;
do i =0 to 11  ;
psc0010_begin_date(i) = intnx('month',rundate,i,'begin');
psc0010_end_date(i)= intnx ('month', rundate, i , 'end');
 
end;
run;
 
Thanks

Accepted Solutions
Solution
‎04-21-2016 08:52 AM
Super User
Posts: 5,083

Re: looping through 0 to 11 using intnx

When the ARRAY statement contains this:

 

(*)

 

SAS counts the first element of the array as the one with subscript=1.  I you want i=0 to refer to the first element of the array, you have to change to using:

 

(0:11)

 

Otherwise, there is no element that corresponds to i=0.

View solution in original post


All Replies
Solution
‎04-21-2016 08:52 AM
Super User
Posts: 5,083

Re: looping through 0 to 11 using intnx

When the ARRAY statement contains this:

 

(*)

 

SAS counts the first element of the array as the one with subscript=1.  I you want i=0 to refer to the first element of the array, you have to change to using:

 

(0:11)

 

Otherwise, there is no element that corresponds to i=0.

Occasional Contributor
Posts: 9

Re: looping through 0 to 11 using intnx

I found the solution an array cannot take a 0 value so I had to defined the array elements as you said.
But also change the loop.
Thanks for your answer
Regular Contributor
Posts: 198

Re: looping through 0 to 11 using intnx

for macro users who want to generate a series of date values, see my paper
Macro Loops with Dates

http://www.sascommunity.org/wiki/Macro_Loops_with_Dates
☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 255 views
  • 0 likes
  • 3 in conversation