Date:         Mon, 8 Mar 1999 13:22:35 -0800
Reply-To:     Bill Dvorak <bdvorak@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Bill Dvorak <bdvorak@YAHOO.COM>
Subject:      Re: xxx.xxxx.spflog.xxx
Comments: To: bill_droogendyk@DOFASCO.CA
Content-Type: text/plain; charset=us-ascii

If this is a SAS dataset, you can use the CONTAINS operator in the
WHERE clause:
 
DATA TEMP;
   SET TEMP1;
   WHERE VAR1 CONTAINS "SPFLOG" or
         VAR1 CONTAINS "spflog";
RUN;
 
 
 
 
 
---"W. Droogendyk" <bill_droogendyk@DOFASCO.CA> wrote:
>
> Gary:
>
> statement below is one choice
>
> if index(upcase(varname),'SPFLOG') > 0;
>
> W. (Bill) Droogendyk
> Voice:  905 548 7200 x3359
> Fax:    905 548 4007
> email:  bill_droogendyk@dofasco.ca <mailto:bill_droogendyk@dofasco.ca>
> Hamilton, Ontario, Canada
>
>         -----Original Message-----
>         From:   Gary Tiedens [SMTP:gtiedens@NJCMAIL.UPS.COM]
>         Sent:   Monday, March 08, 1999 15:41
>         To:     SAS-L@UGA.CC.UGA.EDU
>         Subject:
>
>         Hello all,
>
>            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.....
>
>
>         xxx.xxxx.spflog.xxx
>         xxx.spflog.xxx.xxxx
>
>
>
>                                               Gary E Tiedens
>                                          United Parcel Service
>
 
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com