ARRAYS

[robertrao]

Hi,

I have variables DX1 thru DX30.

ALSO I have DXPOA1-DXPOA30;

I want to check from DX2 to DX9 and see if they have non missing values. if non missing and corresponding DXPOA value is missing then I want to delete that record!!!

Could someone help me with the code????

Thanks

[ballardw · Accepted solution]

data want;

     set have;

     array dx dx2-dx9;

     array dxp dxpoa2-dxpoa9;

     do _i_ = 1 to dim (dx);

          if not missing(dx[_i_]) and missing(dxp[_i_]) then delete;

     end;

run;