Hi I am pretty new to the SAS programming. If you can help out with the code i would really appreciate it. Thanks for your help. ... View more

so the output dataset should look something like 12345           4001                 25$       01/25/2009     --showing weekly split of balances 12345           4001                 25$       02/01/2009 12345           4001                 25$       02/08/2009 12345          4001                  25$      02/14/2009 12345         4001                  25$      02/21/2009 12345          4001                  25.25$  02/28/2009 (because balance changed on 02/25/2009) as end of this week balance is 25.25$ Does that makes sense? ... View more

I have a SAS dataset name daily balance. I want to create a new one with weekly balance. from_dt and to_dt represent the range when balances changed.  It is a daily file but to_dt changes only when there is a change in balance. I want to create asofdate for each account which showw weekly balance rather than change date of  balance. For example : account number product_type balance from_dt        to_dt 12345           4001                 25$       01/25/2009   02/24/2009 12345           4001                 25.25$     02/25/2009  03/24/2009 23456           4002                 26           01/26/2009  01/26/2009 23456           4002                 26.27      01/27/2009   01/29/2009 Message was edited by: Anuj Grover ... View more

Hi Allu, I am not able to understand. Can you please provide with some example code? account number product_type balance from_dt        to_dt  12345           4001                 25$       01/25/2009   02/24/2009 12345           4001                 25.25$     02/25/2009  03/24/2009 ... View more