BookmarkSubscribeRSS Feed
Rana_Shivani
Calcite | Level 5

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;

 

3 REPLIES 3
LinusH
Tourmaline | Level 20

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

Data never sleeps
Rana_Shivani
Calcite | Level 5

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

kiranv_
Rhodochrosite | Level 12

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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1229 views
  • 0 likes
  • 3 in conversation