Just I tested your code and it is producing 159 rows instead of 50-60 rows. I need the data like below. When i ran your program, I got the output like,                                                             start_                                       Obs    name     date     end_date                                         1    Raj      19756      19875                                         2    Raj      19763      19882                                         3    Raj      19770      19889                                         4    Raj      19777      19896                                         5    Rav      19756      19875                                         6    Rav      19763      19882                                         7    Rav      19770      19889                                         8    Rav      19777      19896                                         9    Ram      19756      19875                                        10    Ram      19763      19882                                        11    Ram      19770      19889                                        12    Ram      19777      19896 But I need the output like,                                                              start_                                       Obs    name     date     end_date                                         1    Raj       03feb2014   07feb2014                                         2    Rav       10feb2014   14feb2014                                         3   Ram       17feb2014   21feb2014 till last week of june or december ... View more

Ideally I used to perform SCD's (1,2 & 3) in DI Studio transformation. But I wish to understand how it can be accomplished in via SAS coding. Unfortunately I don't have data at the moment to share you though. My source and target is SAS datasets. It would be fine if you can explain me with the sample data or just provide me the outline especially for SCD-3. ... View more

Thanks Patrick for your response. I meant output table as an report. Yes, I've achieved the SCD's in DI but I wish to implement the same via coding. Because there may a situation in near future where I need to implement the SCD's via base\advanced SAS. I understand it is difficult to achieve it in coding and hence I request you to provide me the outline which I already mentioned in my earlier post. Thanks. ... View more

I was wondering for an response - Can someone shed some light on this? ... View more

Thanks for your suport and patience. But still it is now working as i expect. See the output below for your code after I changed day 3 to day4 in end_date variable                                      obs   start_date   end_date    name                                       1    04FEB2014    02FEB2014    Raj                                       2    07FEB2014    10FEB2014    Raj                                       3    10FEB2014    18FEB2014    Raj                                       4    13FEB2014    22FEB2014    Raj                                       5    04FEB2014    02FEB2014    Rav                                       6    07FEB2014    10FEB2014    Rav                                       7    10FEB2014    18FEB2014    Rav                                       8    13FEB2014    22FEB2014    Rav                                       9    04FEB2014    02FEB2014    Ram                                      10    07FEB2014    10FEB2014    Ram                                      11    10FEB2014    18FEB2014    Ram                                      12    13FEB2014    22FEB2014    Ram ... View more

I think you've misunderstood my question. I agree with you, but I looking for end date is startdate+4 days and not 06jun2014. i need the output as below ... View more

thanks - Format is fine. But I need the output as I mentioned earlier. ... View more

Your code is perfect. But I would like achieve the same with intnx function meant via RW9's code. Please suggest. ... View more

When i ran your program, I got the output like,                                                             start_                                       Obs    name     date     end_date                                         1    Raj      19756      19875                                         2    Raj      19763      19882                                         3    Raj      19770      19889                                         4    Raj      19777      19896                                         5    Rav      19756      19875                                         6    Rav      19763      19882                                         7    Rav      19770      19889                                         8    Rav      19777      19896                                         9    Ram      19756      19875                                        10    Ram      19763      19882                                        11    Ram      19770      19889                                        12    Ram      19777      19896 But I need the output like,                                                              start_                                       Obs    name     date     end_date                                         1    Raj       03feb2014   07feb2014                                         2    Rav       10feb2014   14feb2014                                         3   Ram       17feb2014   21feb2014 till last week of june or dcember ... View more

If my input is character, then how to add leading zeros for the variable with character datatype? ... View more