BookmarkSubscribeRSS Feed
Oleg_L
Obsidian | Level 7

Hello EG-users.

Is it possible to make a DDE connection in EG with Excel started and running at the SAS-server (not the client machine)? I know that it's not possible to use DDE with SAS-server and Excel running at client machine.

Thanks in advance.

Oleg.

3 REPLIES 3
SASKiwi
PROC Star

Most EG / SAS Server installations block the ability to execute an operating system command from SAS. This is the way you usually start your Excel session from SAS on your server to use DDE.

Run PROC OPTIONS and check the setting of the XCMD option. If it is set off you could try setting it on but you will probably find that you can't do it.

Oleg_L
Obsidian | Level 7

Thanks for your reply.

I have read somewhere that it is not possible to use DDE while code is submitted by the SAS Server. SAS Server always submit EG-client program code.

Does the -ALLOWXCMD option let us to use DDE in EG?

Oleg.

SASKiwi
PROC Star

Thinking about this more clearly, even if ALLOWXCMD is enabled this is not going to work. Excel must be open for DDE to work. Excel is a desktop application that requires a display to function. If you try to start it on a server where is the display going to go? There is no connection to a physical display for Excel to use so it would most likely fail with an error.

If you have SAS installed on your desktop as well as EG that would be an alternative. If you had a remote login to the SAS server and bypassed EG that would work also. If not, then I think you will have to explore other techniques like PROC EXPORT, the EXCEL LIBNAME option, ODS and the EXCELXP tagset and so on.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1564 views
  • 0 likes
  • 2 in conversation