Date: Thu, 25 Apr 1996 08:23:29 -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 -- ANSWERED!!
Thank you all for speedy assistance. In particular thanks to
Tom Abernathy
Tim Berryhill
Harry Cheng
Melvin Klassen
John Whittington
Ian Whitlock
There are two convenient approaches to this problem both of
which require the specification of the tab character as a
delimiter.
1. Use the DSD option on the infile statement.
infile rawdata dlm='09'x DSD;
This approach will also intrepet adjacent delimiters as a missing
value variable between the two adjcent delimiters.
2. Use two delimiter characters.
infile rawdata dlm='0922'x ;
Some, including our expert programmers, suggested reading in the
double quote characters and then striping them out. As a non
expert programmer who foolishly thinks my time is valuable I
always prefer to let the SAS system do something for me if it
will.
Thanks again.
Rodney
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