https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457710#M29486 <P>Your logic can be simplified to</P> <PRE>min(ZIDB,ZCDQ)</PRE> <P>which may be easier to translate.</P> Thu, 26 Apr 2018 13:09:47 GMT Kurt_Bremser 2018-04-26T13:09:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457702#M29485 <P>Convert the SAS code to HADOOP Hive</P><P>&nbsp;</P><P>Update BICRS.TEST_Final_MAR18</P><P>SET RAL =</P><P>Case</P><P>When ZIDB &lt; ZCDQ then ZIDB<BR />When ZIDB &gt; ZCDQ then ZCDQ&nbsp;<BR />else ZIDB<BR />End;</P> Thu, 26 Apr 2018 12:56:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457702#M29485 saikiran_nemani 2018-04-26T12:56:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457710#M29486 <P>Your logic can be simplified to</P> <PRE>min(ZIDB,ZCDQ)</PRE> <P>which may be easier to translate.</P> Thu, 26 Apr 2018 13:09:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457710#M29486 Kurt_Bremser 2018-04-26T13:09:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457716#M29487 <P>I want you to convert the full SAS code to HADOOP .........</P> Thu, 26 Apr 2018 13:15:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457716#M29487 saikiran_nemani 2018-04-26T13:15:45Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457725#M29488 <P>Get your wallet out then.&nbsp; This is a Q&amp;A board, not a contract work site.</P> Thu, 26 Apr 2018 13:21:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Converting-code-from-sas-to-hadoop/m-p/457725#M29488 RW9 2018-04-26T13:21:55Z