| 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
such as:
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
delimiters.
Various attempts to specify both delimiters have failed Help
will be appreciated.
Rodney J. Presley, Ph.D.
Staff Scientist
Fred Hutchinson Cancer Research Center 1124 Columbia Street
MP-848
Seattle, WA 98104
206-667-6733
rpresley@fhcrc.org
| 
