![sas 8.1 add in for excel 2016 download sas 8.1 add in for excel 2016 download](https://2.bp.blogspot.com/-dwysjpkaQAw/WDzCun7bP1I/AAAAAAAAAIA/PginDOk_jb8MnV0OhaNpMbelLG57u3doQCEw/s320/vancouver-photo-video.jpg)
If you're accustomed to the simpler style of just user/password authentication (ah, those were the days), OAuth2 can be intimidating. Microsoft Office 365 uses an OAuth2-style authentication flow to grant access and permissions to third-party apps. Using SAS with Microsoft OneDrive: an overview He also regularly adds new features to PROC HTTP that make it a more natural fit for calling REST APIs that require special authentication flows, such as OAuth2. 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 Office 365 account - perhaps provisioned by your IT support team - and that you're using it to manage your documents.īefore I go on, I have to give major credit to Joseph Henry, the SAS developer who maintains PROC HTTP.
SAS 8.1 ADD IN FOR EXCEL 2016 DOWNLOAD HOW TO
In this article, I'll show you how to use SAS programs to reach into your Microsoft OneDrive cloud to read and update your files. It also adds some exciting possibilities! The Microsoft Office 365 suite offers APIs to discover, fetch, and update our documents using code.
![sas 8.1 add in for excel 2016 download sas 8.1 add in for excel 2016 download](https://linux-cdn.softpedia.com/screenshots/SQuirreL-SQL-Client_2.png)
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.