The SAS Output Delivery System and reporting techniques

help please, DDE problem

Reply
N/A
Posts: 0

help please, DDE problem

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 !
N/A
Posts: 0

Re: help please, DDE problem

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
N/A
Posts: 0

Re: help please, DDE problem

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
N/A
Posts: 0

Re: help please, DDE problem

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
Ask a Question
Discussion stats
  • 3 replies
  • 148 views
  • 0 likes
  • 1 in conversation