* Example generated by -dataex-. To install: ssc install dataex
clear
input float(id year paint)
1000789 2012 1
1000789 2013 1
1000789 2014 2
1000789 2015 2
1000789 2016 3
1000789 2017 2
1000790 2012 1
1000790 2013 1
1000790 2014 2
1000790 2015 3
1000790 2016 1
1000790 2017 2
1000790 2018 1
1000791 2012 1
1000791 2013 2
1000791 2014 1
1000791 2015 1
1000791 2016 3
1000791 2017 3
1000791 2018 2
end

1 7 14

1 2 3 7 8 9 14 15

1 2 3 4 5 7 8 9 10 14 15 16 17 18