Hi everyone, hoping someone could assist me with a SAS statement to produce an output I'm after. I have two separate datasets as below: Policy ClaimDate ABC Jan 2012 ABC Aug 2012 ABC Jul 2014 Policy RenewalDate ABC Sep 2012 ABC Sep 2013 ABC Sep 2014 For this policy, I'm trying to group the ClaimDate into the RenewalDate. For example, if the claim is pre Sep 2012, I would like to group it into Sep 2012. If the claim is between Oct 2012 and Sep 2013, I would like to group it into Sep 2013.. and so forth. The final output would be something like this: Policy ClaimDate RenewalDate ABC Jan 2012 Sep 2012 ABC Aug 2012 Sep 2012 ABC Jul 2014 Sep 2014 Thanks in advance! -zorro3338
... View more