Date:         Fri, 26 Sep 2003 08:55:18 -0600
Reply-To:     "Barz, Ken" <BarzK@NJC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Barz, Ken" <BarzK@NJC.ORG>
Subject:      Re: Infile with DSD, DLM and Hex delimiter
Comments: To: "Groeneveld, Jim" <jim.groeneveld@vitatron.com>
Content-Type: text/plain; charset=iso-8859-1

Hi Jim,

Thanks for the code.  Looks like setting the delimiter how you have it below
doesn't quite work.  I played with it and used double quotes around the
colon.  That seems to get it to work.

  delimiter='0D'x||":";
  infile test dsd dlm=delimiter lrecl=1000;

The other infile works great as well.
Thanks,
Ken



-----Original Message-----
From: Groeneveld, Jim [mailto:jim.groeneveld@vitatron.com]
Sent: Friday, September 26, 2003 1:12 AM
To: Ken Barz; SAS-L@LISTSERV.UGA.EDU
Subject: RE: Infile with DSD, DLM and Hex delimiter


Hi Ken,

Try:
  Delimiter='0D'x||':';
  INFILE filename DSD DLM=Delimiter;
or:
  INFILE filename DSD DLM='0D3A'x;

Regards - Jim.

Y. (Jim) Groeneveld MSc
Biostatistician
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
The Netherlands
+31/0 26 376 7365; fax 7305
Jim.Groeneveld@Vitatron.com
www.vitatron.com


-----Original Message-----
From: Ken Barz [mailto:barzk@NJC.ORG]
Sent: Friday, September 26, 2003 00:40
To: SAS-L@LISTSERV.UGA.EDU
Subject: Infile with DSD, DLM and Hex delimiter


I am working on an import program for raw data out of a machine.  It comes
as colon delimited for the most part (it's possible to get two colons in a
row for missing, thus the dsd.)  But it also has carriage returns, '0D'x,
that function as delimiters.

When I try infile filename dsd dlm=": '0D'x";  SAS says dsd won't work with
the quotes in the dlm for the hex character.

Is there any other way to specify this delimiter to dlm, or any way to
mimic dsd so that this infile will work?

Thanks,
Ken



CONFIDENTIALITY NOTICE: The information contained in this message is legally
privileged and confidential information intended for the use of the individual
or entity named above. If the reader of this message is not the intended
recipient, or the employee or agent responsible to deliver it to the intended
recipient, you are hereby notified that any release, dissemination,
distribution, or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify the author
immediately by replying to this message and delete the original message. Thank
you.