Export Excel file from SAS Server to local PC

[dbdinc]

I currently have SAS running on three servers.... I can create and run a stored process that exports an Excel file. However, the Excel file is saved to my server. What I want to do is instead have my process export that file to a local computer.

My reason for wanting this is I don't think users should have to get to the server and then copy the file to their local machines.

If anyone has a suggestion, would you please share it with me? Thanks so much!!!

 

[dje]

What code are you using to save the output to excel? Is there a different location that the output can be saved. The server would need access to that location. If that can be done, then modify to code to save the excel file to the more appropriate location.

SAS could email the file if that would be more useful.

 

[dbdinc]

I'm using the proc export function to try exporting.

"The server would need access to that location. If that can be done, then modify to code to save the excel file to the more appropriate location." .... that's the probelm.... I don't know how to code my job tin order to point it to my local machine.

Can you explain in more detail how SAS can e-mail the file? Could someone e-mail the file to themselves?