02-20-2015 12:26 PM
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?
02-20-2015 01:53 PM
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;
If you have additional variables that need to be carried through the process, it can get more complicated.