topic Re: Array subscript out of range in SAS Programming

Array subscript out of range

jcis7 — Mon, 20 May 2013 22:59:27 GMT

I'm trying to fill fields per row as missing (currently some fields have zeros) for certain rows, where rep='N'.

All variables I'm replacing as missing either have a numerical value of zero or are missing.

But I'm getting an error: Array subscript out of range at line 409 column 28.

data new;

set old;

if tot ge 10;

array vars var1 var2 var3 var4 var5 var6 var7;

if rep = 'N' then vars=.;

run;

Tom — Mon, 20 May 2013 23:28:16 GMT

I am assuming that you want to assign missing to each of the variables when REP='N'.

if rep='N' then do over vars; vars=.; end;

or if you do not like the old style DO OVER then use an explicit index variable.

if rep='N' then do _n_=1 to dim(vars); vars(_n_)=. ; end;

ScottBass — Tue, 21 May 2013 07:53:42 GMT

Untested but should work:

data new;

set old;

if tot ge 10;

if rep = 'N' then call missing(of var:); /* or call missing(of var1-var7); read the doc on "of" keyword and variable lists */

run;

Sudhakar_A — Tue, 21 May 2013 08:10:03 GMT

if rep = 'N' then call missing(of var1-var7);