topic Re: If then-else with prxmatch in SAS Programming

If then-else with prxmatch

bits — Thu, 02 Feb 2017 09:30:22 GMT

data work.systems;                                                                                                                      
set work.carsales;                                                                                                                      
if prxmatch('m/Acura|Dodge|Ford/oi',Manufacturer) > 0  then found=1;                                                                    
else found=0;                                                                                                                           
run;

I've tried to run above code and in result I got a new dataset with found=0 only... as I want to do pattern matching so prxmatch should be there..

thanks:)

Re: If then-else with prxmatch

RW9 — Thu, 02 Feb 2017 09:45:36 GMT

Post test data in the form of a datastep, we can't see your data!

Re: If then-else with prxmatch

LaurieF — Thu, 02 Feb 2017 09:50:02 GMT

I don't have access to your source data, but when I run

data work.systems;
set sashelp.cars;
if prxmatch('m/Acura|Quattro|Ford/oi',model) > 0
   then found=1;
   else found=0;
run;

it works fine.

If you want to get fast accurrate solutions, posting the data you're using is recommended. It's fortunate there's a similar dataset in sashelp.

Re: If then-else with prxmatch

bits — Thu, 02 Feb 2017 10:07:36 GMT

hey thanks for reply...actually im using bit old sas version i.e SAS 9.0... so does this makes any impact while running the code? @LaurieF

Re: If then-else with prxmatch

LaurieF — Thu, 02 Feb 2017 10:09:59 GMT

I can't tell. It should work. But as I said, let's see your data and we'll find out.

Re: If then-else with prxmatch

RW9 — Thu, 02 Feb 2017 10:13:02 GMT

These are the modifier which work in 9.1,

https://support.sas.com/rnd/base/datastep/perl_regexp/regexp-tip-sheet.pdf

Sorry, 9.0 is so antiquated they had to have documentatioon on stone tablets. Seriously, upgrade there is no benefit to staying on an old version.

Re: If then-else with prxmatch

bits — Thu, 02 Feb 2017 10:17:52 GMT

here is the dataset which im using for this code @LaurieF

Re: If then-else with prxmatch

LaurieF — Thu, 02 Feb 2017 18:54:57 GMT

I'm with @RW9 - upgrade, if you're in the position to do it. If you can't, stick with multiple index or indexw calls, which will work fine.