topic ( PC SAS )DDE alternatives in Enterprise Guide? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9432#M2541 <HTML><HEAD></HEAD><BODY><P>Can some one refer me ( PC SAS )DDE alternatives in Enterprise Guide?</P></BODY></HTML> Tue, 06 Dec 2011 09:00:00 GMT Cherry 2011-12-06T09:00:00Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9432#M2541 <HTML><HEAD></HEAD><BODY><P>Can some one refer me ( PC SAS )DDE alternatives in Enterprise Guide?</P></BODY></HTML> Tue, 06 Dec 2011 09:00:00 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9432#M2541 Cherry 2011-12-06T09:00:00Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9433#M2542 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><A class="jive-link-external-small" href="http://support.sas.com/kb/20/767.html">http://support.sas.com/kb/20/767.html</A></P><P><A class="jive-link-external-small" href="http://support.sas.com/resources/papers/sgf2008/eguide.pdf">http://support.sas.com/resources/papers/sgf2008/eguide.pdf</A></P></BODY></HTML> Tue, 06 Dec 2011 15:32:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9433#M2542 Stephane 2011-12-06T15:32:31Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9434#M2543 <HTML><HEAD></HEAD><BODY><P>Depends on what you're trying to do. </P><P></P><P>You can consider ExcelXP Tagset as an alternative. </P><P></P><P><A class="jive-link-external-small" href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html</A></P></BODY></HTML> Tue, 06 Dec 2011 17:32:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9434#M2543 Reeza 2011-12-06T17:32:55Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9435#M2544 <HTML><HEAD></HEAD><BODY><P>And here is another approach, using the EXCEL LIBNAME engine if you can:</P><P></P><P><A href="http://blogs.sas.com/content/sasdummy/2009/08/04/accessing-excel-from-sas-without-dde/">http://blogs.sas.com/content/sasdummy/2009/08/04/accessing-excel-from-sas-without-dde/</A></P><P></P><P>Chris</P></BODY></HTML> Tue, 06 Dec 2011 20:08:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9435#M2544 ChrisHemedinger 2011-12-06T20:08:32Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9436#M2545 <HTML><HEAD></HEAD><BODY><P> <STRONG>My concerns are:</STRONG></P><P></P><P><SPAN style="font-size: 10pt; font-family: Arial;"></SPAN></P><P>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?</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Wed, 07 Dec 2011 13:33:24 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9436#M2545 Cherry 2011-12-07T13:33:24Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9437#M2546 <HTML><HEAD></HEAD><BODY><P><STRONG> My Concerns are :</STRONG></P><P><STRONG> </STRONG></P><P>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?</P></BODY></HTML> Wed, 07 Dec 2011 13:34:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9437#M2546 Cherry 2011-12-07T13:34:46Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9438#M2547 <HTML><HEAD></HEAD><BODY><P> Cherry</P><P></P><P>Reeza's response would suit your needs given your concerns...&nbsp; Look into the ExcelXP Tagsets</P><P></P><P>Barry</P></BODY></HTML> Wed, 07 Dec 2011 19:27:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9438#M2547 twocanbazza 2011-12-07T19:27:57Z ( PC SAS )DDE alternatives in Enterprise Guide? https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9439#M2548 <HTML><HEAD></HEAD><BODY><P> in your overall SAS environment do you have SAS/AMO?</P><P>That provides SAS menus inside Excel - so providing an alternative to "EG for extract to excel"</P></BODY></HTML> Wed, 07 Dec 2011 23:31:02 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/PC-SAS-DDE-alternatives-in-Enterprise-Guide/m-p/9439#M2548 Peter_C 2011-12-07T23:31:02Z