Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

A common request is to produce output with a SAS^® Stored Process that can be opened in Microsoft Excel. This sample illustrates a common approach that can be used from a Web based client application to either prompt the end user to OPEN or SAVE the .xls file or open the file in Excel with no prompt.

*ProcessBody;

data _null_;

 /* Set HTTP headers */
  rc = stpsrv_header('Content-type','application/vnd.ms-excel');
  
 /* Prompt to SAVE or OPEN the attachment file named test.xls using Excel */
 /* rc = stpsrv_header('Content-disposition','attachment; filename=test.xls');*/

 /* OR */  
 /* Open results directly to Excel (browser-dependent) */
  rc = stpsrv_header('Content-disposition',"inline"); 
  
run;


/* Use TAGSETS.EXCELXP if you want multiple worksheets in one file */
/* %let _ODSDEST=TAGSETS.EXCELXP; */ 

/* OR */
/* Use TAGSETS.MSOFFICE2K if you want to include graphics output */

%let _ODSDEST=TAGSETS.MSOFFICE2K;    

/* Set ODS STYLE */
%let _ODSSTYLE=seaside;

/* Create output */
%stpbegin;

  proc print data=sashelp.class;
  run;

%stpend;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information