BookmarkSubscribeRSS Feed
Kekstier
Calcite | Level 5

Hello guys,

as a non IT-professional, I have a question which might sound rather stupid to all the experts here, but I hope you can help me.

In my part time job I have been building up a relational database about German hospitals with SAS EG.

There is a lot of information in it, such as contact details, staff, number of patients etc.

My goal is to make all the information available for every worker at my institute.

Here is an example:

Somebody wants to find all hospitals which have > 500 beds and print their addresses and telephone numbers.

Right now, he would ask me about it, and I would fire up SAS, run my Process flow to create the tables (in my local WORK library), then run the sql-query on my database and give him the results.

This is how i would like it to be:

I run my Project once, and save all the tables on our server (not WORK.). I predefine queries with parameters (such as "how many beds does the hospital have?" ...), so people who don't know how SQL works can get the information.

I think the solution to this is stored processes, BUT

if i want to create one (in EG: New --> Stored Process), the "Stored Process"-button is greyed out! My SAS is not letting me create stored processes!

I have not been able to find any information on the web about this behaviour, but I suspect there is some SAS-program required for stored processes to work, which is not installed on my PC.

Here are my questions: Is this the right way to let other pull information out of my database?

If yes, how can I create stored processes with my SAS copy? (I have uploaded a list of my installed products)

Thank you in advance, and please pardon my bad Englisch

3 REPLIES 3
Haikuo
Onyx | Level 15

I suspect that you don't connect to a SAS Workplace server or Stored process server, eg. your EG is strictly running on your local machine, only connects to your local Base SAS. If that is the case, then No, you can't create a stored process.

You may still try to share your saved project though, if all of your source data are shared within the network.

Haikuo

LinusH
Tourmaline | Level 20

I see from your license that you have Integration Technologies licensed, which I think will make able to use Stored Process. But, how to deploy them from your EG session with this setup, I don't know...

I suggest that you talk to SAS tech support and/or sales representative to validate your requirements.

Data never sleeps
Reeza
Super User

Is SAS installed on your server or your desktop?

If your desktop then you can't create a stored process. However you can set up an EG project with prompts that a user can select and you can create a basic reporting system this way.

It depends on what UX your users will have access to.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 707 views
  • 0 likes
  • 4 in conversation