Thanks for your prompt replies Till evening the space was at 30 % and suddenly it reached above 90% and slowly within couple of hours it reached 100 %. and suddenly after some time all the space came to normal 30 %. /sas is the main mounting point on which all other mounting points falls as below /sas/guide /sas/saswork /sas/util when I watched  all these locations were at 90 % and slowly they reached 100%. so In this kind of situation what is the immediate step i need to take and how can i find which files or users occupying more space and how can i resolve this issue immediately. and what are the file systems i need to check /saswork location i did'nt find any files with the name _TDnnnn folders and i did'nt find any files with bigger than in mega bytes I want to find exactly how can i find which file system and job or user occupied more space which has increased  space  suddenly to maximum ... View more

I tried below code as an test for CARS dataset in sashelp library,but throwing error ERROR: The following columns were not found in the contributing tables: NAME. sql; table test085 as select * from DICTIONARY.TABLES NAME="CARS"; ; ... View more

Linus Hjorth, For restricting the modify and delete permissions to the stored process for the users, I created a Tesgroup with the name "abc" and added user in this group and then created an ACT with readmetadata and read permissions and applied this ACT to this "abc" group and then applied this abc group only on a Test library where I created a sample stored process  and that created a sample employee Dataset .and when I tested the modify and delete permissions it worked perfectly on the stored process.and am not able to delete and modify the stored process. I created stored process in Test library with sample code and that created a Dataset. I tried to modify and delete the stored process and in that way the permissions worked. And also I tried testing the edit for the sample employee dataset which is created in Test library and permissions applied perfectly.and In the same Test library when I preassigned it there were some old datasets in server which created in this library but the edit permissions are not working for these datasets.its working only for the employee dataset which created when i ran a smple stored process. and also I applied the same Testgroup on  a different library where all the stored process and tables are located the modify and delete restrict permissions worked for stored process. But the table edit restrictions not working that library also.and am not sure where I did mistake. please can you suggest ... View more

Thanks for your prompt reply so many of our users runs the stored process daily. so I want to give only read access, when they run these reports they should not be able to modify or delete these stored process.am able to restrict these permissions to those users for these stored process. for restricting modify and delete permissions to the stored process for users,I created a group with the name "abc" and added users in this group and then created a ACT with readmetadata and read permissions and applied this ACT to the "abc" group and then applied this abc group only on the library where the stored process and Data tables are located. and now they are not able to modify and delete the stored process. but am not able to restrict the edit permissions to the Datatables, I mean they should not be able to edit any datasets and change any data. How can I restrict permissions for that. ... View more