We have batch jobs that were running fine without any issue for a long time. From last week onwards we are seeing that the jobs are long running. Our's is a sas environment hosted on linux machine. We have not made any changes to the code recently. The only thing i can see within the logs is that the real time of the procedure or data step has increased. We have checked wih Unix admins and they have told that no other process is running on the server. We have also run the jobs at different times to see if its a  timing isue. But did not get any difference. Only thing we can notice is high i/o utilization on sas work library mount which was not there previously. Have anyone faced this issue or guide me on what to check further to imprve the performance   now:   real time 37:04.73 user cpu time 9:49.74 system cpu time 5:39.84 memory 2110359.71k OS Memory 2120860.00k Timestamp 07/06/2020 09:43:48 PM Page Faults 31 Page Reclaims 2235141 Page Swaps 0 Voluntary Context Switches 8831289 Involuntary Context Switches 1730716 Block Input Operations 335352296 Block Output Operations 722203936   before :  real time 9:30.78 user cpu time 8:15.08 system cpu time 5:14.26 memory 2110359.71k OS Memory 2120860.00k Timestamp 06/30/2020 08:40:02 PM Page Faults 33 Page Reclaims 2068727 Page Swaps 0 Voluntary Context Switches 8136300 Involuntary Context Switches 897939 Block Input Operations 332189320 Block Output Operations 727054200 ... View more

Hi All,   We have a SAS DI job that runs for 1 hour the day after server restart. On all subsequent runs the job is taking more than 4 hours till the server is restarted again. On checking the job logs, it is showing that jobs are long running at points where threaded sort is used. Can someone help me understand why after server restart the job runs fine for 1 time and then it is long running afterwards. Any pointers to help me trouble soot will be helpful   Thanks, Naveen ... View more

I am trying to update the license on our SAS server and getting the below error   UNABLE TO OPEN/READ MESSAGE FILE USING THE -MSG PATHS   I have followed the same steps followed for the last few years. This is a new error i am seeing. Can someone help in finding the issue.    Creating the SAS server object ... Completed. _______________________________________________________________________________ Running SAS/SASHome/SASFoundation/9.3/setinit.sas. SAS log will be in SAS/SASHome/SASFoundation/9.3/install/admin/sas/setinit.log. UNABLE TO OPEN/READ MESSAGE FILE USING THE -MSG PATHS   The log is not getting created.  ... View more

I am using SAS Financial Management 5.3 and have to delete the records from "not in hierarchy" . Currently i am using the delete option within the SAS FM 5.3. But  this process is very slow and it is taking huge amount of time to delete the records manually. I am looking for any job/macros that can be created which can delete such records more quicky.     ... View more