Desktop productivity for business analysts and programmers

( PC SAS )DDE alternatives in Enterprise Guide?

Reply
Contributor
Posts: 31

( PC SAS )DDE alternatives in Enterprise Guide?

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

Contributor
Posts: 73

( PC SAS )DDE alternatives in Enterprise Guide?

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

Contributor
Posts: 31

( PC SAS )DDE alternatives in Enterprise Guide?

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?

Grand Advisor
Posts: 17,462

( PC SAS )DDE alternatives in Enterprise Guide?

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

Community Manager
Posts: 2,707

( PC SAS )DDE alternatives in Enterprise Guide?

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

Contributor
Posts: 31

( PC SAS )DDE alternatives in Enterprise Guide?

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?

Super Contributor
Posts: 356

( PC SAS )DDE alternatives in Enterprise Guide?

Cherry

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

Barry

Valued Guide
Posts: 2,174

( PC SAS )DDE alternatives in Enterprise Guide?

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"

Ask a Question
Discussion stats
  • 7 replies
  • 2043 views
  • 0 likes
  • 6 in conversation