Desktop productivity for business analysts and programmers

How do I replace DDE?

Reply
Occasional Contributor
Posts: 11

How do I replace DDE?

I hope someone can help. I have a number of regulatory reports that are Excel templates that require completing each day/month. At present I use BaseSAS and DDE the output to the relevant cells that need populating.

We are migrating onto EG and I need to find a workaround from DDE, as I cannot change the Report style or type. What options are open to me?

Our new Tools that are being deployed are EG4.1, Web Report Studio, OLAP Cube Studio and Information Map Studio.

I have not yet got MS Add-in but that is a possibility if required.

Thanks....
Super User
Posts: 3,240

Re: How do I replace DDE?

Do you have SAS/ACCESS to PC File Formats licensed on your EG Server? Without that your options would be probably limited to MS Excel Add-in.

ODS can export to Excel but it builds XML spreadsheets for scratch each time, so unless you are prepared to change your layout to suit ODS this is probably not an option.
Occasional Contributor
Posts: 11

Re: How do I replace DDE?

Thanks for the response. Unfortunately, we don't have the PC File formats licensed.

Are you able to point me in any direction for training material etc. The Excel format cannot change at all, due to it's external regulatory audience, so does that mean that MS Excel add-in is my only option?

Will that mean I still need to use VBA to populate the exact cells with the correct data?
Super User
Posts: 3,240

Re: How do I replace DDE?

Apart from the SAS Add-in the only other option I can think of is to get SAS to export the data out as a CSV (comma-delimited) file and then use Excel's data import functionality to read the data into a blank worksheet. From this worksheet you can use VLOOKUP Excel formulas to pick up the correct data and put it in the correct cell in your existing reports.

If you want to explore the SAS Add-in option, suggest you search SAS support for relevant user papers.

Either way this is probably going to be a fairly manual solution....good luck!
Occasional Contributor
Posts: 11

Re: How do I replace DDE?

Thanks for the 'good' news. I'll investigate more on the MS Add-in.
Ask a Question
Discussion stats
  • 4 replies
  • 466 views
  • 0 likes
  • 2 in conversation