count name of company

[sasphd]

hello 

data have;
input secid $ NAME $ management_company $;
datalines;
1 Afund Sales
1 Afund xyz
2 Bfund Mary Acctng
2 bfund Sales
;

want 

Sales  2

xyz     1

Mary Acctng 1 

but I obtain this 

this is the program that I use 

proc sql;
create table want as
select distinct management_company, count(management_company) as count_name
from have;

quit;

[yabwon · Accepted solution]

"Group by management_company"

B.