|Date: ||Wed, 24 Apr 1996 11:11:39 -0700|
|Reply-To: ||Rodney Presley <rpresley@CCLINK.FHCRC.ORG>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Rodney Presley <rpresley@CCLINK.FHCRC.ORG>|
|Subject: ||two delimiters on infile statement|
SAS 6.08 running under Windows NT.
I am reading in a tab delimited file produced by an Excel
spreadsheet. Excel got the file from another format and in the
process of turning the file into a spreadsheet Excel placed
quotation (") marks around text fields. Therefor, I need an
infile statement with two delimiters TFM manual gives an example
infile filename dlm='AB';
I can read tab delimited fields with this statement:
infile filename dlm='09'x ;
This of course does not recognize the quotation marks as
Various attempts to specify both delimiters have failed Help
will be appreciated.
Rodney J. Presley, Ph.D.
Fred Hutchinson Cancer Research Center 1124 Columbia Street
Seattle, WA 98104