I am working on migration project.Earlier I was reading data from Teradata but now I will be reading the same data from Hadoop. But in my code to read data from Teradata. Function csum(1,data_record_creayed desc,time_reacord_created desc),How can I rewire this code while reading from Hadoop in SAS. Sample code: proc sql;
connect to Teradata as select *
from
(select accounted,
creditlimit,
csum(1,data_record_creayed desc,time_reacord_created desc)
from table abc group by 1) as dsout(accounted,c_lim,dsout)
where dsout.dsout=1
orderby accounted;
quit;
... View more
