topic Re: Receiving error: Array subscript out of range in SAS Data Management

Receiving error: Array subscript out of range

Vivv — Thu, 11 Apr 2019 17:58:00 GMT

Trying to create dummy variables using arrays and I keep getting an 'array subscript out of range' error message. Can anyone help with what i'm doing wrong?

DATA WR16; SET final16;

Array race {10} R1_1-R1_10; Do i=1-10;

If race {i} = 'R1' then AIAN =1;

If race {i} = 'R2' then Asian =1;

If race {i} = 'R3' then Black =1;

If race {i} = 'R4' then NHPI =1;

If race {i} = 'R5' then White =1;

If race {i} = 'R9' then Other =1;

end;

run;

Re: Receiving error: Array subscript out of range

novinosrin — Thu, 11 Apr 2019 17:59:06 GMT

Correction: Do i=1 to 10;

DATA WR16; SET final16;

Array race {10} R1_1-R1_10;

Do i=1 to 10;

If race {i} = 'R1' then AIAN =1;

If race {i} = 'R2' then Asian =1;

If race {i} = 'R3' then Black =1;

If race {i} = 'R4' then NHPI =1;

If race {i} = 'R5' then White =1;

If race {i} = 'R9' then Other =1;

end;

run;

Re: Receiving error: Array subscript out of range

Vivv — Thu, 11 Apr 2019 18:05:00 GMT

Thank you @novinosrin ,its amazing how such a tiny mistake in coding could matter a lot.

Re: Receiving error: Array subscript out of range

ballardw — Thu, 11 Apr 2019 23:47:28 GMT

You might consider instead of

If race {i} = 'R1' then AIAN =1;

using

AIAN = (race [I] = 'R1');

which will have 0 values when not true.

Then MEAN of AIAN will be the decimal percentage of AIAN in the data set and you may find other uses as well.