Date:         Mon, 8 Mar 1999 15:51:04 -0500
Reply-To:     S David Riba <dave@JADETEK.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         S David Riba <dave@JADETEK.COM>
Comments: To: gtiedens@njcmail.ups.com
Content-Type: text/plain; charset="iso-8859-1"

>   I have a dataset with over 600,000 observations in it. I am trying to
extract only those obs. that have the word spflog in it.
>I tried the scan function and the result that I received were not what I
wanted, I also tried substr. Any ideas.....
 
Try the WHERE statement with a CONTAINS clause:
 
WHERE word contains 'spflog'
 
or if case is an issue, try:
 
WHERE upcase(word) contains 'SPFLOG'
 
Hope this helps.
 
----------------------------------------------------------------------------
  S. David Riba                     INTERNET: dave@JADETEK.COM
  JADE Tech, Inc.                        http://www.jadetek.com
  P O Box 4517
  Clearwater, FL  33758
  VOICE: (727) 726-6099             A SAS Institute Quality Partner
 
                  SAS.  It's not just an attitude
 
 
-----Original Message-----
From: Gary Tiedens <gtiedens@njcmail.ups.com>
Newsgroups: bit.listserv.sas-l
To: SAS-L@UGA.CC.UGA.EDU <SAS-L@UGA.CC.UGA.EDU>
Date: Monday, March 08, 1999 3:42 PM
 
 
>Hello all,
>
>
>
>xxx.xxxx.spflog.xxx
>xxx.spflog.xxx.xxxx
>
>
>
>                                      Gary E Tiedens
>                                 United Parcel Service