SAS Stored Process Report

[manishiiita]

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.

[andreas_lds · Accepted solution]

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.