Greetings,
I have a data import job that usually runs in just a few minutes that is not completing. [It has been over 30 mins]. Nothing has change in the relational database [postgres] that I know of. The data set size is about the same is it always has been. Is there something I should check, or maybe something that needs to be reset?
Thanks,
John
- Check, if possible the session in postgress is not hanging, becoming not responsive.
- As there should be some processing on sas check it is still a valid process and does not got hang up by shortage of some resource.
The saswork or default directory ($home) are candidates. There are many more of them all different on OS type.
- Sometimes an previous error can have corrupted you db-connection. You have to restart and retry again.
Seeing this being happend by trying to sort the DBMS-table in a SAS way. Proc sort cannot run on a DBMS-table.
Thank you. It did eventually finish, but I will look into those things if I run into more issues.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.