Dear all,

I am currently doing my thesis. As part of this, I would like to calculate the Herfindahl-Hirschman Index. I want to calculate the concentration of employment in a specific sector in a specific year. However I am wondering if somebody can give me some more information how to work with the HHI command function in Stata. My version of Stata is 14 on Mac.

I have 530 regions (Nuts 2 regions of Europe), 14 Industry sectors and the information from the years 1995 till 2017. See below a small example how my data set is organised. I already look at ''search hhi'' in Stata and read all the information in this Stata forum about this topic, however I am confused if my data structure is correct and how to use the HHI command correctly.
So far I have tried different commands, such as ''hhi Employment, by (Industry Year Region)'' however the results are only value 0 or 1...

Sorry I am new here and new with working with Stata, so I am a bit in panic how to get started with this function. Furthermore sorry if I forget to include certain important things, just let me know!

Year Region Industry Employment
2008 Groningen Mining and quarrying 674
2009 Groningen Mining and quarrying 633
2010 Groningen Mining and quarrying 626
2008 Groningen Manufacture of food products 3,727
2009 Groningen Manufacture of food products 3,713
2010 Groningen Manufacture of food products 3,643
2008 West-Nederland Mining and quarrying 3,668
2009 West-Nederland Mining and quarrying 4,065
2010 West-Nederland Mining and quarrying 3,870
2008 West-Nederland Manufacture of food products 44,232
2009 West-Nederland Manufacture of food products 44,646
2010 West-Nederland Manufacture of food products 45,947

I hope you get my problem and idea and if somebody can help me it would be great!
Thank you in advance.

Kind regards,
Lonneke