BookmarkSubscribeRSS Feed
bharatgosu
Calcite | Level 5

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.

 

2 REPLIES 2
Kurt_Bremser
Super User

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.

Reeza
Super User
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 854 views
  • 3 likes
  • 3 in conversation