Date:         Wed, 4 Sep 1996 13:42:30 +0100
Reply-To:     John Whittington <johnw@MAG-NET.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         John Whittington <johnw@MAG-NET.CO.UK>
Subject:      Re: Tab delimited files in SAS
Comments: To: Harry Sharp <sharp@SNUFF.CSD.SC.EDU>

On Tue, 3 Sep 1996, Harry Sharp <sharp@SNUFF.CSD.SC.EDU> wrote:
 
>Can you specify a nonprintable character as a delimiter using
>the DELIMITER keyword on the INFILE statement?  If you change
>the delimiter, are other keywords required, such as DSD?
>
>The platform is Windows, the version of SAS is 6.10.
 
Harry, all you probably need is DLM = '09'x  (or DELIMITER = '09'x) in your
INFILE statement.  '09'x is the hexadecimal representation of the ASCII tab
character.
 
If you add DSD, then multiple adjacent delimiters will be treated as
indicating missing values between them (without DSD, multiple consecutive
delimiters are treated as a single delimiter), quote marks are stripped from
any quoted strings and any delimiter characters occuring within quoted
strings are NOT treated as delimiters.
 
John
 
-----------------------------------------------------------
Dr John Whittington,        Voice:      +44 1296 730225
Mediscience Services        Fax:        +44 1296 738893
Twyford Manor, Twyford,     E-mail:     johnw@mag-net.co.uk
Buckingham  MK18 4EL, UK    CompuServe: 100517,3677
-----------------------------------------------------------