Export Excel workbook from sas file folders to share point

[chennupriya]

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

[Reeza]

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/highlig...

[chennupriya]

Hi ,

Sorry I didnt understand

[Reeza · Accepted solution]

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. 

[chennupriya]

Sure I am sorry about that

[chennupriya]

Hi ,

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

[Reeza]

You'll probably need admin privileges for this:

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