Hello friends,
I am using the following code to find values that contain _
------------------------------------------------------------
proc sql;
/* Ausgabe der KontoIDs, in denen noch Suffices vorhanden sind*/
create table lls_dat.p_Ktomitsuff&stichtag
as select KontoID, KontOhneSuffix
from lls_wrk.P_kos&stichtag
where kontohneSuffix like "^_" escape "^";
quit;
------------------------------------------------------------
I am getting the following warning. How can I make it work?
Thx, Stefan
------------------------------------------------------------
WARNING: Server is unable to execute the WHERE clause.
If you are looking strings which contain a '_' at anywhere. using contains operation.
proc sql;
create table x as
select a
from a
where a contains "_" ;
quit;
Ksharp
Hi. Stefan
Are you finding a string which ends with underline '_' ?
It seems that you need another wildcard % to match any characters before '_' .
data a; a='sdsad_';output; a='sdsdfs';output; run; proc sql; create table x as select a from a where a like "%^_" escape "^"; quit;
Ksharp
If you are looking strings which contain a '_' at anywhere. using contains operation.
proc sql;
create table x as
select a
from a
where a contains "_" ;
quit;
Ksharp
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.