topic Re: Access Sharepoint using SAS in SAS Procedures

Access Sharepoint using SAS

JoshuaHarris — Fri, 31 Aug 2018 06:29:43 GMT

I believe there are couple of ways to read file from sharepoint using SAS. I want to know if we can point SAS to a location in sharepoint (like how we use libname) and then want to check if the sharepoint location contains some 10 excel documents in it or not.
Please let me know if its possible in SAS and if so how this can be done.

Re: Access Sharepoint using SAS

RW9 — Fri, 31 Aug 2018 07:57:43 GMT

Well you can. Sharepoint can be mapped to a network drive just like any other network location. You will need to ask your IT what the network address for it would be. Then once you have the mapped network area, you just libname to it as any other network drive. Its pretty simple, but its mainly your IT department to provide the information and to ensure that SAS install (you didn't mention if it was local, EG, or some other SAS package) would have access to SP. For instance if your running EG which is server based, then the server needs the network mapping and the access to SP.

To get a file list there are many posts out there on this. Again, depends what SAS software you use, but if its locally installed SAS, and you have the network map, then:

filename tmp pipe 'dir "x:/*.xlsx" /b';
data want;
  infile tmp;
  length fname $200;
  input fname $;
run;

Will give you a list of Excel files in that location.

Do bear in mind that sharepoint is an access controlled setup, so reading/writing can be complicated.

Re: Access Sharepoint using SAS

JoshuaHarris — Wed, 05 Sep 2018 11:18:31 GMT

Thanks for your response. I believe we can by the way that you mentioned.
But want to know if i can code something like the URL of the sharepoint and
read the files from there.

Am using 'SAS for windows' in local.

Re: Access Sharepoint using SAS

RW9 — Wed, 05 Sep 2018 11:21:22 GMT

Speak with your IT, as requests to and from Sharepoint are authorised via active directory and such things, and to access the area directly would require some sort of https protocol transfer. Perhaps the http procedure:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a003286672.htm

Re: Access Sharepoint using SAS

JoshuaHarris — Fri, 07 Sep 2018 16:48:28 GMT

Thanks. I will try the http proc and will update the post

Re: Access Sharepoint using SAS

FGao — Mon, 28 Oct 2024 14:33:15 GMT

How did it go? Were you able to do so?