topic Re: Proc import from teams in SAS Programming

Proc import from Microsoft Teams

Marwa_Se — Tue, 08 Jun 2021 12:31:33 GMT

Hello everybody,

Is there any way to import files on SAS from microsoft teams ?

Thank you in advance!

Marwa,

Re: Proc import from teams

japelin — Tue, 08 Jun 2021 11:33:07 GMT

If you have already downloaded the file, you can import it, but I think it is difficult to directly import a file on teams, i.e. on the sharepoint server, due to authentication.

Re: Proc import from teams

ChrisHemedinger — Tue, 08 Jun 2021 12:30:58 GMT

Microsoft Teams files are actually SharePoint Online in the background, and that's similar to OneDrive in terms of access. It's stored in the cloud, and if you want to access it using a SAS program (aside from using a locally sync'd copy) you need to use Microsoft APIs.

A complete explanation and examples are available here: Using SAS with Microsoft 365. I also posted a video tutorial here: