( PC SAS )DDE alternatives in Enterprise Guide?

[Cherry]

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

[Stephane]

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]

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]

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]

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

[Cherry]

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]

Cherry

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

Barry

[Peter_C]

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"