SAS Studio - DDE and System Commands

Accepted Solution Solved
Reply
Grand Advisor
Posts: 17,308
Accepted Solution

SAS Studio - DDE and System Commands

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 Smiley Very Happy


Accepted Solutions
Solution
‎01-27-2016 10:32 AM
Esteemed Advisor
Posts: 5,194

Re: SAS Studio - DDE and System Commands

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?

Data never sleeps

View solution in original post


All Replies
Solution
‎01-27-2016 10:32 AM
Esteemed Advisor
Posts: 5,194

Re: SAS Studio - DDE and System Commands

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?

Data never sleeps
Grand Advisor
Posts: 17,308

Re: SAS Studio - DDE and System Commands

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. 

Esteemed Advisor
Posts: 5,194

Re: SAS Studio - DDE and System Commands

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 Smiley Wink).

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.

Data never sleeps
Esteemed Advisor
Esteemed Advisor
Posts: 7,190

Re: SAS Studio - DDE and System Commands

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. 

Grand Advisor
Posts: 17,308

Re: SAS Studio - DDE and System Commands


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. 

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 480 views
  • 0 likes
  • 3 in conversation