BookmarkSubscribeRSS Feed
new4new
Calcite | Level 5

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

3 REPLIES 3
LinusH
Tourmaline | Level 20

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
new4new
Calcite | Level 5

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!

LinusH
Tourmaline | Level 20

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1550 views
  • 3 likes
  • 2 in conversation