You say "server", your libanme is called "database", and your CPU is close to zero.
Could it be that you are fetching data from an external RDBMS?
If so, add the following to our program:
options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;
Using that output, you can talk to your DBA to see if you together can optimize the code/storage.
If your data is in SAS, the other suggestions in the thread may apply. Consider creating an index. And to get better control on what is happening, add:
options fullstimer msglevel=i;
... View more