Import Dataset
RENT.merge<-read_xlsx("MSA-RENT merge All.xlsx")
RENT.merge$treat<-ifelse(RENT.merge$state=="LA",1,0)
## Cleaning Dataset
colnames(RENT.merge)
## [1] "FirstNAME" "AREANAME" "RENT_0"
## [4] "RENT_1" "RENT_2" "RENT_3"
## [7] "RENT_4" "YEAR" "NAME.x"
## [10] "state" "Unemployee.Rate" "Personal.Income"
## [13] "Resident.Population" "nyear" "MSA"
## [16] "MSA.Code" "Price" "Change"
## [19] "NAME.y" "treat"
# Remove NA
RENT.merge<-RENT.merge%>%
group_by(MSA)%>%
filter(!any(is.na(Unemployee.Rate)))
# ADD STATE NUM
statepop<-usmap::statepop[,1:2]
statepop$fips<-as.numeric(statepop$fips)
RENT.merge<-left_join(RENT.merge,statepop,by=c("state"="abbr"))
RENT.merge<-data.frame(RENT.merge)
Ballace Dataset
MSA<-RENT.merge%>%
group_by(MSA.Code)%>%
mutate(nyear=n())%>%
filter(nyear==15)
MSA<-data.frame(MSA)
## NEW ORLEAN AS SAMPLE
LAst<-MSA%>%filter(state=="LA")
tst<-unique(LAst$MSA.Code)
stc<-unique(MSA $MSA.Code)
stc<-stc[!stc %in% tst] #exclude LA MSA from control unit
Multiple Treated MSA RENT0
## Multiple Unit treated (LA MSA)
Mu.RENT<-multiple.synth(
foo = RENT.merge,
predictors = c("Unemployee.Rate","Personal.Income","Resident.Population"),
predictors.op = "mean",
dependent = "RENT_0",
unit.variable = "MSA.Code", # UNIQ CODE (ID)
time.variable = "YEAR",
treatment.time = 2005,
treated.units = tst,
control.units = stc, #NOTE I Sampling because its took lot of time
time.predictors.prior = c(2001:2005),
time.optimize.ssr = c(2001:2010),
unit.names.variable = "MSA",
time.plot = 2001:2010,
special.predictors = list(
list("RENT_0", 2005, "mean")
)
)
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 835.9732
##
## solution.v:
## 0.05262183 0.003958093 0.02108344 0.9223366
##
## solution.w:
## 0.003838786 0.00178017 0.001509606 0.001663219 0.006134377 0.002903124 0.001756125 0.001227224 0.005763445 0.001872964 0.002160922 0.000208729 0.000465456 0.0015362 0.0005016169 0.002527189 0.004806622 0.002672374 0.001433037 0.006357886 0.002031696 0.001799785 0.001224386 0.002130615 0.002719324 0.007797303 0.003981634 0.00343486 0.002711569 0.003158863 0.008060742 0.0001814872 0.002592094 0.001538005 0.004777673 0.001410273 0.001129628 0.001589235 0.008256926 0.0003322787 0.005112187 0.007741685 0.0005199289 0.002204846 0.0004219332 0.004195913 0.001881495 0.007470376 0.004883421 0.001889407 0.02008677 0.001595624 0.003454245 0.002634692 0.001777332 0.001871925 0.004808082 0.00425788 0.002482174 0.001459089 0.006046986 0.001664021 0.004076633 0.006525564 0.004082895 0.006882589 1.1299e-06 0.003062022 0.00380559 0.002794756 0.002728864 0.0004071897 0.002756716 0.001081463 0.004846685 0.002354232 0.001846713 0.004698059 0.001011716 0.004182781 0.004445903 0.002731192 2.4893e-06 5.0957e-06 0.006199365 0.002319578 0.001974476 0.007671302 0.002205992 1.0668e-06 0.001227992 0.002903804 0.005292427 0.002700803 0.007466993 0.003280641 0.00321287 0.00293648 0.00272552 0.001896415 0.3204221 0.003840417 0.002178592 0.0002888511 0.001097713 0.005127897 0.001684323 0.001242364 0.002342465 0.005021994 0.001178203 0.001609406 0.0009531403 3.7927e-06 0.001468773 0.004899531 0.001489456 0.00297788 0.0004408338 0.006362101 0.002996948 0.001711808 0.002958838 0.000530079 0.005314934 0.0008023311 0.006242884 0.0007451873 0.002672211 0.002941886 0.004539 0.005153078 0.002518285 0.00417726 0.001868941 0.0007221556 0.002859499 0.003620984 0.001204055 0.003045145 0.00622118 0.0004759527 0.00379959 0.001989331 0.000367084 0.004002443 0.001512942 0.006901099 0.1385975 0.002469911 0.002581088 0.004736264 0.002715154 0.001958879 0.001382592 0.003019288 0.001214482 0.00181209 0.004415643 0.002020548 0.003598612 0.001128409 0.001394672 0.001588276 0.00292235 0.004225642 0.002134472 0.006264031 0.001445077 0.006143402 0.002272471 0.004625205 0.006580667 0.002185182 0.003124719 0.002656053 0.002237361 0.007139804 0.006101754
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 7799.94
##
## solution.v:
## 8.33358e-05 0.4617556 0.5381611 1e-10
##
## solution.w:
## 0.005411742 0.004271537 0.005477677 0.004946637 0.005068298 0.005211568 0.002791103 0.003481313 0.005426582 0.005062955 0.005539773 0.004363497 0.004424343 0.004408454 0.003643543 0.00482415 0.005073346 0.005167759 0.004437538 0.004896915 0.005508444 0.004753657 0.002622572 0.003713593 0.004736323 0.004032478 0.004453247 0.004858968 0.004942487 0.003912758 0.004144447 0.004118695 0.004889798 0.004261255 0.004984368 0.00475645 0.004461246 0.004929832 0.004402194 0.00447414 0.005244242 0.004019875 0.003307022 0.004115357 0.003888001 0.005274633 0.00498467 0.005114963 0.004909432 0.00500007 0.005141205 0.004167817 0.004975382 0.004613974 0.005138238 0.004597423 0.004635605 0.005241469 0.004686986 0.003250321 0.005441999 0.005481493 0.005225251 0.005280854 0.004987844 0.00513935 0.005329171 0.004366894 0.00502479 0.005045264 0.00563395 0.004294185 0.004653211 0.004252347 0.004532068 0.004958037 0.004993496 0.005337265 0.004502373 0.004883158 0.004694976 0.005004902 0.005575403 0.005451851 0.004837437 0.005057769 0.005130425 0.004570499 0.004564783 0.07570162 0.005392014 0.005302239 0.005472319 0.004468791 0.005038178 0.004512733 0.005062187 0.005465583 0.005267648 0.003786901 0.004926651 0.004510699 0.003815798 0.004755662 0.003662911 0.005274428 0.005426464 0.004093563 0.004865469 0.005203266 0.005200391 0.01858277 0.004300035 0.01233666 0.005598047 0.005490888 0.004834304 0.003843435 0.005295103 0.005126044 0.00493078 0.005282315 0.004645061 0.005146105 0.005150655 0.004351114 0.005631868 0.004926052 0.005128064 0.005167416 0.003942681 0.004720688 0.004311497 0.004454424 0.00314585 0.003959206 0.004685439 0.004159669 0.004542105 0.004473633 0.004602254 0.004040776 0.005008225 0.005058844 0.002759669 0.0039238 0.004787031 0.004364134 0.005239286 0.004759542 0.004720413 0.004284544 0.005221292 0.005087901 0.004159272 0.005009829 0.004785235 0.005067226 0.005288907 0.004397367 0.004679135 0.002308008 0.005160214 0.004806633 0.005449091 0.004496145 0.005306511 0.004721099 0.005439233 0.004686251 0.004394605 0.004934908 0.005118134 0.004659571 0.004562545 0.00438297 0.004785849 0.003610861 0.06912186
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 1527.098
##
## solution.v:
## 0.2824866 0.2957467 0.1494233 0.2723434
##
## solution.w:
## 0.003228057 0.001520654 0.002606933 0.001802221 0.002178129 0.002919987 0.001024951 0.001166765 0.002495555 0.002287274 0.004081315 0.0005015857 0.001217729 0.001368447 0.0007499043 0.001815209 0.003059971 0.002482674 0.00145873 0.003074159 0.003877965 0.001972425 0.0008312761 0.001300039 0.001773278 0.001952595 0.00204246 0.002524383 0.002107005 0.001727965 0.002016569 0.000286556 0.001725502 0.001545152 0.002854443 0.001708084 0.001213412 0.001897982 0.001958477 0.0005230825 0.002058195 0.001590373 0.0007470297 0.001715181 0.0006115713 0.00204096 0.001152069 0.002761703 0.002410827 0.002372908 6.2015e-06 0.001673453 0.001884328 0.001704998 0.002039132 0.00158947 0.001519317 0.001786091 0.001979688 0.001167593 0.001853497 0.008360492 0.00307403 0.001984295 0.002465675 0.002337612 0.002369632 0.001901767 0.00201354 0.002502164 0.005693143 0.0005803683 0.002079846 0.001199005 0.00256595 0.001649847 0.002042459 0.002439779 0.001401176 0.002033663 0.002001288 0.001528067 4.3541e-06 0.001563128 0.001734493 0.002159449 0.001997932 0.001828921 0.001993492 0.08147688 0.002076259 0.1944591 0.004205805 0.001885946 0.001976705 0.002247727 0.002183542 0.003147359 0.002835456 0.001505193 0.001492492 0.001693595 0.0009829311 0.0005192151 0.001075972 0.003570386 0.002346763 0.001257587 0.002131327 0.002223756 0.002000702 0.0007152059 0.001247553 6.6449e-06 0.003840316 0.002248762 0.001524792 0.001468151 0.00117508 0.001828085 0.002578116 0.002670448 0.001905169 0.0008037984 0.0008007642 0.0009882704 0.3479259 2.02883e-05 0.001694727 0.002972225 0.001613102 0.002798023 0.001747238 0.001630898 0.001141267 0.001136474 0.002283703 0.001934359 0.001466173 0.001676025 0.001528526 0.000888003 0.002686628 0.001874124 0.0007432076 0.001685324 0.00212861 0.002087801 0.0447699 0.002091472 0.001651607 0.001916588 0.001953645 0.001793913 0.001336397 0.0008246659 0.001746647 0.002745353 0.001826671 0.001531357 0.002107402 0.0007506238 0.001806801 0.00169943 0.003252509 0.001980218 0.002636872 0.002252598 0.002722401 0.002309674 0.001633708 0.002404305 0.002082212 0.001936213 0.001347557 0.00186983 0.001572772 0.001149386 0.0004897622
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 1672.01
##
## solution.v:
## 0.5145619 0.1860846 0.09180134 0.2075522
##
## solution.w:
## 0.00463618 0.002417103 0.004182338 0.002626798 0.004437224 0.004017225 0.00200321 0.002109385 0.004889691 0.003121863 0.004834355 0.0008453089 0.001777411 0.002381259 0.001216283 0.003521647 0.004453601 0.003760344 0.002220669 0.00499424 0.004554648 0.002795165 0.001833741 0.002544593 0.003114988 0.007501702 0.003446354 0.003860628 0.00341067 0.00319196 0.004501712 0.0005596778 0.0033862 0.00235225 0.004237231 0.002433491 0.001914067 0.002748574 0.006878747 0.0008940459 0.004397873 0.0036911 0.001221849 0.002659983 0.001025762 0.003241088 0.005546913 0.004729941 0.00424519 0.003797292 0.007254372 0.002774796 0.003568486 0.003061312 0.003033967 0.002657671 0.003672859 0.004507932 0.003087346 0.002105247 0.004905154 0.004123388 0.005175636 0.004769939 0.004828557 0.003952953 1.7503e-06 0.003158577 0.004077321 0.003767062 0.003095251 0.0009881821 0.003217105 0.001855971 0.004183064 0.003622641 0.002909001 0.005350582 0.001984398 0.004032133 0.003915598 0.004055366 0.005958972 3.8943e-06 0.004553885 0.003307288 0.002902827 0.004382744 0.00292403 0.001006554 0.003706954 0.008547505 0.003122095 0.003007973 0.004722229 0.003426202 0.003886423 0.003728586 0.003995179 0.002382683 0.004097184 0.003447545 0.002708852 0.0008947604 0.001734932 0.006463634 0.003160227 0.002080877 0.003211334 0.004868246 0.003017865 0.001667347 0.001834453 0.0001358997 0.00350053 0.004136829 0.002339262 0.002833187 0.001523551 0.004321274 0.004404941 0.003193167 0.003192331 0.00127282 0.00491499 0.001562656 0.3013912 0.002327049 0.003998777 0.004731107 0.003187595 0.00485556 0.002868634 0.003477234 0.002099583 0.001658603 0.00342277 0.003480399 0.002126139 0.003103266 0.003879606 0.001328362 0.004212549 0.003053344 0.001305376 0.003636274 0.002949303 0.003971162 0.1118039 0.003232331 0.003037105 0.003456481 0.003063409 0.005260104 0.00216897 0.004375651 0.002354725 0.003378037 0.004266155 0.00257806 0.003592669 0.001626928 0.002496956 0.002496296 0.004391921 0.003628868 0.003575863 0.004510874 0.003443404 0.004172112 0.002714023 0.004288738 0.004580997 0.003057691 0.003295795 0.002978994 0.002855085 0.003293403 0.002018638
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 108.4441
##
## solution.v:
## 0.6242332 0.1256011 0.1324033 0.1177624
##
## solution.w:
## 0.003229516 0.001645856 0.001945706 0.001560746 0.004645103 0.00224212 0.001246201 0.0009449635 0.005532261 0.001703146 0.001912216 0.0004538567 0.0008231572 0.001906747 0.0007003701 0.001742115 0.003090833 0.002210135 0.001318059 0.003252333 0.001888179 0.001571231 0.0008990237 0.001340753 0.002425283 0.0103192 0.002569757 0.002210252 0.00225035 0.001373996 0.004221824 0.0002901573 0.002226599 0.001449703 0.003093447 0.001467352 0.001119093 0.001659328 0.003594161 0.0004694504 0.004477084 0.00576998 0.0007561966 0.001537472 0.0005995201 0.006313079 0.0007244135 0.006244748 0.003014295 0.001348556 0.1787788 0.001232816 0.003064891 0.002279641 0.001864196 0.001930284 0.003604617 0.003542872 0.001987119 0.001869946 0.005714828 0.001447779 0.002176781 0.005750215 0.00173049 0.01065923 0.001086353 0.002022127 0.002592839 0.002096706 0.003279528 0.0005244589 0.00204139 0.001049798 0.002172699 0.001821412 0.001720012 0.002780333 0.001030141 0.002536919 0.002445718 0.004554315 0.001660173 9.8052e-06 0.002242535 0.002071318 0.001736368 0.003358318 0.001652863 0.08511463 0.001706434 0.0007392156 0.005276358 0.002031191 0.004947151 0.002000707 0.002443303 0.002808238 0.002227197 0.001294814 0.004712175 0.0024538 0.002617573 0.0003990859 0.001107816 0.002107494 0.001826442 0.001637714 0.001929076 0.002990346 0.001532578 0.0009504349 0.0009968172 5.86607e-05 0.001600991 0.005311261 0.001310471 0.001690427 0.0007218107 0.00691531 0.001529228 0.001564247 0.00236817 0.0006044799 0.1542647 0.0008907198 0.1640583 0.0009300245 0.002190837 0.001713023 0.002469853 0.002122189 0.001895341 0.002501855 0.001202778 0.0008874551 0.001926934 0.001617292 0.001241734 0.002491526 0.003940931 0.0007851767 0.002414684 0.002054521 0.0008405925 0.001460524 0.001308306 0.003875657 1.9564e-06 0.001918679 0.002449096 0.002918878 0.002649711 0.0009488503 0.001656997 0.005763465 0.001320613 0.001447976 0.004087998 0.00193659 0.00238235 0.0008928545 0.00137178 0.001443549 0.002595206 0.00241861 0.001970069 0.002971642 0.001744282 0.003659837 0.001982228 0.002753941 0.005084414 0.001737308 0.002852872 0.001917002 0.002264044 0.003962676 0.01683335
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 176.6655
##
## solution.v:
## 0.2803969 0.2940625 0.182426 0.2431146
##
## solution.w:
## 0.00333331 0.001016332 0.001199128 0.001191863 0.003659909 0.001904476 0.0004529885 0.0003771487 0.007187123 0.001211802 0.001728976 0.00024133 0.0002032787 0.0006885598 0.000379947 0.0006156252 0.002896444 0.001598805 0.0009406046 0.002428786 0.001521999 0.001119048 0.0002361609 0.0004410012 0.001631454 0.002822745 0.001890776 0.001628054 0.001536577 0.0005997741 0.001623785 0.0001418146 0.0009675016 0.0008472339 0.002961374 0.0009406593 0.0007787482 0.0009752611 0.0003371365 0.0002666511 0.00451818 0.002376968 0.0003850351 0.001068488 0.0003239962 0.01810945 2.20434e-05 0.00546547 0.002006323 0.0006304214 0.1192866 0.000638637 0.002421908 0.001220197 0.001118535 0.0009784081 0.001530986 0.002208506 0.001406623 0.0006162964 0.01378816 0.001389862 0.001196982 0.005660824 0.0005706709 0.01458162 0.0004282381 0.001255297 0.00122139 0.001470273 0.008323645 0.0003020929 0.001542482 0.000716713 0.001423017 0.0005095242 0.001243167 0.00117238 0.0007243817 0.001156608 0.0010773 0.004602446 0.0009848418 0.09709246 0.0001568623 0.001439386 0.001640725 0.0006823716 0.001290966 0.125495 0.002520987 1.2764e-06 0.009678888 0.001537606 0.002203757 0.001595808 0.001436069 0.003867896 0.001782763 0.0008079823 0.004515579 0.001017559 0.0003581826 0.000253738 0.0006542184 0.001138382 0.001322927 0.000672013 0.001335622 0.001289017 0.0006940022 0.0002510216 0.0006631021 2.5276e-06 0.00142945 0.01545489 0.001117494 0.0006492748 0.0005144295 0.008530091 0.0007347695 0.001321885 0.001737822 0.0004253721 0.09406583 0.0005676677 0.2450528 0.001144274 0.0007042392 0.0009594016 0.001096048 0.001235652 0.001158548 0.0009164722 0.0005207029 0.0005218371 0.001426814 0.0007576399 0.0008256277 0.001392574 0.001342181 0.0004321168 0.00172536 0.001173388 0.0002300588 0.0004497621 0.0007790403 0.002173718 8.90432e-05 0.001254806 0.001443102 0.001950539 0.004181193 0.0002177937 0.0007755752 0.008017505 0.0008531373 0.00117002 0.004682655 0.001187997 0.001508434 0.0002625276 0.001063689 0.001123106 0.00245723 0.001271511 0.001503469 0.001237352 0.001132692 0.002447084 0.001334802 0.00165171 0.00380586 0.0009822372 0.0008531364 0.001327095 0.001457416 0.0005921451 0
##
##
## X1, X0, Z1, Z0 all come directly from dataprep object.
##
##
## ****************
## searching for synthetic control unit
##
##
## ****************
## ****************
## ****************
##
## MSPE (LOSS V): 15694.62
##
## solution.v:
## 0.005217493 0.02951801 0.01105224 0.9542123
##
## solution.w:
## 0.002120052 0.003755968 0.003202123 0.003295313 0.00202809 0.002549405 0.008232993 0.0133089 0.001819076 0.003971541 0.001196082 0.007626893 0.01114695 0.002836646 0.006497354 0.004885764 0.001627135 0.003165821 0.003550272 1.8545e-06 0.002311689 0.004089231 0.01414021 0.007666956 0.002486602 0.002124658 0.002638492 0.002934338 0.003147424 0.006838121 0.002952175 0.004660569 0.00381914 0.005407959 0.001640392 0.004851888 0.003184687 0.005073433 0.004310489 0.004641054 0.00185068 0.001790421 0.006946476 0.003962723 0.004465726 0.001523254 0.002884094 0.001826124 0.002687776 0.004498881 0.004325624 0.002375221 0.002065561 0.003284653 0.00429266 0.004138558 0.001625959 0.002031347 0.003284466 0.002233418 0.001558235 0.2179946 0.002874514 0.001759553 0.003850469 0.001567179 0.005141769 0.003695272 0.00321322 0.003316785 0.00180666 0.004117463 0.003048753 0.00390721 0.001805692 0.004430698 0.003704539 0.002722732 0.005148814 0.00341059 0.003655704 0.001356193 0.002415199 0.001375604 0.003884573 0.003362084 0.00249523 0.003515844 0.003319476 0.002624761 0.002411974 0.0002863011 0.0013723 0.002860894 0.002239119 0.002721864 0.003233736 0.00181314 0.002844694 0.005389737 0.001295175 0.003638385 0.001519002 0.005572175 0.004185198 0.001686639 0.003630176 0.006388501 0.003609261 0.002815829 0.005124214 0.0137398 0.00522967 0.04184142 0.001788363 0.0016078 0.002752936 0.005765595 0.006782036 0.001593045 0.003641662 0.002810938 0.002627999 0.00425685 0.0007510279 0.003849262 0.00143529 5.1109e-06 0.003501997 0.003012747 0.003634313 0.001236417 0.003837778 0.003666882 0.007985433 0.00815035 0.003240677 0.005199457 0.004677909 0.002768031 0.002030761 0.008202829 0.002838277 0.003678865 0.01824261 0.006541414 0.005141774 0.002515645 0.004770774 0.003834405 0.002345461 0.002522008 0.00175039 0.002875492 0.005115789 0.001786906 0.005695347 4.68894e-05 0.001677941 0.002819027 0.003224337 0.01410175 0.003621572 0.003290237 0.002392936 0.003543209 0.003308557 0.003250517 0.003821162 0.002411095 0.002798451 0.002968957 0.001961416 0.004791849 0.001812575 0.003377078 0.002062093 0.001474607 0.09041513
Mu.RENT$p+
scale_x_continuous(breaks = c(2002, 2005, 2007, 2010),
labels = c(2002, 2005, 2007, 2010))
