BookmarkSubscribeRSS Feed
amorts
Calcite | Level 5

Hello,

 

I have a SAS DI job which takes a bunch of tables from Oracle, pushes down the join criteria before it hits a table loader which directs the dataset into SAS.

 

The join operation completes very quickly, according to the Stats tab in 1 second and returns 7,931 records but the table loader has been processing for nearly two hours.

 

Options on the table loader are as follows:

Load Style: Replace

Replace: Entire Table

New Rows: Append (Proc Append) 

 

Is there anyway I can work out why this transformation is taking so long? Is it possible to view the process in SAS management studio at all?

1 REPLY 1
LinusH
Tourmaline | Level 20
Loading SAS tables is usually not a performance problem.
Looking sort at the transformation run statistics without be aware of the underlying syntax can be misleading. The default setting for SQL Join and many other transformation is create view. Hence your run time may be in Oracle...
Not sure what you refer to as SAS Management Studio. ASFAIK there is no product with that exact name.
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 822 views
  • 0 likes
  • 2 in conversation