Good morning. I am working with panel data from NBER's CPS that I've boiled down to 56,166 observations; however, whenever I try to tell Stata it's panel data (using "xtreg county year, yearly"), I receive an error code:
repeated time values within panel
r(451);
If I remove the "year" variable from the code, it will run, but I feel it's providing an inaccurate model. To provide a little more insight into my data, I am trying to pull the effects of my "treatment" (SancC) on wages. I have attached a sample from my data below, but please note it is sorted by year, so this data runs from 2010-2019 and covers counties in 10 different states.
Thanks so much in advance!
Josh
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int year long serial double cpsid byte statefip long county byte statecensus long metfips double cpsidp byte(age sex) int(race hispan) long incwage float(SancC hispanic) 2014 34290 20130304865700 37 37057 56 99998 20130304865702 40 1 100 0 90000 0 0 2014 34290 20130304865700 37 37057 56 99998 20130304865701 41 2 100 0 22000 0 0 2014 34292 20130104877900 37 37057 56 99998 20130104877902 63 2 100 0 8000 0 0 2014 34293 20131204927000 37 37057 56 99998 20131204927003 43 1 100 0 57000 0 0 2014 34298 20130104909200 37 37057 56 99998 20130104909202 45 2 100 0 10000 0 0 2014 34298 20130104909200 37 37057 56 99998 20130104909201 48 1 300 0 37000 0 0 2014 34299 0 37 37057 56 99998 0 18 1 100 0 600 0 0 2014 34299 0 37 37057 56 99998 0 54 2 100 0 57000 0 0 2014 34299 0 37 37057 56 99998 0 56 1 100 0 52000 0 0 2014 34300 0 37 37057 56 99998 0 45 2 100 0 15000 0 0 2014 34306 20140304906700 37 37155 56 99998 20140304906702 45 2 300 0 15000 0 0 2014 34307 20140304897300 37 37155 56 99998 20140304897301 33 1 300 0 73000 0 0 2014 34310 20140304928300 37 37155 56 99998 20140304928301 33 2 300 0 55000 0 0 2014 34311 20140304908200 37 37155 56 99998 20140304908202 45 2 300 0 33000 0 0 2014 34312 20140204914400 37 37155 56 99998 20140204914401 33 2 300 0 31000 0 0 2014 34313 20130104911200 37 37155 56 99998 20130104911201 65 1 100 0 34000 0 0 2014 34322 20131204928800 37 37155 56 99998 20131204928802 47 2 100 0 20000 0 0 2014 34322 20131204928800 37 37155 56 99998 20131204928801 46 1 100 0 28000 0 0 2014 34323 20130104903800 37 37155 56 99998 20130104903801 65 2 100 0 48000 0 0 2014 34324 20140104912700 37 37155 56 99998 20140104912701 44 1 100 0 50000 0 0 2014 34324 20140104912700 37 37155 56 99998 20140104912702 45 2 100 0 20000 0 0 2014 34324 20140104912700 37 37155 56 99998 20140104912704 18 1 100 0 18200 0 0 2014 34325 20130204907200 37 37155 56 99998 20130204907202 41 1 801 0 50000 0 0 2014 34325 20130204907200 37 37155 56 99998 20130204907203 19 1 801 0 7200 0 0 2014 34325 20130204907200 37 37155 56 99998 20130204907201 47 2 801 0 37000 0 0 2014 34335 0 37 37155 56 99998 0 74 2 200 0 42349 0 0 2014 34336 0 37 37155 56 99998 0 28 2 200 0 30000 0 0 2014 34337 0 37 37155 56 99998 0 46 2 300 0 34000 0 0 2014 34337 0 37 37155 56 99998 0 20 1 300 0 14400 0 0 2014 34338 0 37 37155 56 99998 0 46 2 100 0 21000 0 0 2014 34435 20140204908400 37 37097 56 99998 20140204908402 58 1 100 0 3200 0 0 2014 34436 20140204925300 37 37097 56 99998 20140204925302 66 2 100 0 2600 0 0 2014 34438 20130104872300 37 37097 56 99998 20130104872302 36 2 100 0 22000 0 0 2014 34438 20130104872300 37 37097 56 99998 20130104872301 44 2 100 0 53500 0 0 2014 34440 20140304874100 37 37097 56 99998 20140304874101 53 1 200 0 24000 0 0 2014 34440 20140304874100 37 37097 56 99998 20140304874102 48 2 200 0 17000 0 0 2014 34443 20131204925900 37 37097 56 99998 20131204925901 64 2 100 0 6000 0 0 2014 34443 20131204925900 37 37097 56 99998 20131204925902 64 1 100 0 15000 0 0 2014 34446 20140104916300 37 37097 56 99998 20140104916301 37 2 100 0 6000 0 0 2014 34446 20140104916300 37 37097 56 99998 20140104916306 47 1 100 0 50000 0 0 2014 34451 20121204908000 37 37097 56 99998 20121204908009 21 1 100 100 17080 0 1 2014 34451 20121204908000 37 37097 56 99998 20121204908001 29 1 100 100 20800 0 1 2014 34453 20140304898000 37 37097 56 99998 20140304898002 19 1 100 0 22000 0 0 2014 34453 20140304898000 37 37097 56 99998 20140304898003 19 1 100 0 22000 0 0 2014 34453 20140304898000 37 37097 56 99998 20140304898001 20 1 100 0 1500 0 0 2014 34453 20140304898000 37 37097 56 99998 20140304898004 20 1 100 0 22000 0 0 2014 34455 20130104886200 37 37097 56 99998 20130104886201 54 1 100 0 21000 0 0 2014 34455 20130104886200 37 37097 56 99998 20130104886202 43 2 100 0 6000 0 0 2014 34456 20140104912800 37 37097 56 99998 20140104912801 28 2 100 0 11027 0 0 2014 34458 20130104878800 37 37097 56 99998 20130104878801 35 1 100 0 25000 0 0 2014 34464 0 37 37097 56 99998 0 37 2 100 200 47000 0 1 2014 34467 0 37 37097 56 99998 0 53 2 200 0 10000 0 0 2014 34468 0 37 37097 56 99998 0 41 1 100 0 25000 0 0 2014 34637 20140104815900 37 37119 56 16740 20140104815901 36 1 200 0 22000 0 0 2014 34642 20130104804500 37 37119 56 16740 20130104804503 57 1 100 500 19000 0 1 2014 34642 20130104804500 37 37119 56 16740 20130104804501 35 1 100 500 16000 0 1 2014 34642 20130104804500 37 37119 56 16740 20130104804502 56 2 100 500 17000 0 1 2014 34643 20130104794800 37 37119 56 16740 20130104794801 45 1 200 0 84500 0 0 2014 34643 20130104794800 37 37119 56 16740 20130104794802 45 2 200 0 45000 0 0 2014 34644 2.01302048e+13 37 37119 56 16740 20130204800002 40 2 651 0 77000 0 0 2014 34645 20130204790700 37 37119 56 16740 20130204790701 53 1 651 0 55000 0 0 2014 34647 20130104810200 37 37119 56 16740 20130104810202 54 1 100 412 26000 0 1 2014 34648 20130204801200 37 37119 56 16740 20130204801203 21 2 200 0 9500 0 0 2014 34649 20130204798500 37 37119 56 16740 20130204798501 29 1 100 0 71000 0 0 2014 34650 20130204802600 37 37119 56 16740 20130204802604 25 1 100 0 16001 0 0 2014 34650 20130204802600 37 37119 56 16740 20130204802602 21 1 300 0 15249 0 0 2014 34650 20130204802600 37 37119 56 16740 20130204802603 50 1 100 0 62000 0 0 2014 34650 20130204802600 37 37119 56 16740 20130204802601 45 2 100 0 926 0 0 2014 34651 20130104788400 37 37119 56 16740 20130104788401 38 2 100 0 70000 0 0 2014 34653 20140204828000 37 37119 56 16740 20140204828002 31 2 100 0 16500 0 0 2014 34653 20140204828000 37 37119 56 16740 20140204828001 30 1 100 0 60000 0 0 2014 34654 20131204810600 37 37119 56 16740 20131204810601 32 2 100 0 32000 0 0 2014 34655 20131204831000 37 37119 56 16740 20131204831003 25 2 100 0 37800 0 0 2014 34655 20131204831000 37 37119 56 16740 20131204831001 27 1 100 0 15000 0 0 2014 34656 20140104809000 37 37119 56 16740 20140104809001 54 2 200 0 38000 0 0 2014 34657 20140104812700 37 37119 56 16740 20140104812702 49 1 200 0 55000 0 0 2014 34657 20140104812700 37 37119 56 16740 20140104812701 40 2 200 0 28000 0 0 2014 34658 20121204787300 37 37119 56 16740 20121204787301 24 1 100 0 17000 0 0 2014 34659 20140304799300 37 37119 56 16740 20140304799301 66 1 100 0 15000 0 0 2014 34660 20140304798100 37 37119 56 16740 20140304798101 60 1 100 0 51000 0 0 2014 34660 20140304798100 37 37119 56 16740 20140304798102 59 2 100 0 51000 0 0 2014 34660 20140304798100 37 37119 56 16740 20140304798103 20 2 100 0 1900 0 0 2014 34664 20140104845000 37 37119 56 16740 20140104845001 27 2 100 100 40000 0 1 2014 34664 20140104845000 37 37119 56 16740 20140104845002 24 1 100 100 45000 0 1 2014 34667 20140204840500 37 37119 56 16740 20140204840502 62 1 100 0 62824 0 0 2014 34667 20140204840500 37 37119 56 16740 20140204840501 66 2 100 0 19106 0 0 2014 34668 20130104800100 37 37119 56 16740 20130104800101 40 2 100 0 6000 0 0 2014 34672 20140304822200 37 37119 56 16740 20140304822201 38 1 100 0 202000 0 0 2014 34672 20140304822200 37 37119 56 16740 20140304822202 39 2 100 0 4000 0 0 2014 34673 20140304813200 37 37119 56 16740 20140304813204 25 1 100 0 24000 0 0 2014 34673 20140304813200 37 37119 56 16740 20140304813203 22 2 100 0 9880 0 0 2014 34675 20140304809200 37 37119 56 16740 20140304809201 36 1 100 0 115000 0 0 2014 34676 20130104812200 37 37119 56 16740 20130104812203 19 1 200 0 2000 0 0 2014 34676 20130104812200 37 37119 56 16740 20130104812202 52 2 200 0 34600 0 0 2014 34677 20130104816700 37 37119 56 16740 20130104816705 33 2 200 0 7000 0 0 2014 34679 20130204812300 37 37119 56 16740 20130204812301 40 2 200 0 37000 0 0 2014 34680 20130204815600 37 37119 56 16740 20130204815602 16 1 200 0 400 0 0 2014 34680 20130204815600 37 37119 56 16740 20130204815601 48 2 200 0 30000 0 0 2014 34683 20131204820700 37 37119 56 16740 20131204820701 47 2 200 0 12000 0 0 2014 34684 20140204808300 37 37119 56 16740 20140204808302 55 2 100 0 25000 0 0 end label values statefip STATEFIP label def STATEFIP 37 "north carolina", modify label values statecensus STATECENSUS label def STATECENSUS 56 "north carolina", modify label values age AGE label def AGE 16 "16", modify label def AGE 18 "18", modify label def AGE 19 "19", modify label def AGE 20 "20", modify label def AGE 21 "21", modify label def AGE 22 "22", modify label def AGE 24 "24", modify label def AGE 25 "25", modify label def AGE 27 "27", modify label def AGE 28 "28", modify label def AGE 29 "29", modify label def AGE 30 "30", modify label def AGE 31 "31", modify label def AGE 32 "32", modify label def AGE 33 "33", modify label def AGE 35 "35", modify label def AGE 36 "36", modify label def AGE 37 "37", modify label def AGE 38 "38", modify label def AGE 39 "39", modify label def AGE 40 "40", modify label def AGE 41 "41", modify label def AGE 43 "43", modify label def AGE 44 "44", modify label def AGE 45 "45", modify label def AGE 46 "46", modify label def AGE 47 "47", modify label def AGE 48 "48", modify label def AGE 49 "49", modify label def AGE 50 "50", modify label def AGE 52 "52", modify label def AGE 53 "53", modify label def AGE 54 "54", modify label def AGE 55 "55", modify label def AGE 56 "56", modify label def AGE 57 "57", modify label def AGE 58 "58", modify label def AGE 59 "59", modify label def AGE 60 "60", modify label def AGE 62 "62", modify label def AGE 63 "63", modify label def AGE 64 "64", modify label def AGE 65 "65", modify label def AGE 66 "66", modify label def AGE 74 "74", modify label values sex SEX label def SEX 1 "male", modify label def SEX 2 "female", modify label values race RACE label def RACE 100 "white", modify label def RACE 200 "black/negro", modify label def RACE 300 "american indian/aleut/eskimo", modify label def RACE 651 "asian only", modify label def RACE 801 "white-black", modify label values hispan HISPAN label def HISPAN 0 "not hispanic", modify label def HISPAN 100 "mexican", modify label def HISPAN 200 "puerto rican", modify label def HISPAN 412 "south american", modify label def HISPAN 500 "salvadoran", modify
0 Response to Error Code: Repeaded Time Values Within Panel
Post a Comment