https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952855#M372373 <P>Thanks!&nbsp;&nbsp;</P> Sat, 07 Dec 2024 17:28:06 GMT PamG 2024-12-07T17:28:06Z https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952844#M372367 <P>How do I go about using PRXMATCH to search for a string that contains ampersand ? SAS is assuming that it is a macro variable.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input varchar $; datalines; ABCDEF GHI KLM KLM&amp;F KLM&amp;FG ; run; data want;set have; if prxmatch("m/KLM&amp;F/i,varchar) &gt;0; *gives an error Macro variable F not resolved; run;</CODE></PRE> <P>&nbsp;</P> Sat, 07 Dec 2024 15:49:17 GMT https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952844#M372367 PamG 2024-12-07T15:49:17Z https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952845#M372368 <P>Correction: Please note that I missed putting the ending quotation marks after /i.&nbsp; I cannot edit my post to make the correction.</P> Sat, 07 Dec 2024 16:17:29 GMT https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952845#M372368 PamG 2024-12-07T16:17:29Z https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952853#M372372 <P>Use single quotes so the macro processor will ignore the string.</P> <PRE><CODE class=" language-sas">if prxmatch('m/KLM&amp;F/i',varchar) &gt;0;</CODE></PRE> <P>&nbsp;</P> Sat, 07 Dec 2024 17:10:12 GMT https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952853#M372372 Tom 2024-12-07T17:10:12Z https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952855#M372373 <P>Thanks!&nbsp;&nbsp;</P> Sat, 07 Dec 2024 17:28:06 GMT https://communities.sas.com/t5/SAS-Programming/PRXMATCH-with-string-containing-ampersand/m-p/952855#M372373 PamG 2024-12-07T17:28:06Z