> 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