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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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
  • 1192 views
  • 0 likes
  • 3 in conversation