Hi,
If I understand properly your question, you are willing to display a preview of the generated file and then allow the user to download what they see as an Excel file.
If this is the approach, I would suggest to create an HTML preview of the results using ods html with the webout destination. At the same time you create the HTML version, you can create an Excel file and store it in the SAS File Server. This file may then be downloaded using a button displayed on the HTML version of the results.
You can most probably use this article as a reference. Most part of the article covers the integration with SAS Visual Analytics, but the job itself is similar in the way it works. This article may also be interesting as it describes how to display the result on the same page.
Let me know if you have questions.
Regards,
Xavier
... View more