ODS Open destination file

[ender111]

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.

[SASKiwi]

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? 

[ender111]

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.

[SASKiwi · Accepted solution]

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.