topic looping through 0 to 11 using intnx in SAS Programming

looping through 0 to 11 using intnx

alexandralorenzo — Thu, 21 Apr 2016 11:35:41 GMT

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

Re: looping through 0 to 11 using intnx

Astounding — Thu, 21 Apr 2016 11:44:15 GMT

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.

Re: looping through 0 to 11 using intnx

alexandralorenzo — Thu, 21 Apr 2016 12:52:40 GMT

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

Re: looping through 0 to 11 using intnx

Ron_MacroMaven — Thu, 21 Apr 2016 14:42:56 GMT

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