Hi All, SAS DI job is taking more time to do the inner join between SAS and external table.(After inner join there is table loader creates final table in SAS job) so i tried of using pass through option as yes.but this option is not enabled..to increase the performance. Would you please suggest any other options. please have a look on sample joining code of the DI job. proc sql;
create view work.GTGYHH as
select
EXTERNAL.COL1 length = 8
format = $8.
informat = $8.
label = 'COL1',
EXTERNAL.COL2 length = 8
format = 6.
informat = 6.
label = 'COL2',
EXTERNAL.COL3 length = 8
format = 6.
informat = 6.
label = 'COL3',
SAS_TABLE.COL4 length = 8
format = 6.
informat = 6.
label = 'COL4',
SAS_TABLE.COL5 length = 60
format = $60.
informat = $60.
label = 'COL5',
SAS_TABLE.COL6 length = 8
label = 'COL6',
SAS_TABLE.COL7 length = 8
label = 'COL7'
from
EXTERNAL,
SAS_TABLE
where
SAS_TABLE.JJJJJ = EXTERNAL.JJJJJ
and SAS_TABLE.JJJJJ <> .
and SAS_TABLE.IIIII = "AAA"
;
quit;
... View more
