Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Import Issue [Data into SAS from Relational Database]

Reply
Occasional Contributor
Posts: 5

Import Issue [Data into SAS from Relational Database]

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

Valued Guide
Posts: 3,208

Re: Import Issue [Data into SAS from Relational Database]

- 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. 

---->-- ja karman --<-----
Occasional Contributor
Posts: 5

Re: Import Issue [Data into SAS from Relational Database]

Thank you. It did eventually finish, but I will look into those things if I run into more issues.

Ask a Question
Discussion stats
  • 2 replies
  • 265 views
  • 3 likes
  • 2 in conversation