topic Re: Creating excel files using DDE through SAS in SAS Programming

Creating excel files using DDE through SAS

bharatgosu — Tue, 07 Jul 2020 08:49:39 GMT

Hi Peeps,

We are using a SAS code to create RM Scorecards by using DDEs and VBA code inbuilt.

By using this SAS programme/ by the end of process, it will generate RM level scorecards.
It will create a excel file, insert multiple sheets, Rename them.
Removes unwanted rows in between and does grouping.

To fulfil this process, SAS system will open each RM Scorecard multiple times.

Each time it asks for permission to access the Excel file and while saving the file it will show the warning message how actually an excel file show while replacing the file with the same name.

the possess use to run with out any manual inversion in windows 7. But after getting upgraded for Win10 we are forcing to click on Ok(while opening the file) and Yes (while saving the file).

Please drop me a note if you have any solution.

Re: Creating excel files using DDE through SAS

Kurt_Bremser — Tue, 07 Jul 2020 08:55:49 GMT

There are numerous ways in SAS to create Excel workbook files and sheets within those that do not involve the deprecated DDE technology. Please show us the current code, the SAS dataset(s) you want to use as source, and an example for the intended layout of the Excel file.

Use data steps with datalines to post example datasets, and use the "little running man" to post code.

Re: Creating excel files using DDE through SAS

Reeza — Tue, 07 Jul 2020 16:14:39 GMT

I'm surprised your IT team let you re-activate DDE.
Or maybe they haven't and that's why you get pop up messages?

Either way, Microsoft found some security flaws with DDE so started locking it down massively starting December 2018 I believe.

For certain DDE commands there is an option to suppress warnings so you'll need to check if your calls to see if they support that to suppress warnings. Another is to make sure it's in a trusted location and trusted files which reduces the error.