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

ertr — Tue, 28 Jun 2016 14:43:30 GMT

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

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

Reeza — Tue, 28 Jun 2016 14:55:27 GMT

Take a substring and compare that.

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

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

Astounding — Tue, 28 Jun 2016 14:55:31 GMT

A small change is all that is required:

if variable in : (&macro.);

topic Re: How to - Get Specified Values By Taking Specified Digits From Variables Values - For Macro Varia in SAS Programming

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

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

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