Import SAS Dataset to SharePoint List

[CameronL]

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   

[LB]

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

[san_ran]

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

[manojinpec]

what is the error you getting?

[LB]

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