Dear Statalist,

I have a dataset that consists of observations of people who are/were part of the board of directors of a company. The dataset consists of several characteristics combined with the start- and end date of their respective position on the board.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(StartDate EndDate) str1 Gender float Age str24 CountryofNationality
18263 21915 "M" 64 "Belgium"           
15866 21915 "M" 82 "United States"     
19458 21915 "M" 72 "Portugal"          
15756 21915 "M" 81 "Philippines"       
15341 18737 "M" 77 "United Kingdom"    
13880 20453 "M" 94 "Belgium"
The thing that I have been trying to achieve is to expand and tabulate board characteristics based on full years. I've searched around the forum and found some commands that I could use such as 'expand' to expand my dataset, but unfortunately, I haven't had any success yet.

As an example, for Country of Nationality I would like to achieve something as follows (If a board member has been a director from 2010-2015, his/her nationality will count as 1 for those respective years):
Country of Nationality 2010 2011 2012 2013 2014 2015 2016
Belgium 2 2 2 2 1 1 1
United States 1 1 1 1 1 1 1
Portugal 0 0 0 1 1 1 1
Total 3 3 3 4 3 3 3
Hopefully, my question is clear.
Any advice or suggestions would be most appreciated.

Thank you in advance.
Roel Verkuijlen