Upload Excel File to SharePoint within SAS

[djbateman]

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.

[Tom · Accepted solution]

Chris posted a blog entry about that.

https://blogs.sas.com/content/sasdummy/2020/07/09/sas-programming-office-365-onedrive/

[djbateman]

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.