Prxmatch didn't recognize the macro list?

[ybz12003]

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;

[ybz12003]

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; 

[r_behata]

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

[ed_sas_member]

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,

[novinosrin · Accepted solution]

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

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

[ybz12003]

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