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
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.
As long as you have the UNC path, and your server can access said path the instructions here should work:
Hi ,
Sorry I didnt understand
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.
Sure I am sorry about that
Hi ,
Can u pls let me know how to export excel files to C drive when I have SAS on Remote server
You'll probably need admin privileges for this:
http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.