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 (September 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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. > >


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