my data looks like this and I want to calculate how many times did each bank lead in the year

for example chase bank in 2000 lead 3 times and participants one time so the end table supposed to look like the second one

Code:
clear
input byte(Loan_ID Bank_ID) str15 Lender str4 Lender_Role int year
 1 60 "chase"           "Lead" 2000
 2 60 "chase"           "Lead" 2000
 3 60 "chase"           "Lead" 2001
 4 60 "chase"           "Part" 2001
 4 61 "bank of america" "Lead" 2001
 5 61 "bank of america" "Lead" 2002
 5 62 "amc"             "Part" 2002
 1 62 "amc"             "Lead" 2000
 3 67 "5fth"            "Part" 2001
 6 67 "5fth"            "Lead" 2010
 6 63 "ag"              "Part" 2010
 7 64 "rev"             "Lead" 2000
 7 69 "op"              "part" 2000
 9 64 "rev"             "part" 2009
10 62 "amc"             "lead" 2009
11 60 "chase"           "part" 2001
12 60 "chase"           "Lead" 2000
13 60 "chase"           "part" 2000
end


the table should look like this

Code:
clear
input byte(Loan_ID Bank_ID) str15 Lender str4 Lender_Role int year byte(numberofsharelead numberofsharepart)
 1 60 "chase"           "Lead" 2000 3 1
 2 60 "chase"           "Lead" 2000 3 1
 3 60 "chase"           "Lead" 2001 1 0
 4 60 "chase"           "Part" 2001 0 2
 4 61 "bank of america" "Lead" 2001 1 0
 5 61 "bank of america" "Lead" 2002 1 0
 5 62 "amc"             "Part" 2002 0 1
 1 62 "amc"             "Lead" 2000 1 0
 3 67 "5fth"            "Part" 2001 0 1
 6 67 "5fth"            "Lead" 2010 1 0
 6 63 "ag"              "Part" 2010 0 1
 7 64 "rev"             "Lead" 2000 1 0
 7 69 "op"              "part" 2000 0 1
 9 64 "rev"             "part" 2009 0 1
10 62 "amc"             "lead" 2009 1 0
11 60 "chase"           "part" 2001 0 2
12 60 "chase"           "Lead" 2000 3 1
13 60 "chase"           "part" 2000 3 1
end