I have done a lot of searching, and I can't find an answer that works for me. I need to see if it is possible to use SAS (not SAS EG) to copy an Excel file from a file explorer to a SharePoint site. I'm using SAS 9.4 (TS1M3).
My general process is to use SAS to export a dataset to an Excel file (complete with titles, headers, and filters in place). Is it possible to then copy that Excel file to a SharePoint site? I use the X commands to copy Excel files from one folder to another as needed, but I don't think I can get it to work on a SharePoint site. On top of that, I may need to create folders on the SharePoint site to organize output over time. Does it sound possible to do what I'm explaining? If so, can someone point me to a good resource to help me get started? I can't find anything.
Chris posted a blog entry about that.
https://blogs.sas.com/content/sasdummy/2020/07/09/sas-programming-office-365-onedrive/
Chris posted a blog entry about that.
https://blogs.sas.com/content/sasdummy/2020/07/09/sas-programming-office-365-onedrive/
Thank you. This is a good start. It will take some time to absorb it all, but thank you for pointing me in the right direction.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.