https://communities.sas.com/t5/SAS-Programming/find-a-pattern-is-string-with-wildcard/m-p/782202#M249363 <P>Hello</P> <P>&nbsp;</P> <P>I have a list of addresses and I need to find those records that contains R*S&nbsp; (* meaning any possible character).</P> <P>&nbsp;</P> <P>R*S could be anywhere in the string.</P> <P>&nbsp;</P> <P>I've tried combining different fucntions (SCAN, INDEX, CONTAINS, wildcard..) but I cannot get it to work.</P> <P>&nbsp;</P> <P>Any idea would be very much appreciated!</P> <P>thanks</P> Wed, 24 Nov 2021 12:22:47 GMT MART1 2021-11-24T12:22:47Z https://communities.sas.com/t5/SAS-Programming/find-a-pattern-is-string-with-wildcard/m-p/782202#M249363 <P>Hello</P> <P>&nbsp;</P> <P>I have a list of addresses and I need to find those records that contains R*S&nbsp; (* meaning any possible character).</P> <P>&nbsp;</P> <P>R*S could be anywhere in the string.</P> <P>&nbsp;</P> <P>I've tried combining different fucntions (SCAN, INDEX, CONTAINS, wildcard..) but I cannot get it to work.</P> <P>&nbsp;</P> <P>Any idea would be very much appreciated!</P> <P>thanks</P> Wed, 24 Nov 2021 12:22:47 GMT https://communities.sas.com/t5/SAS-Programming/find-a-pattern-is-string-with-wildcard/m-p/782202#M249363 MART1 2021-11-24T12:22:47Z https://communities.sas.com/t5/SAS-Programming/find-a-pattern-is-string-with-wildcard/m-p/782208#M249368 <P>Go look at&nbsp;<A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n13as9vjfj7aokn1syvfyrpaj7z5.htm" target="_self">Pattern Matching Using Perl Regular Expressions (PRX)</A>&nbsp;and examples in&nbsp;<A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p1vz3ljudbd756n19502acxazevk.htm" target="_self">Using Perl Regular Expressions in the DATA Step</A>&nbsp;</P> Wed, 24 Nov 2021 12:38:15 GMT https://communities.sas.com/t5/SAS-Programming/find-a-pattern-is-string-with-wildcard/m-p/782208#M249368 AMSAS 2021-11-24T12:38:15Z