topic Re: Running SAS in Sharepoint in SAS Programming

Running SAS in Sharepoint

AAndrews — Fri, 12 Feb 2016 17:09:52 GMT

Hi all,

Has anyone set up some sort of a SAS environment within a Sharepoint site? Currently we have everything located on a network drive/share. We potentially need to move some/all of it to a Sharepoint site...aka, have the data, programs, and output all on the site. Need to be able to submit the programs (similar to right-click --> "Batch Submit") through the site.

Any thoughts? We don't have SAS/BI or anything of the sort...I know there are some Web Parts that allow you to run Stored Procedures, but not sure how those work.

If it's not possible or if there are reasons to not do it, please feel free to provide feedback as well.

Re: Running SAS in Sharepoint

LinusH — Fri, 12 Feb 2016 19:49:10 GMT

Never heard of such setup. Somewhere the SAS installation needs to be installed, and that is not "in" sharepoint.
DI you mean that .Sas files should be stored in sharepoint and be called from there? Is this because there is a corporate standard that tells you this?
Theoretically it could be possible but...
What kind of SAS environment do you have today?
Type of users, data, application, SAS products. ..?

Re: Running SAS in Sharepoint

AAndrews — Fri, 12 Feb 2016 20:06:22 GMT

Thank you for the reply. We're currently using Windows SAS Server (Programmers/Statisticians use RDP to connect) and a second drive on the server (virtual) that business users (Data Management, Project Management, Finance, etc.) have mapped to view reports, datasets, etc. No problems with this setup...have had it for 8+ years. However we're working on adding additional security (directory-level with auditing) and some leadership want to utilize our security groups/process we have through our Sharepoint instance.

To me, the amount of updates to programs, potential new software needed, changes in process / SOPs, etc. would never make easier security worth it. Before arguing against it, want to make sure A) is it possible? and B) that I understand any potential benefits of doing this. Seems like it would be handled using Active Directory regardless so not certain of how it's better.

Thanks again!

Re: Running SAS in Sharepoint

Reeza — Fri, 12 Feb 2016 20:25:57 GMT

If you were usinf SAS Studio which is a web interface you could embed the link in a SP page somehow instead of Base SAS.

Re: Running SAS in Sharepoint

AndreasMenrath — Mon, 15 Feb 2016 09:14:48 GMT

Well SharePoint also has a feature to map SharePoint document libraries and its content as a drive in Windows via WebDAV.

All server side security policies are applied. So you would not need to make huge modifications to your current process.

However RDP to a server to run SAS is not a best practice any more.

If you have more concerns on security you should consider using a SAS Server Platform with additional metadata server security.