topic Join transformation takes longer time in SAS Data Management

Join transformation takes longer time

Babloo — Wed, 18 Apr 2018 17:10:05 GMT

Join transformation takes longer time to go complete. I'm joining (inner join) 7 SAS datasets and the excepted output is around 80K records. I don't see any errors in order by or where clause. But when I execute this transformation it keeps running and it neither fails nor completes. No useful information from the log too.

Could someone of you help me to know the possible cause for this issue?

Re: Join transformation takes longer time

LinusH — Wed, 18 Apr 2018 18:59:53 GMT

With the given information no.
If the source tables are not big my guess is that your join condition is not correct.
Try with tiny data sets (3-4 rows in each) and evaluate the outcome.

Re: Join transformation takes longer time

Ksharp — Thu, 19 Apr 2018 12:46:36 GMT

Try to make index for these tables to speed up.