View Single Post
Old 01-28-2008, 11:25 AM
Actuarialsuck Actuarialsuck is offline
Join Date: Sep 2007
Posts: 6,125
Default SAS Question

I'm not sure if this question makes sense but here goes.

Assuming I have a dataset that lists Member ID as well as 2 columns for Member Start Date and Member End Date, however those 2 columns are not really the Start and End dates. For every month the Member is active, it will list the starting and end date of that month. So for example (eliminating days), for a member active for the first 3 months in 2007 it would say:

Member Start Date End Date
1 200701 200701
1 200702 200702
1 200703 200703

What I want to create is a table with the "true" start and end dates so for that Member, the output should be

Member Start Date End Date
1 200701 200703

Thank you for any help
Reply With Quote
Page generated in 0.13192 seconds with 9 queries