topic Re: Effective way to check if a macro variable takes values among several values in SAS Procedures

Effective way to check if a macro variable takes values among several values

Sunny_Sun — Wed, 04 Mar 2015 18:52:26 GMT

Hi,

I am trying to create a macro variable M that takes 1 if macro variable X takes values among a set of values defined by another macro variable Y.

For example, %LET X=a; %LET Y=a b c d e f g;

Since a is one of values of Y, so macro variable M takes 1; otherwise, it takes 0.

Can you please show me some quick way to write it? In STATA, it is something like

Local M: list X in Y

Thanks in advance.

Sunny

Astounding — Wed, 04 Mar 2015 19:26:34 GMT

This should be easy enough:

%if %index(%str( &y ), %str( &x )) %then %let m=1;

%else %let m=0;

It's important to keep the blanks inside the parentheses, before and after &x and &y.

Good luck.

billfish — Wed, 04 Mar 2015 19:36:14 GMT

You give the following a try:

%LET X=d;

%LET Y=a b c d e f g;

%let M = %sysfunc(sign(%index(&y,&x)));

%put the value of M is >>> &M;

Sunny_Sun — Wed, 04 Mar 2015 19:51:37 GMT

many thanks it works.

Sunny_Sun — Wed, 04 Mar 2015 19:52:47 GMT

many thanks for your help