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,
RD
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: How to use SAS to access Microsoft 365
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.