## looping through 0 to 11 using intnx

Solved
Occasional Contributor
Posts: 9

# 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: 6,761

## Re: looping through 0 to 11 using intnx

Posted in reply to alexandralorenzo

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.

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

## Re: looping through 0 to 11 using intnx

Posted in reply to alexandralorenzo

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

Posted in reply to Astounding
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.
Regular Contributor
Posts: 227

## Re: looping through 0 to 11 using intnx

Posted in reply to alexandralorenzo
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 and locked.

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

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