BookmarkSubscribeRSS Feed
Lokraj
Calcite | Level 5

Hi,

I am writing a stored process which runs on Report Delivery Portal.

After user hit the run button, I do ods output to excel. Well, it does creates the excel file, but how do I prompt user to save the excel file which the ods has just created? I appreciate any help. Thanks.

Lokraj

3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  When you run stored processes in the Information Delivery Portal (which is how I interpreted the "Report Delivery Portal" that you mentioned), if you use the correct STPSRV_HEADER function in your code to set the result type, you should get prompted to save the file when the stored process results come back to the browser.

  

  There have been many posts in the Stored Process Forum about using STPSRV_HEADER, as well as examples of stored processes that return either ODS HTML, ODS CSV or ODS TAGSETS.EXCELXP output as stored process results. I'm not exactly sure what you mean when you say you "do ods output to excel" since ODS destinations are merely ASCII text files (either HTML, or CSV or XML) that Excel knows how to open and render. Only certain client applications on the BI Platform know how to receive stored process results that are "non standard" -- for example, the SAS Add-in for Microsoft Office can receive HTML or CSV results from a stored process without using an STPSRV_HEADER call in your code; but the SAS Add-in for Microsoft Office cannot receive TAGSETS.EXCELXP output -- which is where the Portal comes into play. You can create stored process results with TAGSETS.EXCELXP using the Information Deliver Portal, but generally, you need an STPSRV_HEADER function to change the default HTTP content-type header.

  I'd recommend that you look in the Stored Process Forum postings for more information and examples relevant to this question.

cynthia

Lokraj
Calcite | Level 5

Hi Cynthia,

Thank you for your input. As I am new to SAS programming, I do not know where to add STPSRV_HEADER in my stored process.I would apprecaite if you can write me back with a little more detail.

Thanks.

Lokraj

Cynthia_sas
SAS Super FREQ

Hi:

  When I go to the Stored Process forum

http://communities.sas.com/community/sas_stored_processes  and search on the string "STPSRV_HEADER", I come up with 2 pages of hits. The use of STPSRV_HEADER is off-topic in this forum (since this is the BASE SAS and Reporting Procedure forum -- which generally does not include much to do with the BI Platform). Since this question is related to stored processes and since I know that STPSRV_HEADER examples are posted in the Stored Process forum, I would recommend that you start there.

  If you find that the examples that are posted on the stored process forum are not adequate to your need, then I would suggest that you either search for Tech Support notes and documentation on the support web site (for more like this http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/viewer.htm#srvhead.htm ) and/or open a track with SAS Technical Support for help with your stored process.

  Without looking at ALL your code and understanding your environment, it is hard to provide general information, since the use of STPSRV_HEADER is only required in some, but not all, stored processes.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 824 views
  • 0 likes
  • 2 in conversation