SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Writing SAS Output to Sharepoint Document Libraries

Reply
N/A
Posts: 0

Writing SAS Output to Sharepoint Document Libraries

Has anyone had any success writing SAS Output to Sharepoint Document Libraries?


I found a SUGI Paper on the topic here:
http://support.sas.com/resources/papers/proceedings09/390-2009.pdf

I've experimented with the first method described by the author.
(Writing ODS output to Fileshares using fully-resolved File path names is a technique I use frequently.)


Attempting to write to the File path I get the following error message:
ERROR: Insufficient authorization to access \\mysite.Sharepoint.domain\personal\Username\Shared
Documents\Test Document Folder\Site_Test2.html


If this worked it would be exactly what I'm looking for.
Does anyone write SAS Reports to a Sharepoint Doc Library?

Other Question:
In the document the author states:
"When writing to a SharePoint document library via a UNC path on Microsoft Windows Server, the Web Client Service must be enabled."

Does anyone know what he's talking about?
I run SAS via Enterprise Guide and a remote SAS server.
Does this refer to a setting on the Sharepoint Server, the SAS Server, or my local Machine?

Thanks to anyone who can provide some guidance.
SAS Super FREQ
Posts: 8,643

Re: Writing SAS Output to Sharepoint Document Libraries

Hi:
If you read the entire parenthetical remark in that paper, it implies that the Web Client services is technology that belongs to Windows/Microsoft:

(Note: When writing to a SharePoint document library via a UNC path on Microsoft Windows Server, the Web Client Service must be enabled. This service allows you to access WebDav resources over HTTP. You can enable the Web Client Service via the Windows Services snap-in on the Microsoft Management Console.)


If you Google the Microsoft Management Console "snap-in", you will find links that explain the MMC, and this is one of them:
http://www.theeldergeek.com/microsoft_management_console.htm

cynthia
N/A
Posts: 0

Re: Writing SAS Output to Sharepoint Document Libraries

Through Control Panels => Administrative Tools => Computer Management => Services , I navigated to the WebClient service on my local machine.


There is no property I can find called "Enable", but it is "Started" and appears to be running correctly.

It suggests that the setting needs to be enabled on the machine actually executing the SAS code, in this case our remote SAS Server for EG.
(Or possibly the server running Sharepoint, though I consider that less likely.)

I expect that the author of the paper didn't anticipate running SAS remotely via EG.

Always a pain for us as our site does not run a test SAS Server, so when a solution requires changes to the box actually running SAS our Internal support require a lot of convincing.


That or there is a problem with my code. Message was edited by: Bjorn@Enbridge
SAS Super FREQ
Posts: 8,643

Re: Writing SAS Output to Sharepoint Document Libraries

Hi,
I'd recommend working with Tech Support on this one -- configuring servers and making things work with Sharepoint needs to be tested by folks who understand the platforms and issues involved.

cynthia
N/A
Posts: 0

Re: Writing SAS Output to Sharepoint Document Libraries

Just to be 100% clear -
Do you suggest engaging with SAS Technical Support or our Internal Support?
SAS Super FREQ
Posts: 8,643

Re: Writing SAS Output to Sharepoint Document Libraries

I thought that you might start with SAS Tech Support so they could verify what it is you need to change on your server and so they could also give you help with directions that you could then take to your own server folks to implement.

cynthia
Post a Question
Discussion Stats
  • 5 replies
  • 3577 views
  • 0 likes
  • 2 in conversation