tab year, gen(y)
forv i=1/3 {
egen yr`i'=sum(y`i'), by(id)
}
* 08 and 04 and 06
count if year=="08" & y1>0 & y2>0
* 08 and 06 only
count if year=="08" & y2>0 & y1==0
* 08 only
count if year=="08" & y2==0 & y1==0
sort id year
egen n=count(1), by(id)
*04, 06, 08
count if year=="08" & n==3
* 06 and 08
count if year=="08" & n==2 & year[_n-1]=="06"
* 08
count if year=="08" & n==1