We collect data from the organisation with Sharepoint Lists. Now we are reporting in Excel and there is Excel a connection to the Sharepoint server. I want to use the Sharepoint data in SAS and want to read it with SAS/EG.
Does anybody know a (easy) way to build this?
Nothing documented for accessing SharePoint.
But excel does. Than if that is an odbc connection you could do that in the same way.
The mail-outlook list is also accessible in that approach.
In SharePoint you can export a List to Excel, which becomes a live link, if you tell it to update appropriately.
We then set up SAS to read this excel spreadsheet.
A bit roundabout but works fine.
Hi Reeza,
Your suggestion is coming close to the solution I am using now. I have made a connection with an Access database. In Acces you can import a Lists directly. When the lists are updatet in Sharepoint I don't need to open the database first, but I can collect the updatet data via my SAS/EG project.
This is not what I wanted, because I want to collect the data direct with SAS/EG from the Sharepoint List. It is now an extra step.
I did some googling on "odbc connection sharepoint list", found a lot like:
Add a database as a data source - SharePoint Designer (data from SQL to sharepoint, Microsoft)
SharePoint List Connection Type (SSRS) (data from sharepoint to SQL, Microsoft)
SharePoint connection strings - ConnectionStrings.com (connectionstrings)
I found this http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroog... talking about how to access sharepoint from SAS. I hope it helps.
Awesome, thanks that does help
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.