topic Re: how to terdata csum function while reading dat from hadoop in sas in SAS Programming

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

Rana_Shivani — Thu, 06 Sep 2018 05:13:29 GMT

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;

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

LinusH — Wed, 05 Sep 2018 09:20:05 GMT

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).

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

Rana_Shivani — Wed, 05 Sep 2018 09:41:23 GMT

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

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

kiranv_ — Thu, 13 Sep 2018 12:37:11 GMT

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