Calculating Gini Coefficient

[Yue Zhao]

Hi Statalist,
Here I have a dataset comprising company name, year, host country, host country economic development level, their ID, YearID, and Dev (dummy coded country economic development level: 1 being developed/0 being developing).
Now I want to calculate whether each company's host country portfolio is concentrated in all developed economies or they are equally dispersed into both developed and developing countries.
I use the following command to calculate the Gini coefficient for each company.

ineqdeco Dev, by(YearID)

But it failed and Stata showed me that
"Subgroup summary statistics, for each subgroup k = 1,...,K:

too many values
r(134);"

Any suggestion is greatly appreciated. Thanks.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str47 Companyname int YEAR str26 COUNTRY str10 Development int ID long YearID float Dev
""                  . ""                  ""             .       . 0
"Gambro AB -Old" 2004 "Italy"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Italy"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Taiwan"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Canada"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Portugal"          "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "France"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Switzerland"       "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Netherlands"       "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "France"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "France"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Spain"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Italy"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Switzerland"       "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Italy"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Slovenia"          "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Denmark"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "China (Hong Kong)" "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Italy"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Mexico"            "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "Germany"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Brazil"            "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Germany"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Japan"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Japan"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Argentina"         "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Norway"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Belgium"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "United Kingdom"    "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Austria"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Netherlands"       "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Germany"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "United Kingdom"    "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Portugal"          "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Canada"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Japan"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Japan"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Hungary"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Japan"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Korea (South)"     "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "United Kingdom"    "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "United Kingdom"    "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "China"             "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "Germany"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Czech Republic"    "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Belgium"           "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Poland"            "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "Australia"         "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Australia"         "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "New Zealand"       "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Australia"         "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Mexico"            "Developing" 564 2004564 0
"Gambro AB -Old" 2004 "USA"               "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Sweden"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "France"            "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Spain"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Spain"             "Developed"  564 2004564 1
"Gambro AB -Old" 2004 "Finland"           "Developed"  564 2004564 1
"Lafarge SA"     2004 "Italy"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "Slovenia"          "Developed"  486 2004486 1
"Lafarge SA"     2004 "Austria"           "Developed"  486 2004486 1
"Lafarge SA"     2004 "Hungary"           "Developed"  486 2004486 1
"Lafarge SA"     2004 "Brazil"            "Developing" 486 2004486 0
"Lafarge SA"     2004 "France"            "Developed"  486 2004486 1
"Lafarge SA"     2004 "Australia"         "Developed"  486 2004486 1
"Lafarge SA"     2004 "Bahrain"           "Developing" 486 2004486 0
"Lafarge SA"     2004 "France"            "Developed"  486 2004486 1
"Lafarge SA"     2004 "Italy"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "Thailand"          "Developing" 486 2004486 0
"Lafarge SA"     2004 "Turkey"            "Developing" 486 2004486 0
"Lafarge SA"     2004 "Brazil"            "Developing" 486 2004486 0
"Lafarge SA"     2004 "Spain"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "France"            "Developed"  486 2004486 1
"Lafarge SA"     2004 "Spain"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "Venezuela"         "Developing" 486 2004486 0
"Lafarge SA"     2004 "Kenya"             "Developing" 486 2004486 0
"Lafarge SA"     2004 "Spain"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "Germany"           "Developed"  486 2004486 1
"Lafarge SA"     2004 "Switzerland"       "Developed"  486 2004486 1
"Lafarge SA"     2004 "Switzerland"       "Developed"  486 2004486 1
"Lafarge SA"     2004 "Switzerland"       "Developed"  486 2004486 1
"Lafarge SA"     2004 "Spain"             "Developed"  486 2004486 1
"Lafarge SA"     2004 "Portugal"          "Developed"  486 2004486 1
"Lafarge SA"     2004 "Switzerland"       "Developed"  486 2004486 1
end

[Phil Bromiley]

If the analysis is supposed to be at the country level, then why not collapse the data to the country level, run the gini and then merge it back?

"I use the following command to calculate the Gini coefficient for each company. ineqdeco Dev, by(YearID)" But this will try to do it by the YearID ignoring companies and countries. I don't know this routine (which is user written), but this seems different than what you are trying to do.