How to - Get Specified Values By Taking Specified Digits From Variables Values - For Macro Variables

[ertr]

Hello,

I want to get following "Variable" column's first three digits.

I define the first three digits i.e:"WOE", "REP". If I use "=:" option then I write first three digits, it brings my desired values but what if I have more than one value. Sometimes, I need 5 or 6 values i.e:"WOE","REP","IMP","ITA","BEL" etc. so I want to put these values into macro variable then use into my code.

I hope I could make myself clear. Can you help me about to reach my aim, please?

Data Have;
Do i=1 to 5;
Variable="WOE_Hart";
Output;
End;
Do i=1 to 5;
Variable="REP_Buff";
Output;
End;
Do i=1 to 5;
Variable="IMP_Steph";
Output;
End;
Run;
 
Data Want2;
Set Have;
If Variable=:"REP" Or Variable =:"IMP" Or Variable=:"ASK ";
Run;

%Let Macro= "WOE" "REP"; 

Data Want3;
Set Have;
If Variable =:(&Macro.);
Run;

Thank you

[Reeza]

Take a substring and compare that. 

If substr(variable, 1,3) in ('REP', ...,'ASK') then ...

[Astounding · Accepted solution]

A small change is all that is required:

if variable in : (&macro.);