Date: Fri, 10 Sep 2004 12:45:54 -0400
Reply-To: "L. Bertolini" <bertolini.1@OSU.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "L. Bertolini" <bertolini.1@OSU.EDU>
Organization: Ohio State University
Subject: Re: Need help with delimited data
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Assuming you're using the "DLM=" option on the INFILE statement,
add the "DSD" option, as well.
Wainwright, Andrea wrote:
>I have data that is delimited with a Ç character. I have lots of missing
>data, so there are many occasions where those symbols are right next to each
>other.
>
>I thought SAS would treat that as missing, but it seems to think any number
>of those chars is the delimiter and it just grabs the next available field,
>and nothing is missing.
>
>Any advice on how to deal with this?
>
>I am still working with the data creator because there is way more missing
>data than there should be, but even once we get that figured out, there
>still may be missing data.
>
>TIA
>Andrea Wainwright
>Capital One
>
>**************************************************************************
>The information transmitted herewith is sensitive information intended only
>for use by the individual or entity to which it is addressed. If the reader
>of this message is not the intended recipient, you are hereby notified that
>any review, retransmission, dissemination, distribution, copying or other
>use of, or taking of any action in reliance upon this information is
>strictly prohibited. If you have received this communication in error,
>please contact the sender and delete the material from your computer.
>
>
|