LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 1996, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page