topic Re: Problem with a macro Array subscript out of range. in SAS Programming

Problem with a macro Array subscript out of range.

kodmfl — Tue, 01 Jul 2014 17:02:58 GMT

Anyone have any idea why I'm having an issue (Array subscript out of range error) with the following code? All the required variables are there. The syntax looks right. Any clues?

%MACRO GENFLOWVAR;

DATA TMP_FA2; SET TMP_FA2;

ARRAY FLOWS FLOW0-FLOW33;

ARRAY FS F0-F33;

%DO I= 3 %TO 30;

FLOWS[&I]=MEAN(FS[%EVAL(&I-3)],FS[%EVAL(&I-2)],FS[&I],FS[%EVAL(&I+1)],FS[%EVAL(&I+2)],FS[%EVAL(&I+3)]);

%END;

%MEND;%GENFLOWVAR;

Re: Problem with a macro Array subscript out of range.

ballardw — Tue, 01 Jul 2014 17:23:58 GMT

why are you using a macro do loop???? There is no need;

do i = 3 to 30;

FLOWS=MEAN(FS[i-3],FS[I-2],FS,FS[I+1],FS[I+2],FS[i+3];

end;

should work just fine.

add options mprint; before your macro call %genflowvar and examine the resulting generated code.

Re: Problem with a macro Array subscript out of range.

JasonAllen — Tue, 01 Jul 2014 17:33:39 GMT

Without your source data it's difficult to say, but note:

This code will not generate FLOWS[0], FLOWS[1], or FLOWS[2].
Your data step is not terminated by a run statement.

Re: Problem with a macro Array subscript out of range.

Astounding — Tue, 01 Jul 2014 17:39:13 GMT

The array elements are named F0-F33, but the array subscript still has to range from 1 to 34, not from 0 to 33. It is illegal (array subscript out of range) to ask for FS[0] in your program. If you would like the array subscript to range from 0 to 33, you have to define the array slightly differently:

array FS {0:33} FS0-FS33;

Re: Problem with a macro Array subscript out of range.

kodmfl — Tue, 01 Jul 2014 18:20:03 GMT

Thanks for the help

Re: Problem with a macro Array subscript out of range.

kodmfl — Tue, 01 Jul 2014 18:20:45 GMT

Thanks for the help

Re: Problem with a macro Array subscript out of range.

kodmfl — Tue, 01 Jul 2014 18:21:46 GMT

Thanks for the help.