topic Re: PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel in SAS Procedures

PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel

jplarios — Tue, 21 Feb 2017 15:16:31 GMT

Hello,

We have a STP program that uses the following belowfor the STP to output in Excel

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=filename.xls');

/* OR */

/* Open results directly to Excel (browser-dependent) *

rc = stpsrv_header('Content-disposition',"inline"); */

run;

WHen using Proc Print it outputs to Excel ; but not if using PROC REPORT.

Any ideas?

Re: PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel

RW9 — Tue, 21 Feb 2017 15:22:30 GMT

What is the proc print / proc report doing? The reason being there are many ways to create Excel files - tagsets.excelxp, libname excel, etc. It could also be that the proc report is not working and creating an invalid Excel file. You haven't said what happens when the proc report is used, is there an error, does it open and there is no data, does nothing happen? What does the log of the proc report say - maybe there is an error? Maybe your missing a style, or you haven't specified columns in the proc report - I get this, when columnsis not given you wont get output.

Re: PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel

jplarios — Tue, 21 Feb 2017 16:12:45 GMT

When running with PROC PRINT; Excel is opened however with PROC REPORT it attempts to open an unknown file type:

we get a File Doanload Prompt with the Name result._WEBOUTUnknown Type:Unknown File Typpe From: the location of the file.

Re: PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel

RW9 — Wed, 22 Feb 2017 09:18:49 GMT

You will need to show how you are doing it. If you proc report to ods tagsets.execelxp and call it xlsx then that is a mismatch as tagsets creates XML output.

Re: PROC REPORT(no excel output ) vs PROC PRINT in a stored process when output is excel

jplarios — Wed, 22 Feb 2017 13:47:41 GMT

thank you; your answer helps me clarify our issue.