Array subscript out of range

[jcis7]

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]

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]

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]

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