Not getting the correct output in the last row. Getting - Coverage_Start Termination_Date Member_Id 24JUL2019 01MAR2020 W22442968701 Want - Coverage_Start Termination_Date Member_Id 24JUL2019 01Jun2021 W22442968701 ... View more

This works but not the efficient one if we run this code on millions of row it will generate around 365 date for each row in do loop ... View more

1. No. Dates are in date9. format.  2. I have a dataset having millions of row I want reduce the number rows against each member_id.     The above obs are sample of rows against a member.  ... View more

1. Yes, the grouping vairable is member_id.   2. For first two observations, since there is no break between them so took the minimum of coverage_start and maximum of termination_date in the desired output.   3. Member_id in last obs should be 42968701. Sorry for the typo. ... View more

I have a dataset i.e. -   Coverage_Start Termination_Date Member_Id 24-Jul-19 1-Jun-21 42968701 24-Jul-19 1-Mar-21 42968701 29-Feb-20 1-Mar-20 42968701 16-Feb-19 1-Mar-19 42968701 1-Mar-17 1-Mar-18 42968701 1-Mar-16 1-Mar-17 42968701 1-Dec-15 31-Dec-16 42968701   I want to reduce this dataset, suppose in last three rows minimum coverage_start- 1-Dec-15 and maximum termination_date- 1-Mar-18, so I want to combine all three bottom rows because it has continuous coverage. As result the bottom three rows will be reduced to "1-Dec-15 1-Mar-18 42968701".   Reduced Dataset should be like -   Coverage_Start Termination_Date Member_Id 24-Jun-19 1-Jun-21 42968701 16-Feb-19 1-Mar-19 42968701 1-Dec-15 1-Mar-18 42968701c   Can anyone please help me with this? I'm trying this since a very log time but couldn't achieve it. ... View more

I have a dataset i.e. - Coverage_Start Termination_Date Member_Id 24-Jul-19 1-Jun-21 42968701 24-Jul-19 1-Mar-21 42968701 29-Feb-20 1-Mar-20 42968701 16-Feb-19 1-Mar-19 42968701 1-Mar-17 1-Mar-18 42968701 1-Mar-16 1-Mar-17 42968701 1-Dec-15 31-Dec-16 42968701 I want to reduce this dataset, suppose in last three rows minimum coverage_start- 1-Dec-15 and maximum termination_date- 1-Mar-18, so I want to combine all three bottom rows because it has continuous coverage. As result the bottom three rows will be reduced to "1-Dec-15 1-Mar-18 42968701". Reduced Dataset should be like - Coverage_Start Termination_Date Member_Id 24-Jun-19 1-Jun-21 42968701 16-Feb-19 1-Mar-19 42968701 1-Dec-15 1-Mar-18 42968701 I want to achieve this task using SAS programming. Can anyone please help me with this? I'm trying this since a very log time but couldn't achieve it. ... View more