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
... View more