topic Re: Like function in SAS Programming

Like function

SASdevAnneMarie — Wed, 01 Jul 2020 08:34:00 GMT

Hello,

I have a question please. Is it right to write the code:

where cd_produit like '%PE%GB%';

if I want to find the products like PE01GB, PE33GB, PE67GB

Thank you very much!

Re: Like function

gamotte — Wed, 01 Jul 2020 09:07:00 GMT

Hello,

Why don't you test it and check if it suits your needs ?

data have;
input cd_produit $20.;
cards;
PE01GB
PE67GB
PA45GB
PE35GC
AAPE75GBCC
PEZZGB
;
run;

data want;
set have;
where cd_produit like '%PE%GB%';
run;

Re: Like function

Kurt_Bremser — Wed, 01 Jul 2020 09:08:27 GMT

See Maxim 4.

Try It.

Create fake data:

data have;
input cd_produit $;
datalines;
PE01GB
PE33GB
PE67GB
XXXXXX
;

and run your SQL on it.

Re: Like function

SASdevAnneMarie — Wed, 01 Jul 2020 09:40:14 GMT

Thank you, it worked also for me.I thougth that maybe there was another option to do that )

Re: Like function

gamotte — Wed, 01 Jul 2020 10:31:59 GMT

Glad it helped.

There are always many options and you have to consider if the retained solution always

do what you expect. For instance, if your data contains products as "AAPEZZGBTT" they will match

the condition 'like "%PE%GB%". If you want to check precisely that the string is "PE" followed by

two digits followed by "GB", you can use a regexp as follows :

data want;
set have;
where prxmatch("/^PE\d{2}GB$/", trim(cd_produit));
run;