I have a begin period, say 1/1/2011 I have an end period, say 1/10/2014 I want to write a code that outputs a 1 for every month this person is eligible and a 0 if the person ceased eligibility. Within the eligibility period it is possible that a person could have been suspended for a number of months. How do I write a code that gives the suspension period preference over the eligibility? Example: Person is eligible from 1/6/2011, suspended from 1/10/2011 until 1/12/2011. The person resumed coverage for two more months and then terminated coverage. Each binary output should be allocated to a new column with the Month/Year heading. The output from 1/1/2011 for this example would look like: 0 0 0 0 0 1 1 1 1 0 0 0 1 1 0 0 0 0 0 ...etc Thanks in advance.
... View more