Joseph did the heavy lifting for putting together the code and examples in this article. Note: All of this assumes that you already have a Microsoft 365 account - perhaps provisioned by your IT support team - and that you're using it to manage your documents.īy the way, if what you really want to do is manage SAS content within your Microsoft 365 applications with 'point-and-click', then check out SAS for Microsoft 365, which you can use to work with SAS Viya content in your favorite Office apps.īefore I go on, I have to give major credit to Joseph Henry, the SAS developer who maintains PROC HTTP.

In this article, I'll show you how to use SAS programs to reach into your Microsoft OneDrive (or SharePoint Online) cloud to read and update your files.

It also adds some exciting possibilities! The Microsoft 365 suite offers APIs to discover, fetch, and update our documents using code. Oh joy.įor those of us who use SAS to read and create Microsoft Excel documents, cloud-based files can add an extra wrinkle when we automate the process. I can update now my spreadsheets while waiting in the dentist office. It's not yet a complete replacement for having local files on your desktop machine, but with cloud storage and apps - like Microsoft OneDrive - I can now access my work documents from any browser and any device, including my smartphone. If your work environment is like ours here at SAS, you're seeing more of your data and applications move to the cloud.

Onedrive v sharepoint