BookmarkSubscribeRSS Feed
Cherry
Obsidian | Level 7

Can some one refer me ( PC SAS )DDE alternatives in Enterprise Guide?

7 REPLIES 7
Stephane
Quartz | Level 8

You need to go through custom task but IMHO you need to create a new design of your job. Especially if you need to insert data in Excel, you must continue with a proc EXPORT and use this worksheet as a source of a another worksheet that contains graphs for example.

http://support.sas.com/kb/20/767.html

http://support.sas.com/resources/papers/sgf2008/eguide.pdf

Cherry
Obsidian | Level 7

My concerns are:

we have a distributed environment where SAS is running on a remote server, and the remote session is running on Unix.The microsoft excel on my local PC has to be accessible. Any advise on this?

Reeza
Super User

Depends on what you're trying to do.

You can consider ExcelXP Tagset as an alternative.

http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

ChrisHemedinger
Community Manager

And here is another approach, using the EXCEL LIBNAME engine if you can:

http://blogs.sas.com/content/sasdummy/2009/08/04/accessing-excel-from-sas-without-dde/

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
Cherry
Obsidian | Level 7

My Concerns are :

we have a distributed environment where SAS is running on a remote server, and the remote session is running on Unix.The microsoft excel on my local PC has to be accessible. Any advise on this?

twocanbazza
Quartz | Level 8

Cherry

Reeza's response would suit your needs given your concerns...  Look into the ExcelXP Tagsets

Barry

Peter_C
Rhodochrosite | Level 12

in your overall SAS environment do you have SAS/AMO?

That provides SAS menus inside Excel - so providing an alternative to "EG for extract to excel"

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
  • 7 replies
  • 3410 views
  • 0 likes
  • 6 in conversation