Controlling your SAS environment and its users
From sasCommunity
sasCommunity Forum : Suggestions for Forums and Categories : Controlling your SAS environment and its usersBy Ashbycs on Sat Apr 21, 2007 5:08 pm
Hello,
I'm looking for ideas from the SAS community on how to control andd promote best practice in a SAS8.2 environment running on a UNIX AIX5.1 environment.
I have a large environment, circa 18Tb of data which is mostly SAS datasets that are unmodelled. The environment is shared across a number of user groups ranging from MI developers to deep analytics. The environment suffers from I/O problems and cannot be upgraded any further. There is a project to replace but this will take time to implement.
I'm looking therefore for ideas on
1. How to queue adhoc requests to the environment - ensuring that only a specified number of jobs are running at any one time. 2. How to identify poor users 3. How to promote best practice across a large user base.
Thanks
Private Message | Personal Page | Quote
By Rajat.mit on Sun Dec 30, 2007 12:19 am
Hi, I have read your problem, according to me you can try any of the following solutions:
1. If the datasets and libraries are fixed for the particular users, then you can set the library assignments pertaining to a particular user through autoexec.sas, by doing so only libraries required by a particular user would be available to him for the use, and other libraries won't be loaded. 2. Optmizing the queries in the code 3. Lay out a batch control process, which will be storing the information about a particular user, like what are the batch that particular user is using, and then on the basis of that information, you can design your process flow, which will help in scheduling the conflicting processes and also helps in finding the poor user. 4. Fourth, is the hardware constraints, since you are using AIX5.1, then you can divide your single disk into two seperate disks, logically, which will help in reducing the contention.
After reading your entire scenario, I think 3 option is the most suited for you. I have also came across the same problems in my project in the past and we have tried all the above mentioned solutions and found that 3rd and 4th are most optimal solutions, as coding generally everyone's take care so I am expecting your code is already in the best optimized state.
Private Message | Personal Page | Quote
