| 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...
HTH,
-Roy
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Ryan McNeill
Sent: Friday, December 01, 2006 3:33 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: wildcard
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
sas.
where name like '%absentee%'
can anyone help?
| 
