topic Re: help please, DDE problem in ODS and Base Reporting

help please, DDE problem

deleted_user — Fri, 21 Dec 2007 13:12:29 GMT

when i import data from excel using DDE, if there is a 'Alt Enter' key in the cells to set the value to two rows, SAS will not reading data correctly, is there any option to salve this problem?

Thank you !

Re: help please, DDE problem

deleted_user — Fri, 21 Dec 2007 14:04:01 GMT

replace that with plain text
As SAS infile processing separates lines before columns, the 'alt-enter' creates a real problem. It is easy enough in a one-off case to fix. Don't accept "data" delivered in this way with this "quality".

Good Luck
Peterc sorry about the premature submit, PeterC

Message was edited by: Peter_c

Re: help please, DDE problem

deleted_user — Fri, 21 Dec 2007 15:06:52 GMT

Thank you PeterC !
PROC IMPORT ignore 'Alt-enter', so I thought DDE could get over the problem, but it seems i was wrong .

thank you all the same

Re: help please, DDE problem

deleted_user — Sun, 23 Dec 2007 09:27:16 GMT

I can't find the Tech Support note now, but about two years ago SAS reported that importing Excel data that included cells with multiple lines of data could result in truncation of the cell data.

So I suggest you carefully check any data from cells of this type.

It's a reminder that Excel is a data presentation tool, and SAS is a data management and manipulation tool, and there are often disparities when you try to the two together.

I'm surprised that DDE has a problem. If I have the time I'll look at reading the Excel data through DDE in bytes. If that's possible then that should distinguish the internal carriage returns from the cell boundaries.

Kind regards

David