06-06-2016 05:25 AM
Well, Sharepoint can be mapped to a network drive just like any other network drive. If you speak to your IT group they should be able to help you with this. Note that your SAS will need to be able to access that network area - i.e. if your SAS is a network then that network needs access rights to Sharepoint - often that is done locally on your machine. Again, your IT will be able to help with this.
Once you have it linked as a network path, then you simply import as normal:
proc import datafile="d:\<path>\<filename>.xlsx"...
Where D is mapped to the Sharepoint site.
06-07-2016 10:47 AM
Assume thats toward me yes? What "doesn't work"? The code you want is a simple proc import of a file once you have sharepoint mapped to network drive. What did your IT group say?
06-06-2016 05:38 AM
Just puzzle pieces never done this before
How about using the URL access method to get the file and Sharepoint Excel Services REST.
Using the REST API, you can access workbook parts or elements directly through a URL so hopefully it works with filename url access method.