https://communities.sas.com/t5/SAS-Programming/SAS-HADOOP-procedure-Managing-data-in-Hadoop-is-the-first-order/m-p/297192#M62381 <P>I am rather a beginner in SAS. I have the following problem. Given is a big data set (my_time) which I imported into SAS looking as follows</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/4860iB3C6F36D46B49741/image-size/original?v=v2&amp;px=-1" alt="sas_1.JPG" title="sas_1.JPG" border="0" /></P><P>&nbsp;</P><P>I want to implement the following algorithm for every account look for a status and if it is equal to <STRONG>na</STRONG> then look for the same contract after one year (one year after it gets the status <STRONG>na</STRONG>) and put the information "my_date", "status" and "money" in three new columns "new_my_date", "new_status" and "new_money" like in</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/4861i003B6AC1A5473EE3/image-size/original?v=v2&amp;px=-1" alt="sas_2.JPG" title="sas_2.JPG" border="0" /></P><P>&nbsp;</P><P>I</P><P>need something like <CODE>countifs</CODE> in excel. I found loops in SAS like <A href="https://onlinecourses.science.psu.edu/stat481/node/41" rel="nofollow" target="_blank">DO</A> but not for the purpose to look through all rows. I do not even know for which key word I have to look.</P><P>I would be grateful for any hint.</P> Thu, 08 Sep 2016 14:50:27 GMT manisolimani 2016-09-08T14:50:27Z https://communities.sas.com/t5/SAS-Programming/SAS-HADOOP-procedure-Managing-data-in-Hadoop-is-the-first-order/m-p/297192#M62381 <P>I am rather a beginner in SAS. I have the following problem. Given is a big data set (my_time) which I imported into SAS looking as follows</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/4860iB3C6F36D46B49741/image-size/original?v=v2&amp;px=-1" alt="sas_1.JPG" title="sas_1.JPG" border="0" /></P><P>&nbsp;</P><P>I want to implement the following algorithm for every account look for a status and if it is equal to <STRONG>na</STRONG> then look for the same contract after one year (one year after it gets the status <STRONG>na</STRONG>) and put the information "my_date", "status" and "money" in three new columns "new_my_date", "new_status" and "new_money" like in</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/4861i003B6AC1A5473EE3/image-size/original?v=v2&amp;px=-1" alt="sas_2.JPG" title="sas_2.JPG" border="0" /></P><P>&nbsp;</P><P>I</P><P>need something like <CODE>countifs</CODE> in excel. I found loops in SAS like <A href="https://onlinecourses.science.psu.edu/stat481/node/41" rel="nofollow" target="_blank">DO</A> but not for the purpose to look through all rows. I do not even know for which key word I have to look.</P><P>I would be grateful for any hint.</P> Thu, 08 Sep 2016 14:50:27 GMT https://communities.sas.com/t5/SAS-Programming/SAS-HADOOP-procedure-Managing-data-in-Hadoop-is-the-first-order/m-p/297192#M62381 manisolimani 2016-09-08T14:50:27Z https://communities.sas.com/t5/SAS-Programming/SAS-HADOOP-procedure-Managing-data-in-Hadoop-is-the-first-order/m-p/297197#M62382 <P>There are many ways to solve this.</P> <P>One could be to join the table with itself, with a join&nbsp;condition&nbsp;like a.year = year+1.</P> <P>&nbsp;</P> <P>Another would be some kind of data step processing using retain, but that would require the data to be sorted first.</P> <P>&nbsp;</P> <P>What has PROC HADOOP to do with anything in your inquiry?&nbsp;</P> Thu, 08 Sep 2016 15:26:37 GMT https://communities.sas.com/t5/SAS-Programming/SAS-HADOOP-procedure-Managing-data-in-Hadoop-is-the-first-order/m-p/297197#M62382 LinusH 2016-09-08T15:26:37Z