topic ODS Open destination file in ODS and Base Reporting

ODS Open destination file

ender111 — Thu, 19 Jan 2023 16:32:51 GMT

I have a job running in Job Execution that produces a formatted excel file. To avoid the user needing to open file explorer, how do I open or activate that newly produced file? X command won't work because the SAS job runs off the server. I read that there is a way in ODS, but can't find the proper command or line. Any help would be appreciated.

Re: ODS Open destination file

SASKiwi — Thu, 19 Jan 2023 23:56:07 GMT

AFAIK, Job Execution simply kicks off a SAS batch job on your SAS App server. There is no way that job can open an Excel spreadsheet on your PC. What about getting your SAS job to email the user, the spreadsheet as an attachment, or a hyperlink to open it?

Re: ODS Open destination file

ender111 — Thu, 19 Jan 2023 23:59:21 GMT

Unfortunately, no. It has to open it right there while the user is logged in. If ODS can't do it, any idea what can? Thanks.

Re: ODS Open destination file

SASKiwi — Fri, 20 Jan 2023 00:26:40 GMT

You could run the SAS job as a stored process from a web page, then redirect the output back to the user's web browser. It's not something I've done personally but I'm sure there are posts on the Community about it. What version of SAS are you using? In SAS 9.4 there is this:

BTW, It's not ODS that is the problem, it is your use of Job Execution.