topic Re: How to mask the % in a prxmatch statement in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965866#M375982 <P>my fault. typo with the table name.</P> Tue, 06 May 2025 08:04:04 GMT acordes 2025-05-06T08:04:04Z How to mask the % in a prxmatch statement https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965865#M375981 <P>I want to match '%macro'.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; select * from results where prxmatch("m/%nrstr(%macro)/oi",code_line); quit;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic1.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/106759i6A3DE37D4E8D83A3/image-size/large?v=v2&amp;px=999" role="button" title="pic1.png" alt="pic1.png" /></span></P> Tue, 06 May 2025 07:58:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965865#M375981 acordes 2025-05-06T07:58:17Z Re: How to mask the % in a prxmatch statement https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965866#M375982 <P>my fault. typo with the table name.</P> Tue, 06 May 2025 08:04:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965866#M375982 acordes 2025-05-06T08:04:04Z Re: How to mask the % in a prxmatch statement https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965867#M375983 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/127222">@acordes</a>,</P> <P>&nbsp;</P> <P>Use single quotes to avoid triggering the macro processor:</P> <PRE><FONT size="4">prxmatch(<STRONG><FONT color="#3366FF">'</FONT></STRONG>m/%macro/i<STRONG><FONT color="#3366FF">'</FONT></STRONG>,code_line);</FONT></PRE> <P>(The "<FONT face="courier new,courier">/o</FONT>" option is <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n0bj9p4401w3n9n1gmv6tf**bleep**9m.htm#n0jba0adj9x3nyn1v61mcuuhk0xc" target="_blank" rel="noopener">redundant</A> because this regular expression is a constant.)</P> Tue, 06 May 2025 08:27:59 GMT https://communities.sas.com/t5/SAS-Programming/How-to-mask-the-in-a-prxmatch-statement/m-p/965867#M375983 FreelanceReinh 2025-05-06T08:27:59Z