topic Re: SAS dataset to SharePoint list in SAS Programming

SAS dataset to SharePoint list

Banana19 — Fri, 04 Mar 2022 16:04:25 GMT

Hi All - As the subject line says I was trying to figure out a way to automate the following scenario. I have a SAS dataset and I wanted to automatically send the data to SP to create a SP list. Is this possible? I'm currently exporting the SAS dataset to an excel and changing the format to a tabular format and manually uploading it to SP site to create a SP list. I've seen couple of documents but these documents say that dataset can be stored in a SP site as an XLSX file. Thanks in advance!

Thank you,

Re: SAS dataset to SharePoint list

ChrisHemedinger — Fri, 04 Mar 2022 18:41:11 GMT

At this point most people are using SharePoint Online (Microsoft 365) - is that true for you?

Your task could be accomplished using Microsoft APIs, but it does require some set up and maybe some permissions from the team that maintains your Microsoft 365 environment. See a How To in this article:

Re: SAS dataset to SharePoint list

Sajid01 — Sat, 05 Mar 2022 19:06:29 GMT

Hello @Banana19
Please have a look at this video from SAS. This should solve your problem.
https://video.sas.com/detail/video/3728508152001/add-sas-content-to-a-microsoft-sharepoint-site

Re: SAS dataset to SharePoint list

Banana19 — Tue, 08 Mar 2022 02:32:38 GMT

Thank you! I probably need to check with the team that maintains our Microsoft 365 environment.

Re: SAS dataset to SharePoint list

Banana19 — Tue, 08 Mar 2022 02:33:33 GMT

Thank you! I need to check with the team that maintains our Microsoft 365 environment because I probably do not have admin level privilege's for SP site.