I've following panel data of customers.
I wanna know how much percent U.S. firm's how much percent sale is depending on the top 5 customers (CID is the customer ID)
by top 5, I mean maximum sale to those customers.
Below is the example of my desire:
30% U.S. firm's 27% sale is recorded from 5 major customers in 1990, which increase to 45% U.S. firm's 53% sale from 5 major customers in 2019.
thanks and have a healthy life.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(gvkey year) double cid float hhi double salecs 1004 1980 1 .3044194 2 1004 1981 1 .2216893 4 1004 1982 1 .22132203 27 1004 1983 1 .18825316 27.1 1004 1984 1 .7959364 34 1004 1985 1 .5629511 32 1004 1986 1 .5554546 26 1004 1987 2 .7513977 38 1004 1988 2 .7005367 35 1004 1989 3 .3475164 34 1004 1990 3 .3931902 52 1004 1991 3 .7013901 55 1004 1992 3 .6846123 54 1004 1993 3 .7354638 57.6 1004 1994 3 .4148411 77.5 1004 1995 3 .6735231 82.708 1004 1996 3 .6656738 92.362 1004 1997 3 .8458421 82.125 1004 1998 3 .8718677 83.114 1004 1999 4 .7764435 98.954 1004 1999 5 .9458084 135.1 1004 2000 7 .292153 114 1004 2000 6 .7052862 132.048 1004 2001 7 .2684737 57.4 1004 2001 6 .3797065 139.072 1004 2002 6 .2444892 163.173 1004 2003 10 .4144233 44.163 1004 2003 9 .3419514 40.925 1004 2003 8 .2996047 85.103 1004 2004 10 .3958958 37.031 1004 2004 8 .3008272 125.059 1004 2004 9 .3280065 60.468 1004 2005 8 .25126612 69.027 1004 2005 10 .4465347 157.165 1004 2005 9 .18991083 25.976 1004 2006 9 .3857454 191.809 1004 2006 8 .2382316 77.34 1004 2006 10 .7558448 31.089 1004 2006 20 1 0 1004 2007 8 .3295779 75.185 1004 2007 9 .3095075 217.911 1004 2007 10 .3635168 32.184 1004 2007 20 .7207894 0 1004 2008 10 .3620423 33.66 1004 2008 17 .3306064 330.132 1004 2008 20 .8602294 0 1004 2008 9 .3297819 294.249 1004 2008 8 .4190194 99.752 1004 2008 12 .37110835 80.295 1004 2008 11 .3899278 10.84 1004 2009 17 .3700501 302.016 1004 2009 8 .302438 114.786 1004 2009 10 .3178273 36.453 1004 2009 12 .346539 72.533 1004 2009 20 .4951212 0 1004 2009 9 .3103042 381.811 1004 2010 10 .3089801 34.179 1004 2010 20 .8609121 0 1004 2010 9 .44605055 400.222 1004 2010 14 .4095208 162.575 1004 2010 8 .3062711 10.372 1004 2010 17 .5722177 289.435 1004 2010 12 .5298268 44.289 1004 2011 17 .595596 308.585 1004 2011 10 .3208062 31.538 1004 2011 12 .51130074 49.397 1004 2011 14 .30918 524.129 1004 2011 20 .9651234 0 1004 2011 8 .28320193 16.516 1004 2011 9 .4549262 320.883 1004 2012 8 .4061389 15.098 1004 2012 10 .5333644 29.482 1004 2012 12 .6463206 41.92 1004 2012 17 .6853637 435.663 1004 2012 9 .6211033 517.531 1004 2012 20 .49111605 0 1004 2012 14 .4891133 326.378 1004 2013 20 .5178183 0 1004 2013 17 .6799524 656.5 1004 2013 21 .6678154 0 1004 2013 18 .4741033 548.2 1004 2013 12 .732444 76 1004 2013 19 .9144028 215 1004 2014 25 .6971045 20.2 1004 2014 21 .6992729 0 1004 2014 24 .6004392 281.2 1004 2014 17 .7051401 668.4 1004 2014 22 .3416075 926.4 1004 2014 23 .8465701 112.3 1004 2014 19 .9306995 173.6 1004 2014 18 .4732691 521.3 1004 2014 20 .53704345 0 1004 2015 20 .55712986 0 1004 2015 18 .7537256 237.3 1004 2015 29 .8937673 3.6 1004 2015 26 .32458 255.8 1004 2015 23 .8705292 93.1 1004 2015 27 .3538898 18.8 1004 2015 22 .3656314 985.7 1004 2015 21 .7192508 0 1004 2015 17 .7612886 536.5 1004 2016 26 .3118351 212.7 1004 2016 18 .742613 301.1 1004 2016 27 .3493016 16.5 1004 2016 20 .6179501 0 1004 2016 22 .3805066 1003.5 1004 2016 17 .7793884 490.3 1004 2016 23 .7470369 120.4 1004 2016 21 .726178 0 1004 2016 29 .8883377 8.4 1004 2017 22 .5256608 1114.9 1004 2017 17 .7343547 618.8 1004 2017 20 .54828143 0 1004 2017 26 .3031172 194.6 1004 2017 29 .7725284 32.5 1004 2017 23 .714507 110.3 1004 2017 21 .5201592 0 1004 2017 18 .7941362 260.2 1004 2017 27 .3399229 55.1 1004 2018 17 .6915503 694 1004 2018 18 .8460797 224.4 1004 2018 23 .7059159 112.6 1004 2018 27 .50890666 37.5 1004 2018 26 .3176332 79.9 1004 2018 22 1 1281.9 1004 2018 30 0 0 1004 2018 29 .73093 12 1004 2019 34 .7838926 170.4 1004 2019 36 .7117568 5.8 1004 2019 26 .4858366 90.3 1004 2019 23 .65679 122.4 1004 2019 22 .9999999 1342.3 1004 2019 33 .7693424 323.4 1004 2019 30 0 0 1004 2019 27 .3317988 31.6 1004 2019 31 1 0 1004 2019 35 .8839494 124.1 1004 2019 37 .3846748 1.3 1004 2019 32 .7613607 1426.8 1004 2019 18 .7828421 455.9 1004 2019 29 1 9.3 1004 2019 17 .7409753 661.8 1004 2020 37 .4062415 .4 1004 2020 34 .9157683 127.8 1004 2020 23 .6784384 106.6 1004 2020 17 .7445327 591.8 1004 2020 32 1 1505.6 1004 2020 26 .513219 79.5 1004 2020 33 .9087732 330.8 1004 2020 22 1 1268.9 1004 2020 36 .8609388 9 1004 2020 29 1 4 1004 2020 35 .9454492 98.4 1004 2020 31 0 0 1004 2020 27 .3307272 24.3 1004 2020 30 0 0 1004 2020 18 .7492511 588.7 1005 1978 101 .08685375 4.1 1005 1979 101 .07650077 7.454 1005 1979 201 .2529117 2.377 1005 1979 202 .9096577 .102 1005 1979 1 .3682384 1.426 1005 1980 201 .26983187 2.292 1005 1980 202 .39635235 1.313 1005 1980 1 .347882 7.019 1005 1980 101 .06489923 9.563 1005 1981 101 .08115117 12.576 1005 1981 201 .3373217 3.035 1005 1981 202 .6407864 4.272 1005 1981 1 .2896195 9.386 1007 1981 201 .7999429 1.085 1007 1982 201 .1552976 1.299 1007 1983 201 .11791091 .44 1007 1984 201 .1010415 .35 1008 1984 101 .1188273 .206 1008 1986 101 .13401717 .127 1008 1986 102 .3856191 .12 1009 1981 102 .3182172 6.616 1009 1981 101 .08115117 7.498 1009 1981 103 .21479625 2.205 1009 1982 101 .07021145 4.321 1009 1982 102 .26041448 8.642 1009 1983 202 .7046618 2.25 1009 1983 201 .4863515 1.875 1009 1983 203 .6423896 2.625 1009 1983 204 .8348462 3.188 1009 1984 201 .3569533 2.732 1009 1984 203 .6628422 2.522 1009 1984 202 .3375723 2.943 1009 1984 204 .8312479 3.994 1009 1985 204 .9999999 2.051 1009 1985 202 .28653023 2.87 1009 1985 203 .5160522 3.896 1009 1985 201 .3777714 3.486 1009 1986 203 .7418107 3.468 1009 1986 202 .204518 2.505 1009 1986 201 .22818506 4.046 1009 1987 204 .9999999 2.933 1009 1987 203 .370198 3.128 1009 1987 201 .749088 4.106 end
0 Response to Yearly Sale Changes (in percentage)
Post a Comment