Traditional web-based reporting with SAS BI tools

create Excel report using ODS and have a link to the excel in Web

Reply
Occasional Contributor
Posts: 14

create Excel report using ODS and have a link to the excel in Web

Hi

I would like to create an excel report using ODS and then have a intranet link through SASWeb to the Excel file which is stored in Unix (not the intranet share) ? How can I achieve this ?

Thanks
SAS Super FREQ
Posts: 8,820

Re: create Excel report using ODS and have a link to the excel in Web

Hi:
This question has already been answered about using ODS and Base SAS in the other posting.

If you want to use Web Report Studio, then you have to use WRS menu buttons to export your WRS report to Excel. In this instance, you are NOT using ODS -- you are using internal WRS methods that are controlled within the WRS interface.

If, on the other hand, you want to use the SAS Information Delivery Portal or the SAS Stored Process Web Application to run a Stored Process that will return ODS CSV or ODS TAGSETS.EXCELXP results to a browser, then you will need to use the STPSRV_HEADER function to tell the browser what application to launch when the result file is received.

There are some examples of using STPSRV_HEADER in the Stored Process documentation.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 173 views
  • 0 likes
  • 2 in conversation