Upload Excel File to SharePoint within SAS

djbateman — Fri, 13 May 2022 14:55:19 GMT

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.

Re: Upload Excel File to SharePoint within SAS

Tom — Fri, 13 May 2022 15:06:36 GMT

Chris posted a blog entry about that.

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

Re: Upload Excel File to SharePoint within SAS

djbateman — Fri, 13 May 2022 20:20:27 GMT

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.

topic Re: Upload Excel File to SharePoint within SAS in SAS Programming

Upload Excel File to SharePoint within SAS

Re: Upload Excel File to SharePoint within SAS

Re: Upload Excel File to SharePoint within SAS