Desktop productivity for business analysts and programmers

Converting code from sas to hadoop

Reply
Contributor
Posts: 23

Converting code from sas to hadoop

Convert the SAS code to HADOOP Hive

 

Update BICRS.TEST_Final_MAR18

SET RAL =

Case

When ZIDB < ZCDQ then ZIDB
When ZIDB > ZCDQ then ZCDQ 
else ZIDB
End;

Super User
Posts: 10,574

Re: Converting code from sas to hadoop

Posted in reply to saikiran_nemani

Your logic can be simplified to

min(ZIDB,ZCDQ)

which may be easier to translate.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 23

Re: Converting code from sas to hadoop

Posted in reply to KurtBremser

I want you to convert the full SAS code to HADOOP .........

Super User
Super User
Posts: 9,840

Re: Converting code from sas to hadoop

Posted in reply to saikiran_nemani

Get your wallet out then.  This is a Q&A board, not a contract work site.

Ask a Question
Discussion stats
  • 3 replies
  • 117 views
  • 1 like
  • 3 in conversation