looping through 0 to 11 using intnx

[alexandralorenzo]

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

[Astounding · Accepted solution]

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.

[alexandralorenzo]

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

[Ron_MacroMaven]

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