DATA Step, Macro, Functions and more

Importing data from sharepoint

Occasional Contributor
Posts: 13

Importing data from sharepoint

Hi SAS community,


I wanted to ask if anyone has experience with importing data from sharepoint?  Currently, I have to duplicate files onto a personal drive before importing/exporting and its really inefficient.


Thanks in advance for the help!

Super User
Super User
Posts: 9,599

Re: Importing data from sharepoint

What type of file, what setup do you have.  You can reference sharepoint as a network drive, but you need to have the correct privalidges for the machine you do this on. Work with your IT team who should have the network mapping, and be able to assign you the rights.

Super User
Posts: 23,771

Re: Importing data from sharepoint

Do you get a URL to the file? If so you could try the PROC HTTP method?

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation