Hi Peeps,
We are using a SAS code to create RM Scorecards by using DDEs and VBA code inbuilt.
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.