Hi,
I was wondering if anyone has had success in doing this or if it is possible?
I'm trying to find a way to do an insert/update routine to load a dataset from SAS into a SharePoint list. I'm sure there is some way I could assign a libname, fileref or even execute a shell script to do it at worst case. From what I can see, I can't find any methods in owssrvr.dll that can handle it. Any help is appreciated.
Cam
Cam;
Depending on the MS Office version you have, you can download the MS Access database for that list to a network folder and run it from there-You need MS Office 2010 and SAS 9.2 (version 2 or 3) to access the accdb db. From there anychanges will be reflected in the parent list online.
That is the only way I found to update those lists. Please also be aware that the lists are only suppose to hold about 2000 items. Otherwise it begins the degrade Sharepoint across the entire enterprise.
I found myself in trouble with IT with 60,000 items at one point.
Hope this helps.
Lawrence
Hi Lawrence,
Can you please provide more details. I have not found anything on the internet regarding this. We have MS Office 2010 but SAS 9.1. will this method you are suggesting work still?
I have created the access table which is basically a MS Access linked table. For some reason my method is not being able to write in this table. I am able to manually copy and paste data to the access table but not able to automatically update with SAS code.
Please help
what is the error you getting?
San Ran-
You need SAS 9.2 version 2 or 3. I think I found out about this after I attempted to run it from my home computer (9.2 ver 1) and it didn't work as prior verions dont have the new MS OLE drivers for the ACCDB database.
I can't recall now where I found the info. Either on this forum or I may have called SAS on the issue.
Lawrence
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.