DATA Step, Macro, Functions and more

Import SAS Dataset to SharePoint List

Reply
Occasional Contributor
Posts: 17

Import SAS Dataset to SharePoint List

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   

Frequent Contributor
Frequent Contributor
Posts: 133

Re: Import SAS Dataset to SharePoint List

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


N/A
Posts: 1

Re: Import SAS Dataset to SharePoint List

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

Frequent Contributor
Posts: 138

Re: Import SAS Dataset to SharePoint List

what is the error you getting?

Frequent Contributor
Frequent Contributor
Posts: 133

Re: Import SAS Dataset to SharePoint List

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

Ask a Question
Discussion stats
  • 4 replies
  • 902 views
  • 0 likes
  • 4 in conversation