Tag: DDE

Why your DDE programs don’t work anymore

Hello, 1992 called. They want their DDE Excel automation back. Perhaps the title of this article is too pessimistic. Of course your SAS programs that use DDE (dynamic data exchange) can still work perfectly, as long as you situate your SAS software and its DDE “partner” (usually Microsoft Excel) to […]

The post Why your DDE programs don’t work anymore appeared first on The SAS Dummy.

SAS Macros to Read data from MS Excel using DDE

Here are a set of SAS Macros to read data from MS Excel using DDE…

Let me explain with some scenarios with the Excel data stored in “C:\Names.xlsx” in worksheet named “Sheet1″…

This excel file has in fact data that can be read into 2…