DATA Step, Macro, Functions and more

Flagging observations with specific values in an array of variables

Reply
Regular Contributor
Posts: 175

Flagging observations with specific values in an array of variables

As part of an if-then statement, I need to flag observations with certain codes in any of 25 variables dx1-dx25. What is the best way to do this?

 

y=0

if not missing(x) and...

 <something translating to 123 or 234 in any of dx1-dx25>

...then y=1

end;

run;

 

 

 

 

 

 

Super User
Posts: 24,010

Re: Flagging observations with specific values in an array of variables

Double arrays. One with the list of values you’re looking for and a second with the dx. 

 

Then loop through the smaller array and use WHICHC to search for the values. Use a LEAVE/BREAK to exit the loop once the flag is set. 

 

Another approach would be to make it a long data set than it’s a very easy WHERE filter on the query. 

Regular Contributor
Posts: 175

Re: Flagging observations with specific values in an array of variables

Can I use double arrays if this is one part of multiple ands in an if-then statement?

 

i.e.

 

y=0;

if not missing(x)

  and age>=18

  and died = 0

  and <array statement here??>

then do;

y=1;

end;

run;

 

 

Super User
Posts: 24,010

Re: Flagging observations with specific values in an array of variables

You can nest or add diff criteria just have to make sure the order is correct. 

Ask a Question
Discussion stats
  • 3 replies
  • 152 views
  • 0 likes
  • 2 in conversation