Hi Jaap, Thanks for the reply. Here is the complete problem. I have made an web-based interface using sas stored process . Through this interface, you can query on your sas datasets stored on server. Now, i take inputs from the user and process the query in proc sql. Now , the users may fire big queries or queries which consume lots of server time/space. I dont want this to happen. I want user to specify the maximum query time for which the query will be run and when the max query time elapses, the running sql should stop and should not show any result. Now the option/method should not be set at server level because that will apply the max query time to all the stored processes of that server. I hope i make my point very clear. please let me know if you want more details.
... View more