LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 10 Feb 2009 12:10:16 -0500
Reply-To:   Paul St Louis <pstloui@DOT.STATE.TX.US>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Paul St Louis <pstloui@DOT.STATE.TX.US>
Subject:   Re: Problems with 9.2 - reading of data
Content-Type:   text/plain; charset=ISO-8859-1

Look for imbedded manual line-feeds in your Excel data. SAS can not interpret it. If you paste from Excel into Notepad, you will now see them.

For instance, in Word I entered 1, line feed, 2, line feed, 3. Then I pasted all of this info into one Excel cell. The data looks fine, but if I paste the contents of that cell into Notepad, I see:

"123"

There are othes for page break, etc.


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