topic Re: Export Excel workbook from sas file folders to share point in SAS Enterprise Guide

Export Excel workbook from sas file folders to share point

chennupriya — Wed, 23 Mar 2016 16:08:54 GMT

Hi ,

I have created an excel workbook named Cars in that i have multiple sheets Sheet1, Sheet2, Sheet3 created in SAS file folders and i want to export that excel file to share point . My SAS EG is on Remote server

Can anyone pls help

Re: Export Excel workbook from sas file folders to share point

Reeza — Wed, 23 Mar 2016 16:16:14 GMT

As long as you have the UNC path, and your server can access said path the instructions here should work:

http://support.sas.com/kb/42/054.html

http://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Export-table-to-SharePoint/m-p/226781/highlight/true#M16551

Re: Export Excel workbook from sas file folders to share point

chennupriya — Wed, 23 Mar 2016 17:12:33 GMT

Hi ,

Sorry I didnt understand

Re: Export Excel workbook from sas file folders to share point

chennupriya — Wed, 23 Mar 2016 17:26:02 GMT

Hi ,

Can u pls let me know how to export excel files to C drive when I have SAS on Remote server

Re: Export Excel workbook from sas file folders to share point

Reeza — Wed, 23 Mar 2016 17:29:18 GMT

Essentially it's the same answer as yesterday.

You can use export or libname or any other standard export method, but you need to have the UNC path to your sharepoint location so the file can be created there. Additionally, your server will need access to this location, not just you.

Same to export to your C drive - your server has to have access to your C drive. You'll need to talk to your IT area to set this up.

Otherwise you can export to your server and then FTP file to your desktop. If you're on EG you may have an option to download the file or you can look at the custom Copy task from Chris Hemedinger.

Also, please consider marking some of your older questions answered. People have taken the time to provide help, acknowledging their assistance would be considerate.

Re: Export Excel workbook from sas file folders to share point

Reeza — Wed, 23 Mar 2016 17:30:27 GMT

You'll probably need admin privileges for this:

http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/

Re: Export Excel workbook from sas file folders to share point

chennupriya — Wed, 23 Mar 2016 21:24:11 GMT

Sure I am sorry about that