Download Excel file from VIYA

[PaigeMiller]

Suppose I create an Excel file in SAS Studio running on SAS Viya.

ods excel file="/data/homes/pmiller1/class.xlsx";
proc print data=sashelp.class noobs style(header)=[color=orange];
run;
ods excel close;

Exciting, I know. Now, I want to download this Excel file to my Windows computer. I can do this via the SAS Studio GUI, point and click. How can I do this via a SAS program?

[gwootton]

You would need to replace "/data/homes/pmiller1/class.xlsx" with a path that is accessible to both the compute server where SAS is running and your windows host.

[PaigeMiller]

---

@gwootton wrote:
You would need to replace "/data/homes/pmiller1/class.xlsx" with a path that is accessible to both the compute server where SAS is running and your windows host.

---

And how would I know what that path is for SAS Viya?

[gwootton]

That is not something specific to Viya, you'd need to have something like that set up.

Studio is able to save things to your windows machine by using your browser since it is running on your local machine. Your code only has access to where it is running, which is on the compute server.