|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:
There are othes for page break, etc.