DSXchange

[quote="ArndW"]arsh14, welcome to DSXchange. I am not familiar with the rolllike function and can guess at what you wish to do but cannot be certain. Perhaps you could explain the logic in text form and you will probably get more accurate and quicker responses to your question.[/quote] Wha...

I am trying to duplicate the mainframe SAS code for Rolllike function. I have 4 sets of columns as keys and 2 sets of dates. See data below: K1 K2 D1 D2 F1 F2 A 1 2006-01-01 2006-12-31 X 10 A 1 2007-01-01 2007-12-31 X 10 A 1 2008-01-01 2009-12-31 X 10 A 2 2006-01-01 2006-12-31 X 10 A 2 2007-01-01 20...