Desktop productivity for business analysts and programmers

Export Excel workbook from sas file folders to share point

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 120
Accepted Solution

Export Excel workbook from sas file folders to share point

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


Accepted Solutions
Solution
‎03-23-2016 05:23 PM
Grand Advisor
Posts: 17,338

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

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. 

View solution in original post


All Replies
Grand Advisor
Posts: 17,338

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

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

Frequent Contributor
Posts: 120

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

Hi ,

Sorry I didnt understand

Solution
‎03-23-2016 05:23 PM
Grand Advisor
Posts: 17,338

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

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. 

Frequent Contributor
Posts: 120

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

Sure I am sorry about that

Frequent Contributor
Posts: 120

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

Hi ,

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

 

 

Grand Advisor
Posts: 17,338

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

You'll probably need admin privileges for this:

 

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 474 views
  • 0 likes
  • 2 in conversation