topic Re: perl expression - match string ignore if it contains "1" or "01" in SAS Programming

perl expression - match string ignore if it contains "1" or "01"

Suzy_Cat — Mon, 24 Aug 2020 00:33:30 GMT

Hi there,

Hope to receive some help with perl expression, where there are two columns to compare with, the match column should be flagging should obs where it matches. example as below:

ColumnA Column B Mached

ABC01 ABC1 Y

PAB1 PAB01 Y

Cob1 COB1 Y

BDD01 BDC01 N

Thanks for helping.

Cheers

Re: perl expression - match string ignore if it contains "1" or "01"

ChrisNZ — Mon, 24 Aug 2020 01:57:53 GMT

You have two almost identical questions in two threads. Are both actual questions?

Re: perl expression - match string ignore if it contains "1" or "01"

Suzy_Cat — Mon, 24 Aug 2020 02:26:14 GMT

Hi Chris, Thank you for pointing out the duplicates - have deleted now. It was due to system issue and I did not know the 1st attempte was successful.

Re: perl expression - match string ignore if it contains "1" or "01"

PGStats — Mon, 24 Aug 2020 02:32:26 GMT

Build on this:

data want;
set have;
s1 = prxchange("s/01/1/", -1, string1);
s2 = prxchange("s/01/1/", -1, string2);
match = upcase(s1) = upcase(s2);
run;

Re: perl expression - match string ignore if it contains "1" or "01"

Suzy_Cat — Mon, 24 Aug 2020 02:54:27 GMT

That is super. Solves my problem perfactlyt. Thank you PG!