12-15-2009 01:29 AM
12-15-2009 11:36 AM
07-27-2011 11:20 PM
I think I am in the same boat as Narasimha. I followed the documents on connecting Sharepoint and SAS to extracts lists, but was rewarded with an Unauthorized access message to the URL. From that, I found a 2005 note http://support.sas.com/kb/15/692.html that indicates that Filename URL won’t work with the authorization issue I encountered.
Since some of the sample documentation (e.g., SAS Global Paper 390-2009) shows Filename URL working, I am wondering if this indicates that my Sharepoint install is not as basic as I thought or the samples used a program that I don’t have. Can anyone tell me if the functionality for import direct from Sharepoint is only intended to work with Web Parts or for users with a certain level of security?
07-28-2011 06:37 AM
I use following code to download a xls file from sharepoint through proxy server
filename out "C:\temp\testout.xls";
10-19-2011 06:12 PM
Can you tell me how you figured out what the url is of the xls format. Whenever I attempt to figure it out, it exports out but I can't figure out the URL.
10-19-2011 10:56 PM
In your browser, move your mouse to the correspond EXCEL file icon, right click mouse, and select 'Copy link address'. Then you can copy the full url from clipbord.
10-20-2011 11:59 AM
The code below works for me ...
PROC IMPORT OUT= WORK.SHAREPOINTIMPORT
10-20-2011 01:18 PM
Then the question with this syntax is whether your Sharepoint server allows you to view the document folder as if it was a actual network folder. On the sites I have used you can access a document library as if it was a network folder by selecting Open in Windows Explorer from the Actions menu. See image below.
I assume that is a feature that the site owner can turn on or off depending on the security settings that they need, but the details of how are beyond me.
10-21-2011 09:56 AM
You may not be able to "control" the settings, but you can ask to have them changed. IT is (should be) there to help us to do our jobs, not to create barriers!
Security settings can be very narrowly defined so that you only get as much rope as you need to do the specific task. If you don't ask, you won't get!
10-21-2011 06:08 PM
You are right, if you don't ask, you don't get.
Found a much easier solution actually. Our sharepoint allows (some users) to save as an Access 2007-10 DB with a linked table to sharepoint.
Solves the problem!