prxmatch issue?

ybz12003 — Wed, 28 Jun 2017 19:09:40 GMT

Hello:

I have the following prxmatch codes.

else if prxmatch("m/(?=.*?if_audiol)/i", &var) > 0 then found=18;

else if prxmatch("m/(?=.*?if_audiol_dt)/i", &var) > 0 then found=19;

else if prxmatch("m/(?=.*?if_audiol_res)/i", &var) > 0 then found=20;

else if prxmatch("m/(?=.*?if_audiol_res_sp)/i", &var) > 0 then found=21;

else if prxmatch("m/(?=.*?mhh_exp_ustrv)/i", &var) > 0 then found=223;

else if prxmatch("m/(?=.*?mhh_exp_ustrv_en)/i", &var) > 0 then found=224;

else if prxmatch("m/(?=.*?mhh_exp_ustrv_here)(?=.*?yes)/i", &var) > 0 then found=225;

else found=0;

run;

I found out all of the follow rows have been assigned to 18 and 223, how to differentiate the following conditions with the correct numbers:

if_audiol_1 18

if_audiol_2 18

if_audiol_dt_1 19

if_audiol_dt_2 19

if_audiol_dt_3 19

if_audiol_res_1 20

if_audiol_res_2 20

if_audiol_res_3 20

if_audiol_res_4 20

if_audiol_res_sp_1 21

if_audiol_res_sp_2 21

mhh_exp_ustrv 223

mhh_exp_ustrv_en1 224

mhh_exp_ustrv_here1_yes 225

Re: prxmatch issue?

Reeza — Wed, 28 Jun 2017 19:04:32 GMT

Change the order of your IF/ELSE IF to have the most detailed first down to the most generic. Your current system has it backwards.

Re: prxmatch issue?

Patrick — Wed, 28 Jun 2017 21:44:18 GMT

@ybz12003

Should your strings like if_audiol be "words" and not just sub-strings then you could also use the \b syntax to avoid matches with sub-strings and not whole words. -> \bif_audiol\b

Re: prxmatch issue?

ChrisNZ — Thu, 29 Jun 2017 04:06:14 GMT

I still think you do not need to read ahead. Your RegEx seems to be needlessly complex.

topic Re: prxmatch issue? in SAS Programming

prxmatch issue?

Re: prxmatch issue?

Re: prxmatch issue?

Re: prxmatch issue?