how to use terdata csum function while reading dat from hadoop in sas

[Rana_Shivani]

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;

[LinusH]

Since you are using explicit SQL pass-through, any code there are specific to the remote RDBMS.

So, you should really direct your question to a Hadoop/Hive forum instead.

If you want to drive the logic through SQL implicit pass-through, we are here to help (and first guidance is to consult the supported functions section in SAS/ACCESS to Hadopp documentation).

[Rana_Shivani]

basically I am looking for teradata csum() equivalent function in SAS.

[kiranv_]

In SAS you can use by variables and please check below how ordered analytical functions like CSUM can be achieved in SAS or vice versa.

http://support.sas.com/resources/papers/proceedings11/019-2011.pdf