https://communities.sas.com/t5/New-SAS-User/reconcilation-of-debit-and-credit/m-p/621434#M19631 <P>on day one i have data like as below</P><P>sno debit credit chequeid vdate<BR />1 200 0 1234 01-jan-2020<BR />2 200 0 1234 01-jan-2020<BR />3 400 0 4567 01-jan-2020<BR />4 400 0 4567 01-jan-2020<BR />5 400 0 4567 01-jan-2020<BR />6 600 0 6789 01-jan-2020</P><P>and on day 2 i have data like this as appended to day 1 data the final input as</P><P>sno debit credit chequeid vdate<BR />1 200 0 1234 01-jan-2020<BR />2 200 0 1234 01-jan-2020<BR />3 0 200 1234 02-jan-2020<BR />4 400 0 4567 01-jan-2020<BR />5 400 0 4567 01-jan-2020<BR />6 400 0 4567 01-jan-2020<BR />7 0 400 4567 02-jan-2020<BR />4 600 0 6789 01-jan-2020</P><P>So the final output i required is</P><P>dataset1</P><P>sno debit credit chequeid vdate flag<BR />1 200 0 1234 01-jan-2020 matched<BR />2 0 200 1234 02-jan-2020 matched<BR />3 400 0 4567 01-jan-2020 matched<BR />4 0 400 4567 02-jan-2020 matched</P><P>dataset2</P><P>sno debit credit chequeid vdate flag<BR />1 200 0 1234 01-jan-2020 open<BR />2 400 0 4567 01-jan-2020 open<BR />3 400 0 4567 01-jan-2020 open</P><P>Please do the needfull</P><P>Thanks in advance</P><P>ance</P> Fri, 31 Jan 2020 14:43:03 GMT rohithverma 2020-01-31T14:43:03Z https://communities.sas.com/t5/New-SAS-User/reconcilation-of-debit-and-credit/m-p/621434#M19631 <P>on day one i have data like as below</P><P>sno debit credit chequeid vdate<BR />1 200 0 1234 01-jan-2020<BR />2 200 0 1234 01-jan-2020<BR />3 400 0 4567 01-jan-2020<BR />4 400 0 4567 01-jan-2020<BR />5 400 0 4567 01-jan-2020<BR />6 600 0 6789 01-jan-2020</P><P>and on day 2 i have data like this as appended to day 1 data the final input as</P><P>sno debit credit chequeid vdate<BR />1 200 0 1234 01-jan-2020<BR />2 200 0 1234 01-jan-2020<BR />3 0 200 1234 02-jan-2020<BR />4 400 0 4567 01-jan-2020<BR />5 400 0 4567 01-jan-2020<BR />6 400 0 4567 01-jan-2020<BR />7 0 400 4567 02-jan-2020<BR />4 600 0 6789 01-jan-2020</P><P>So the final output i required is</P><P>dataset1</P><P>sno debit credit chequeid vdate flag<BR />1 200 0 1234 01-jan-2020 matched<BR />2 0 200 1234 02-jan-2020 matched<BR />3 400 0 4567 01-jan-2020 matched<BR />4 0 400 4567 02-jan-2020 matched</P><P>dataset2</P><P>sno debit credit chequeid vdate flag<BR />1 200 0 1234 01-jan-2020 open<BR />2 400 0 4567 01-jan-2020 open<BR />3 400 0 4567 01-jan-2020 open</P><P>Please do the needfull</P><P>Thanks in advance</P><P>ance</P> Fri, 31 Jan 2020 14:43:03 GMT https://communities.sas.com/t5/New-SAS-User/reconcilation-of-debit-and-credit/m-p/621434#M19631 rohithverma 2020-01-31T14:43:03Z https://communities.sas.com/t5/New-SAS-User/reconcilation-of-debit-and-credit/m-p/621436#M19632 <P>Please don't make us guess. Please tell us the logic that takes the raw data and produces output data set 1 and ouptut data set 2.</P> Fri, 31 Jan 2020 14:49:46 GMT https://communities.sas.com/t5/New-SAS-User/reconcilation-of-debit-and-credit/m-p/621436#M19632 PaigeMiller 2020-01-31T14:49:46Z