| Date: | Thu, 16 Dec 1999 18:36:21 -0500 |
|---|
| Reply-To: | HERMANS1 <HERMANS1@WESTAT.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | HERMANS1 <HERMANS1@WESTAT.COM> |
|---|
| Subject: | Re: MVS v6.09 SQL "CONTAINS" Problem |
|---|
|
| Content-Type: | text/plain; charset=US-ASCII |
|---|
What an absurd suggestion! One should obviously use UPCASE() as I suggested!
(I see no reason to remain civil on SAS-L when issues of this magnitude are at
stake.)
Sig
____________________Reply Separator____________________
.....
I would code the test you mention as
where lowcase(desc) contains 'dsm';
--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> Nelson Harrison <nelson@MNSI.NET> 12/16/1999 1:45 pm >>>
I'm trying to rewrite some code from another programmer who used DATA
step and the LIKE function. I'm using PROC SQL and the CONTAINS
function to look for "DSM" or "dsm" in a description field. The
problem is my way misses 8 records where "DSM1","DSM-1","DSM1." are at
the end of the description field. Is there a problem with the
CONTAINS function??? Am I doing something wrong???
Thanks
Nelson
| 
