https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546041#M16807 <P>What <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447">@Patrick</a> said: transpose, and it's almost a non-issue. See Maxims 19 &amp; 33.</P> Tue, 26 Mar 2019 07:24:33 GMT Kurt_Bremser 2019-03-26T07:24:33Z https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546022#M16805 Hello!<BR />My data looks like this:<BR />Acct x1 x2 ...x24 date1 date2 ... date24<BR />qaz 12 15 ...45 1jan19 1feb19 ... 1dec20<BR />wsx 60 41 10aug18 10sep18<BR /><BR />Basically, I have monthly payments x1, x2 up to x24 that a customer needs to pay on date1,date2 up to date24. Some accounts will have up to x12 and date12(12 months and not 24). <BR />How do I get the sum of all payments(x1,x2,..,) where the corresponding date is less than a particular date for each account?<BR />Any advice will be appreciated<BR /> Tue, 26 Mar 2019 04:14:07 GMT https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546022#M16805 JT99 2019-03-26T04:14:07Z https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546031#M16806 <P>Transpose your data into a narrow format with columns Acct Amount Date and everything else becomes simple.</P> Tue, 26 Mar 2019 06:31:58 GMT https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546031#M16806 Patrick 2019-03-26T06:31:58Z https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546041#M16807 <P>What <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447">@Patrick</a> said: transpose, and it's almost a non-issue. See Maxims 19 &amp; 33.</P> Tue, 26 Mar 2019 07:24:33 GMT https://communities.sas.com/t5/SAS-Data-Management/Sum-of-rows-in-array-with-condition/m-p/546041#M16807 Kurt_Bremser 2019-03-26T07:24:33Z