Hello,
As we have moved away from using DDE to export to Excel - I'm working with a user to convert a process from using DDE to instead using the SAS Add-in for Office.
The challenges we have faced is that the user's spreadsheet has a large number of tabs, the source data is dynamic in length and we want the output excel spreadsheet to adjust according the size of the source dataset and also the variable format. Other issues we have experienced when just mapping through using the SAS Add-in has been that the format is incorrect so the user's inbuilt Excel functions and calculations don't work.
To me, If we could copy the way DDE functions but by creating a SAS dataset instead of an Excel spreadsheet - we could then create the connection using SAS Add-In.
So i'm just wondering does anybody have any knowledge of mirroring what is done with DDE but instead producing a pre formatted SAS data set??....as an example the DDE code that was previously used is :
%macro DDEtable(variable_name, SASdataset, sheetname); filename exceltab dde "excel|[&reportname..xlsm]&sheetname.!r2c1:r999c9"; data _null_; set local.&SASdataset; file exceltab lrecl=300 notab dlm='09'x; put &variable_name volume &ACT_variable &EXP_variable misalignment IV efficiency delta totalvol; run; %mend;
%DDEtable(A_Test,out_A_Test,Another_Test);
... View more
![SASGF 2020 [Virtual] Attendee](/html/@4229D83652827A3CCCDB8CAD5D23E8D2/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
