Architecting, installing and maintaining your SAS environment

Running DDE on SAS Grid?

Reply
Occasional Contributor
Posts: 6

Running DDE on SAS Grid?

Dear SAS community,

We are migrating from SAS on the MS Windows NET_ASRV platform to SAS Grid.

One of the issues we are facing is running DDE on SAS Grid.

We are using SAS/Excel DDE to convert formatted with custom templates multi-sheet SAS ODS tagsets.ExcelXP XML files into native Excel.

Is it possible to run DDE on SAS Grid?

What are other alternatives to create native Excel files with options available in tagsets.ExcelXP that can be used on SAS Grid?

Thank you,

new4new

Super User
Posts: 5,437

Re: Running DDE on SAS Grid?

First, what platform will you use for the grid. If non-windows, I hardly think this will work at all.

Secondly, using DDE doesn't sound like a typically grid application, so either, you might want to find a path in you solution to execute jobs "on the side" of the grid, in a more traditional manner.

I'm no expert in Excel tagsets, but is it critical for you ta have native Excel files?

There are, as might know, alternatives that could be considered, such as loading via Libname Excel engine, or accessing reports via Add-in for MS Office which let's you do some extensive formatting of your Excel report.

Data never sleeps
Occasional Contributor
Posts: 6

Re: Running DDE on SAS Grid?

Hi Linus, thank you for your prompt response!

Our SAS grid will be on Windows.

I am using DDE in our current Windows Server environment and it works seamlessly.

DDE might be an ‘exotic' solution, however, executing system commands (.cmd, .bat. vbs) from SAS is very common technique. 

There is a VBScript alternative: http://support.sas.com/kb/43/496.html and I have successfully 'implemented' it in our current environment. It still needs some tuning ( i.e.,  wait/sleep time calculated based on file sizes) but it works.

Is it possible to call a separate VBScript file from SAS on the SAS grid?

Thanks!

Super User
Posts: 5,437

Re: Running DDE on SAS Grid?

I don't know if there any limitations/restrictions for executing VBscript when on the grid, you might just have to test it to know.

Still, can't see this as a grid type of execution. You should be able to launch a "classic" SAS session to run this macro, if it shoulldn't work with your grid configuration.

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 565 views
  • 3 likes
  • 2 in conversation