ARRAYS

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

ARRAYS

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


Accepted Solutions
Solution
‎10-24-2014 10:54 AM
Grand Advisor
Posts: 10,241

Re: ARRAYS

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;

View solution in original post


All Replies
Solution
‎10-24-2014 10:54 AM
Grand Advisor
Posts: 10,241

Re: ARRAYS

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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 150 views
  • 0 likes
  • 2 in conversation