topic SAS Stored Process Report in SAS Programming

SAS Stored Process Report

manishiiita — Tue, 02 Feb 2021 06:52:26 GMT

We have created a report on SAS Stored Process. We are able to view it. We can also enable to export report data into Excel / CSV file. But, we are not able to do both at the same time.

Is there any way to enable user to Export data to Excel/CSV in a SAS Stored Process Report along with viewing the report? Can create an icon/button on Stored Process Report page, by clicking on this button data will be exported.

Thank you for your help.

Re: SAS Stored Process Report

andreas_lds — Tue, 02 Feb 2021 07:38:13 GMT

You could display the table and write it to a file automatically. The user, of course, has to navigate to the directory in which the file has been saved.

Much more complicated: When the table is displayed add a button (or link) re-calling the stored process. The parameter can be part of the url, so that it maybe looks as if the download starts directly, while the data is processed again in the background.