Date: Thu, 23 Aug 2007 09:08:27 -0400
Reply-To: Nathaniel.Wooding@DOM.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject: Re: multiple dlm
In-Reply-To: <0yfzi.60$gv2.153750@news.sisna.com>
Content-Type: text/plain; charset="US-ASCII"
Richard
I was playing with this a few minutes ago and discovered that you cannot
say
dlm= ' ," '
when you specify DSD. The message is
ERROR: Quotes (' or ") have been detected in the delimiter (DLM=) string.
Quotes may not be used as delimiter characters when the DSD option is also
specified.
NOTE: The SAS System stopped processing this step because of errors.
Nat
Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
"Richard A.
DeVenezia"
<rdevenezia@WILDB To
LUE.NET> SAS-L@LISTSERV.UGA.EDU
Sent by: "SAS(r) cc
Discussion"
<SAS-L@LISTSERV.U Subject
GA.EDU> Re: multiple dlm
08/23/2007 08:53
AM
Please respond to
"Richard A.
DeVenezia"
<rdevenezia@WILDB
LUE.NET>
Captain wrote:
> Hi I have a txt file which has a dlm of "," for most of the
> variables. I then have 3 date variables on the same file that use
> just a , as the dlm. After these 3 date variables I have 3 payment
> variables that also use the , dlm and have a $ to begin the variable.
> The file is reading in everything except the 3 date variables
> (including the payment variables).
>
> I need to know a way to read in the file using multiple dlms, I can
> not use line input since it is a dlm file.
I don't know if your "," is literal or not.
Try using these infile options
DLM=',' DSD
DSD allows you to easily read in quoted values.
Infile does not support a multi-character delimitation. When the DLM option
has more than one character, each character is utilized as a delimiter.
Thus, if you have
DLM='","'
it would be the same as
DLM='",'
--
Richard A. DeVenezia
http://www.devenezia.com/
-----------------------------------------
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.
