Dear all, I am new to SAS but I have some programming experience. I would like some help finding the longest consecutive coverage for A and B. As an alternative method I used to include only rows that have yes in all months which made me miss some entries. Appreciate your help. ID year 1 2 3 4 5 6 7 8 9 10 11 12 A 2010 No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes A 2011 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No A 2012 No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes A 2013 Yes Yes No No No No No No No No No No B 2011 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes B 2012 Yes Yes Yes No No No No No No No No No
... View more