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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.