topic Re: Can SAS viya create an excel with multiple tabs in SAS Programming

Can SAS viya create an excel with multiple tabs

jhusoc — Thu, 21 Jul 2022 21:42:21 GMT

Hello everyone,

I used to use SAS desktop to export the excel sheets. It is very straightforward. However, now we need to change the SAS desktop to SAS Viya. Is there any way SAS viya can create an excel with multiple tabs and save it to local? And how?

Thank you very much!

Re: Can SAS viya create an excel with multiple tabs

Sajid01 — Thu, 21 Jul 2022 23:30:10 GMT

Yes it can. make sure you have the SAS Access interface to PC files.

Re: Can SAS viya create an excel with multiple tabs

jhusoc — Fri, 22 Jul 2022 15:10:34 GMT

How to set the access? Is that doable if I want to use the SAS database saved in my share drive(do not upload to viya)? Thank you so much!

Re: Can SAS viya create an excel with multiple tabs

Sajid01 — Fri, 22 Jul 2022 17:22:18 GMT

SAS Access interface to PC files is a component of SAS that has to be installed in your server.
This can be checked using SAS Proc Setinit;
Your SAS Admin should be able to help.