|Date: ||Fri, 1 Dec 2006 15:40:14 -0800|
|Reply-To: ||"Pardee, Roy" <pardee.r@GHC.ORG>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Pardee, Roy" <pardee.r@GHC.ORG>|
|Subject: ||Re: wildcard|
|Content-Type: ||text/plain; charset="US-ASCII"|
You can run that very code--certainly in proc sql as part of a select
statement, and even (I believe) in a datastep as part of a where clause.
Don't forget that sas text comparisons are case-sensitive tho--you may
want to lowcase() your field...
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, December 01, 2006 3:33 PM
sorry for the dumb question.....
i am trying to create a conditional statement where sas looks for the
word "absentee" anywhere in a column....
so essentially, i'm trying to mimic the following sql statement, only in
where name like '%absentee%'
can anyone help?