Hi everyone,

I have a dataset of governance data, listing each company's directors and whether they were present in the audit committee.

input int DataYear str49 CompanyName str6 AuditCommitteeMember str3 FinancialExpertise
2007 "AGILENT TECHNOLOGIES INC." "member" ""
2007 "AGILENT TECHNOLOGIES INC." "member" ""
2008 "AGILENT TECHNOLOGIES INC." "member" ""
2008 "AGILENT TECHNOLOGIES INC." "member" ""
2008 "AGILENT TECHNOLOGIES INC." "chair" "Yes"
2009 "AGILENT TECHNOLOGIES, INC." "member" ""
2009 "AGILENT TECHNOLOGIES, INC." "member" ""
2009 "AGILENT TECHNOLOGIES, INC." "chair" "Yes"
2010 "AGILENT TECHNOLOGIES, INC." "member" ""
2010 "AGILENT TECHNOLOGIES, INC." "chair" "Yes"
2011 "AGILENT TECHNOLOGIES, INC." "member" ""
2011 "AGILENT TECHNOLOGIES, INC." "member" ""
2011 "AGILENT TECHNOLOGIES, INC." "chair" "Yes"
2012 "AGILENT TECHNOLOGIES, INC." "Member" ""
2012 "AGILENT TECHNOLOGIES, INC." "Member" ""
2012 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2013 "AGILENT TECHNOLOGIES, INC." "Member" ""
2013 "AGILENT TECHNOLOGIES, INC." "Member" ""
2013 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2014 "AGILENT TECHNOLOGIES, INC." "Member" ""
2014 "AGILENT TECHNOLOGIES, INC." "Member" ""
2014 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2015 "AGILENT TECHNOLOGIES, INC." "Member" ""
2015 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2015 "AGILENT TECHNOLOGIES, INC." "Member" ""
2016 "AGILENT TECHNOLOGIES, INC." "Member" ""
2016 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2016 "AGILENT TECHNOLOGIES, INC." "Member" ""
2016 "AGILENT TECHNOLOGIES, INC." "Member" ""
2017 "AGILENT TECHNOLOGIES, INC." "Member" ""
2017 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2017 "AGILENT TECHNOLOGIES, INC." "Member" ""
2017 "AGILENT TECHNOLOGIES, INC." "Member" ""
2018 "AGILENT TECHNOLOGIES, INC." "Chair" "Yes"
2018 "AGILENT TECHNOLOGIES, INC." "Member" ""
2018 "AGILENT TECHNOLOGIES, INC." "Member" ""
2018 "AGILENT TECHNOLOGIES, INC." "Member" ""
2007 "ALCOA INC." "member" ""
2007 "ALCOA INC." "chair" ""
2007 "ALCOA INC." "member" ""
2007 "ALCOA INC." "member" ""
2007 "ALCOA INC." "member" ""
2008 "ALCOA INC." "member" ""
2008 "ALCOA INC." "chair" "Yes"
2008 "ALCOA INC." "member" ""
2008 "ALCOA INC." "member" ""
2008 "ALCOA INC." "member" ""
2008 "ALCOA INC." "member" ""
2009 "ALCOA INC." "member" "Yes"
2009 "ALCOA INC." "chair" "Yes"
2009 "ALCOA INC." "member" ""
2009 "ALCOA INC." "member" "Yes"
2009 "ALCOA INC." "member" "Yes"
2009 "ALCOA INC." "member" "Yes"
2010 "ALCOA INC." "member" "Yes"
2010 "ALCOA INC." "member" ""
2010 "ALCOA INC." "member" "Yes"
2010 "ALCOA INC." "member" "Yes"
2010 "ALCOA INC." "member" "Yes"
2011 "ALCOA INC." "member" "Yes"
end

I need to count the number of both members and chair for each firm, every year. I don't need the separate figures for members and chairs, I just require the counted numbers of them combined. Can anyone help me with the coding for this?