How to mask the % in a prxmatch statement

[acordes]

I want to match '%macro'.

proc sql;
select * from
results where 
prxmatch("m/%nrstr(%macro)/oi",code_line);
quit;

[acordes · Accepted solution]

my fault. typo with the table name.

[FreelanceReinh]

Hello @acordes,

Use single quotes to avoid triggering the macro processor:

prxmatch('m/%macro/i',code_line);

(The "/o" option is redundant because this regular expression is a constant.)