https://communities.sas.com/t5/Developers/Problem-while-exporting-the-output-to-excel/m-p/31374#M2600 Hi:<BR /> The APPSRV_HEADER function was designed for use with SAS/IntrNet. The STPSRV_HEADER function is the one to use for stored processes. I have never used a %LET statement and %SYSFUNC to change the value of the the content-type header, so I can't comment on whether that is appropriate or not.<BR /> <BR /> The only thing I can tell you is that if you use the tagsets.ExcelXP destination, you are creating a stored process that can only be executed in/from a limited number of client applications. You can execute this SP from the Portal, from the Stored Process Web Application (via URL). You could execute this from a custom front end -- JSP or whatever. <BR /> <BR /> You MAY be able to execute this SP from within EG; however you will NOT be able to execute this SP from within the SAS/Addin for Microsoft Office. Word only "accepts" HTML, RTF or SASReport XML results from a SP; Excel only "accepts" HTML, CSV or SASReport XML results from an SP; and PPT only "accepts" SASReport XML from an SP.<BR /> <BR /> There have been several examples of using STPSRV_HEADER with stored processes that have already been posted to this forum. You should be able to find them with a search on STPSRV_HEADER in the forum search box.<BR /> <BR /> cynthia Wed, 16 Jul 2008 16:33:48 GMT Cynthia_sas 2008-07-16T16:33:48Z https://communities.sas.com/t5/Developers/Problem-while-exporting-the-output-to-excel/m-p/31373#M2599 Hi <BR /> I have requirement to export report output to excel using the below piece of code as a Stored Process at runtime<BR /> I have Microsoft office 2007.<BR /> /**************************************/<BR /> %global _odsdest _odsoptions ;<BR /> %let _odsdest = tagsets.excelXP;<BR /> %let _odsoptions =;<BR /> %let rv = %sysfunc(appsrv_header(Content-type,application/vnd.ms-excel));<BR /> %stpbegin;<BR /> proc print data=sashelp.class;<BR /> run;<BR /> %stpend;<BR /> /**************************************/<BR /> So Kindly let me know whether it is supported or not or there is any other alternative Wed, 16 Jul 2008 04:44:44 GMT https://communities.sas.com/t5/Developers/Problem-while-exporting-the-output-to-excel/m-p/31373#M2599 deleted_user 2008-07-16T04:44:44Z https://communities.sas.com/t5/Developers/Problem-while-exporting-the-output-to-excel/m-p/31374#M2600 Hi:<BR /> The APPSRV_HEADER function was designed for use with SAS/IntrNet. The STPSRV_HEADER function is the one to use for stored processes. I have never used a %LET statement and %SYSFUNC to change the value of the the content-type header, so I can't comment on whether that is appropriate or not.<BR /> <BR /> The only thing I can tell you is that if you use the tagsets.ExcelXP destination, you are creating a stored process that can only be executed in/from a limited number of client applications. You can execute this SP from the Portal, from the Stored Process Web Application (via URL). You could execute this from a custom front end -- JSP or whatever. <BR /> <BR /> You MAY be able to execute this SP from within EG; however you will NOT be able to execute this SP from within the SAS/Addin for Microsoft Office. Word only "accepts" HTML, RTF or SASReport XML results from a SP; Excel only "accepts" HTML, CSV or SASReport XML results from an SP; and PPT only "accepts" SASReport XML from an SP.<BR /> <BR /> There have been several examples of using STPSRV_HEADER with stored processes that have already been posted to this forum. You should be able to find them with a search on STPSRV_HEADER in the forum search box.<BR /> <BR /> cynthia Wed, 16 Jul 2008 16:33:48 GMT https://communities.sas.com/t5/Developers/Problem-while-exporting-the-output-to-excel/m-p/31374#M2600 Cynthia_sas 2008-07-16T16:33:48Z