topic Re: continuous Enrollment in SAS Programming

continuous Enrollment

sandra17 — Fri, 20 Feb 2015 17:26:29 GMT

Hello,

This is regarding the continuous enrollment. I have the initial and final datasets below and In the initial data set, even though the FEB Record is missing still it needs to come as continuous enrollment.

Could anyone of you help on this?

Initial Table
mem_id	plan	bdate	edate
123	a	1/1/2014	1/31/2014
123	a	3/1/2014	3/30/2014
123	b	4/1/2014	04/31/2014
123	b	5/1/2014	5/30/2014
123	b	6/1/2014	06/31/2014
123	a	7/1/2014	7/30/2014
123	a	8/1/2014	8/31/2014
123	a	9/1/2014	9/30/2014

Final Table
mem_id	plan	bdate	edate
123	a	1/1/2014	3/30/2014
123	b	4/1/2014	06/31/2014
123	a	7/1/2014	9/30/2014

Re: continuous Enrollment

Astounding — Fri, 20 Feb 2015 18:53:24 GMT

Here's an easy way, as long as these are the only variables involved. Assuming that the data are properly sorted as you have illustrated:

proc summary data=have;

by mem_id plan notsorted;

var bdate edate;

output out=want (keep=mem_id plan bdate edate) min(bdate)=bdate max(edate)=edate;

run;

If you have additional variables that need to be carried through the process, it can get more complicated.

Good luck.

Re: continuous Enrollment

sandra17 — Tue, 24 Feb 2015 16:56:47 GMT

Thank you so much,it did worked.