topic Re: SAS Studio - DDE and System Commands in SAS Programming

SAS Studio - DDE and System Commands

Reeza — Tue, 26 Jan 2016 20:22:17 GMT

If you have an enterprise installation of SAS, and are use SAS Studio as your interface will you lose access to system commands with the local machine?

I'm assuming DDE wouldn't work as well, but if someone could confirm that would be appreciated.

Thanks.

PS. Yes I know DDE is old technology

Re: SAS Studio - DDE and System Commands

LinusH — Tue, 26 Jan 2016 20:26:38 GMT

Since SAS Studio (to my knowledge) is 100% web based, I can't see how interaction with local programs can possibly work.

What do you want to achieve?

Re: SAS Studio - DDE and System Commands

Reeza — Tue, 26 Jan 2016 20:34:08 GMT

We have a bunch of reports that rely on exporting analyzed data to Excel and then executing a bunch of excel macros and vbs.

Excel Macros - used to export Excel report to PDF

VBS used to combine PDF's from various processes.

We can probably script it all in another language, but it was nice being able to control the full analysis from SAS.

Re: SAS Studio - DDE and System Commands

LinusH — Tue, 26 Jan 2016 21:27:54 GMT

Only you know what your XL macro/vbs stuff does. My personal opinion is that reporting/analyze logic is better maintained in a centralized BI infrastructure (like SAS ).

As you there are many options to create/modfy Excel spreadsheets, and produce pdf files. Whether it's possible/worth the effort to convert the existing logic, I have no idea.

Re: SAS Studio - DDE and System Commands

RW9 — Wed, 27 Jan 2016 10:01:43 GMT

I would agree with @LinusH.

There is however another way of doing it. Currently your pushing data from SAS, and then pushing commands out from SAS. You could reverse the second half of this. Push the data out from SAS as plain CSV. Then in your Office documents, pull that data in. Should be a pretty straight forward, OnOpen() macro function to pull in CSV data to a spreadsheet, or you could have it as a macro on a separate Excel file.

I would question why you are going from SAS to Excel to VBA to PDF? Sounds a bit "around the houses" type approach. A quick analysis of the complete process should yield a far better more robust system.

Re: SAS Studio - DDE and System Commands

Reeza — Wed, 27 Jan 2016 15:30:49 GMT

@RW9 wrote:

A quick analysis of the complete process should yield a far better more robust system.

It wouldn't be quick, but thanks for the suggestion.