topic Re: Import SAS Dataset to SharePoint List in SAS Programming

Import SAS Dataset to SharePoint List

CameronL — Thu, 17 Nov 2011 11:38:37 GMT

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

Re: Import SAS Dataset to SharePoint List

LB — Fri, 06 Apr 2012 14:56:18 GMT

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

Re: Import SAS Dataset to SharePoint List

san_ran — Tue, 24 Apr 2012 04:20:43 GMT

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

Re: Import SAS Dataset to SharePoint List

manojinpec — Tue, 24 Apr 2012 04:27:54 GMT

what is the error you getting?

Re: Import SAS Dataset to SharePoint List

LB — Tue, 24 Apr 2012 15:48:02 GMT

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