topic Re: Prxmatch didn't recognize the macro list? in SAS Programming

Prxmatch didn't recognize the macro list?

ybz12003 — Wed, 11 Mar 2020 17:23:34 GMT

Hello,

I created a macro list below.

proc sql noprint;
	select trim(State_Abbr) into : Jurisdiction_list separated by '|'  from States;
quit;

%put &Jurisdiction_list;

and the result is shown below.

AL|AK|AZ|AR|CA|CO|CT|DE|FL|GA

Then I run a data step in PRXMATCH, I found the &Jurisdiction_list. was NOT able to recognize. Any idea why?

data want;
	SET test;
       
       if prxmatch ('/&Jurisdiction_list./i',ID) then TempID=ID;

run;

Re: Prxmatch didn't recognize the macro list?

ybz12003 — Wed, 11 Mar 2020 17:26:57 GMT

But when I hardcode for that list, it worked. I can't figure out where went wrong from the above codes.

data want;
	SET test;
       if prxmatch ('/AL|AK|AZ|AR|CA/i',id) then TempID=id;
run;

Re: Prxmatch didn't recognize the macro list?

novinosrin — Wed, 11 Mar 2020 17:34:39 GMT

Did you miss to enclose the string literal in double quotes " "

prxmatch ("/&Jurisdiction_list./i",ID)

Re: Prxmatch didn't recognize the macro list?

r_behata — Wed, 11 Mar 2020 17:31:23 GMT

use double quotes to enclose your macro variable.

24         
25         GOPTIONS ACCESSIBLE;
26         %Let Jurisdiction_list=%str(AL|AK|AZ|AR|CA|CO|CT|DE|FL|GA);
27         
28         data _null_;
29         /*	SET test;*/
30                ID='AK';
31         
32                if prxmatch ("/&Jurisdiction_list./i",ID) then TempID=ID;
33         
34         	   put TempID=;
35         run;

TempID=AK

Re: Prxmatch didn't recognize the macro list?

ybz12003 — Wed, 11 Mar 2020 17:48:38 GMT

Thank you so much. I didn't know it need to use double quote for the macro list.

Re: Prxmatch didn't recognize the macro list?

ed_sas_member — Wed, 11 Mar 2020 17:48:44 GMT

Hi @ybz12003 ,

The use of single quotes prevents the resolution of the macrovariable, so you need to use double quotes to avoid this.

if prxmatch ("/AL|AK|AZ|AR|CA/I",id) then TempID=id;

All the best,