topic Is it possible to create a shell in SAS to run SAS project without showing all the queries to users? in SAS Enterprise Guide

Is it possible to create a shell in SAS to run SAS project without showing all the queries to users?

Jacsanity — Tue, 15 Mar 2016 23:58:39 GMT

Hi guys,

I have a raw SAS project that includes a bunch of queries and programs. Now I need to share this project with some other user who does not have much knowledge on SAS, and I'm wondering if it is possible to create some sort of shall over the current project to create a more friendly user interface?

To be more specific, my current project start with a few query that prompt user to select inputs, and then user these inputs as macro variables in subsequent programs to generate output datasets. However, to start the process you have to go to run and click "Run process flow", which for some user it may be a bit confusing.. If I can make this project more like an application with clean interface without showing all the queries and programs to other users, it will greatly improve their experience.

Please do not hesitate to let me know if you have any suggestions, and thank you very much for your time and effort!

Re: Is it possible to create a shell in SAS to run SAS project without showing all the queries to us

Reeza — Wed, 16 Mar 2016 00:34:26 GMT

Do you have a Web Report Studio?

You can also search at lexjansen.com to see hacks people have used.

Although you'll want to balance how much time you spend improving versus saving end users time. Sometimes really good documentation or instructions are a better way.

Re: Is it possible to create a shell in SAS to run SAS project without showing all the queries to us

LinusH — Wed, 16 Mar 2016 05:49:16 GMT

Have you looked into the possibility to create stored processes?

Re: Is it possible to create a shell in SAS to run SAS project without showing all the queries to us

Kurt_Bremser — Wed, 16 Mar 2016 08:08:41 GMT

If you pack the whole thing into a project flow called "Autoexec", and enable the corresponding option in a given user's EG, he/she only needs to double-click the project file and everything will run automatically.

But I also think that stored processes might be a much nicer way to go, as it does not require any local installation at your "point-and-click" non-SAS-savant user's computers.

Re: Is it possible to create a shell in SAS to run SAS project without showing all the queries to us

ChrisHemedinger — Wed, 16 Mar 2016 12:13:57 GMT

Here is more info on the Autoexec process flow referenced by @Kurt_Bremser.

You can also use the SAS Enterprise Guide automation model to build a standalone app that runs your EG project -- I've done this for some SAS professional services engagements. That's a lot more involved (software development), but the APIs are all there. More info in this paper.