topic Re: How to use wildcards and like operators for multiple values? in SAS Programming

How to use wildcards and like operators for multiple values?

Babloo — Fri, 14 Nov 2014 10:21:34 GMT

I would like extract the data like below. But it is creating table with all rows from maps.uscity instead of required records.

It looks I need to tweak the code in like operator to get only the records that has city like below.

proc sql;

create table FI_Locations as select * from maps.uscity where city like '%Atlanta%' or '%Cary%' or '%Hartford%' ;

quit;

Babloo — Fri, 14 Nov 2014 11:36:30 GMT

any thoughts?

JuanS_OCS — Fri, 14 Nov 2014 12:37:42 GMT

Hi Babloo,

depending on your database, maybe you can use the "contains" comparator, instead of "like", then you won;t need the wildcards.

Ksharp — Fri, 14 Nov 2014 12:48:02 GMT

LIKE only can handle one expression one time.

proc sql;

create table FI_Locations as select * from maps.uscity where city like '%Atlanta%' or city like '%Cary%' or city like '%Hartford%' ;

quit;

Xia Keshan

Babloo — Fri, 14 Nov 2014 12:53:15 GMT

I would like to know if i can combine the below data step into one step.

proc sql;

create table FI_Locations_at as select * from maps.uscity where city contains 'Atlanta';

quit;

proc sql;

create table FI_Locations_ca as select * from maps.uscity where city contains 'Cary';

quit;

user24feb — Fri, 14 Nov 2014 12:57:24 GMT

.. if you need to combine your where-statement with and-statements you might prefer ..

proc sql;

create table FI_Locations as select * from maps.uscity where

(Case When city like '%Atlanta%' or

city like '%Cary%' or

city like '%Hartford%' Then 1

Else 0

End)=1;

quit;