Hi All, i want to combine below mentioned three individual extract transformations into single node instead of 3 different ones in SAS DI job. please suggest. Extract -1 proc sql;
create table work.RRRR as
select
PTPTPTPT,
PSPSPSPSPS,
SSSSSSS,
DDDDDD
from &SYSLAST
where STRIP(UPCASE(PTPTPTPT)) IN ('XXXXX',' ') & STRIP(UPCASE(PSPSPSPSPS))='YYYY' &
STRIP(UPCASE(SSSSSSS)) IN ('DDD','EEE') & DDDDDD >= "&GGGG" D
;
quit; Extract 2 : using Extract 1 work output is further splitted into Extract 2 and Extract 3 transformations
Extract 2:
proc sql;
create table work.RTRTTTRR as
select
*
from &SYSLAST
where SSSSSSS='EEE'
;
quit;
Extract 3 :
proc sql;
create table work.W5XXE8Q6 as
select *
from &SYSLAST
where SSSSSSS= 'DDD' & DDDDDD >= "&DDDTR"D
;
quit; Current scenario is above and i am expecting single extract transformation instead of 3 nodes please. (Note : i don't want to use uwc code transformation please. i want to make use of only SAS DI transformations if possible with extract)
... View more
