Dear Statalisters,

I am researching on corporate governance and need to calculate the board size for every company in every year.

I am unable to measure it.

Kindly advise.

Many thanks in advance.

Best wishes,

Avik


Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input long co_code str78 company_name str56 directors_name str10 corpdiro_date str78 committee_name str61 designation_full_name str13 exec_non_exec_category str12 prom_non_prom_category str15 indep_non_indep_category
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "K B KOTAK"               "31-03-2001" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "N J KOTAK"               "31-03-2001" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "K B KOTAK"               "31-03-2002" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "N J KOTAK"               "31-03-2002" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "K B KOTAK"               "31-03-2003" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "N J KOTAK"               "31-03-2003" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "K B KOTAK"               "31-03-2004" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "N J KOTAK"               "31-03-2004" "Board of directors" "Director"                        "NA"            "NA"           "NA"             
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2005" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2005" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2006" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2006" "Board of directors" "Chairperson & Director"          "Non-executive" "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2007" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2007" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2008" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2008" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2009" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2009" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2010" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2010" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2011" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2011" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2012" "Board of directors" "Chairperson & Director"          "Non-executive" "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "NARESH JAYANTILAL KOTAK" "31-03-2012" "Board of directors" "Chairperson & Director"          "Non-executive" "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "DHRUV KRISHNA KOTAK"     "31-03-2013" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2013" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "VIR KRISHNA KOTAK"       "31-03-2013" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "DHRUV KRISHNA KOTAK"     "31-03-2014" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2014" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "SANJEEV KANUBHAI PARIKH" "31-03-2014" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "VIR KRISHNA KOTAK"       "31-03-2014" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "DHRUV KRISHNA KOTAK"     "31-03-2015" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNA BHAGWAN KOTAK"   "31-03-2015" "Board of directors" "Chairperson & Director"          "Non-executive" "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "KRISHNAMURTHY NARAYANAN" "31-03-2015" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "SANJEEV KANUBHAI PARIKH" "31-03-2015" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
 3 "'K' STEAMSHIP AGENCIES PVT. LTD." "VIR KRISHNA KOTAK"       "31-03-2015" "Board of directors" "Director"                        "NA"            "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "BHANU B PATEL"           "31-03-2002" "Board of directors" "Chairperson Emeritus"            "Non-executive" "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "BHUPENDRA B PARIKH"      "31-03-2002" "Board of directors" "Vice Chairperson"                "Non-executive" "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2002" "Board of directors" "Chairperson & Managing Director" "Executive"     "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2002" "Board of directors" "Director"                        "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "DHIMANT B PARIKH"        "31-03-2002" "Board of directors" "Executive Director"              "Executive"     "Non-promoter" "Non-independent"
11 "20 MICRONS LTD."                  "DHRUVA S CHAUDHRI"       "31-03-2002" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "LALITA D SHARMA (MRS.)"  "31-03-2002" "Board of directors" "Director (IDBI)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2002" "Board of directors" "Executive Director"              "Executive"     "Non-promoter" "Non-independent"
11 "20 MICRONS LTD."                  "SANATKUMAR P DAVE"       "31-03-2002" "Board of directors" "Director"                        "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2002" "Board of directors" "Executive Director"              "Executive"     "Non-promoter" "Non-independent"
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2002" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2002" "Board of directors" "Director & Co. Secretary"        "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "BHANU B PATEL"           "31-03-2003" "Board of directors" "Chairperson Emeritus"            "Non-executive" "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "BHUPENDRA B PARIKH"      "31-03-2003" "Board of directors" "Vice Chairperson"                "Executive"     "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2003" "Board of directors" "Chairperson & Managing Director" "Executive"     "Promoter"     "Non-independent"
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2003" "Board of directors" "Director"                        "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "DHRUVA S CHAUDHRI"       "31-03-2003" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "LALITA D SHARMA (MRS.)"  "31-03-2003" "Board of directors" "Director (IDBI)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2003" "Board of directors" "Executive Director"              "Executive"     "Non-promoter" "Non-independent"
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2003" "Board of directors" "Executive Director"              "Executive"     "Non-promoter" "Non-independent"
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2003" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2003" "Board of directors" "Director & Co. Secretary"        "Non-executive" "NA"           "Independent"    
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2004" "Board of directors" "Chairperson & Managing Director" "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2004" "Board of directors" "Director"                        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "LALITA D SHARMA (MRS.)"  "31-03-2004" "Board of directors" "Director (IDBI)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2004" "Board of directors" "Executive Director"              "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2004" "Board of directors" "Executive Director"              "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2004" "Board of directors" "Director (GVFL)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2004" "Board of directors" "Director & Co. Secretary"        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "BHARAT KANANI"           "31-03-2005" "Board of directors" "Director (GVFL)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2005" "Board of directors" "Chairperson & Managing Director" "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2005" "Board of directors" "Director"                        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2005" "Board of directors" "Executive Director"              "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2005" "Board of directors" "Executive Director"              "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "VASANTHI MOHANRAM"       "31-03-2005" "Board of directors" "Director (IDBI)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2005" "Board of directors" "Director (GVFL)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2005" "Board of directors" "Director & Co. Secretary"        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "BHARAT KANANI"           "31-03-2006" "Board of directors" "Director (GVFL)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2006" "Board of directors" "Chairperson & Managing Director" "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "D D BHATTACHARJEE"       "31-03-2006" "Board of directors" "Director (IDBI)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2006" "Board of directors" "Director"                        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2006" "Board of directors" "Joint Managing Director"         "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2006" "Board of directors" "Director (Finance)"              "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2006" "Board of directors" "Director (GVFL)"                 "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2006" "Board of directors" "Director & Co. Secretary"        "Non-executive" "Non-promoter" "Independent"    
11 "20 MICRONS LTD."                  "BHARAT KANANI"           "31-03-2007" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2007" "Board of directors" "Chairperson & Managing Director" "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "D D BHATTACHARJEE"       "31-03-2007" "Board of directors" "Director (IDBI)"                 "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "DARSHANA MANKAD (MRS.)"  "31-03-2007" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "P M SHAH"                "31-03-2007" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2007" "Board of directors" "Joint Managing Director"         "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2007" "Board of directors" "Executive Director (Finance)"    "Executive"     "NA"           "Non-independent"
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2007" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "VITTHALDAS D TALATI"     "31-03-2007" "Board of directors" "Director & Co. Secretary"        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "BHARAT KANANI"           "31-03-2008" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "CHANDRESH PARIKH"        "31-03-2008" "Board of directors" "Chairperson & Managing Director" "Executive"     "NA"           "NA"             
11 "20 MICRONS LTD."                  "D D BHATTACHARJEE"       "31-03-2008" "Board of directors" "Director (IDBI)"                 "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "HARISH SHETH"            "31-03-2008" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "MIHIR JOSHI"             "31-03-2008" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "P M SHAH"                "31-03-2008" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "RAJESH PARIKH"           "31-03-2008" "Board of directors" "Joint Managing Director"         "Executive"     "NA"           "NA"             
11 "20 MICRONS LTD."                  "RAM DEVIDAYAL"           "31-03-2008" "Board of directors" "Director"                        "Non-executive" "NA"           "NA"             
11 "20 MICRONS LTD."                  "SUDHIR R PARIKH"         "31-03-2008" "Board of directors" "Executive Director"              "Executive"     "NA"           "NA"             
11 "20 MICRONS LTD."                  "VISHNU VARSHNEY"         "31-03-2008" "Board of directors" "Director (GVFL)"                 "Non-executive" "NA"           "NA"             
end