Hi,
Currently, I am working with CPS monthly microdata from https://ceprdata.org/cps-uniform-dat.../cps-org-data/. I want to analyse the Minimum wage change in Colorado in 2017 when min.wage. changed from $8.31 to $9.30.
I collapsed data by year and state counting employment

collapse (median) wage1 (count) empl, by(year state )

In order to get a visual graph, I am dropping all the states except 1 treated Colorado and 1 control state (any state with no change in the minimum wage).

Questions
1.How can I get a graph which shows treated (Colorado) and the rest of the weighted control group?

2.I attached some graphs that I got using following command:
xtline empl, overlay plot1opts(recast(connected)) plot2opts(recast(connected)) tline(2017, lpattern(dash) lcolor(black)) tlabel(#12)

These graphs are clearly not holding parallel trends assumption, How can I achieve a parallel trend visually?

3. Did I conduct the analyses correctly for checking the parallels trend?


year state wage1 empl
2008 Maine 9 2908
2014 Maine 10 2417
2015 Maine 10 1688
2016 Maine 10.25 1397
2017 Maine 10 1427
2018 Maine 12 1328
2008 New Hampshire 9.4 3014
2014 New Hampshire 10 2821
2015 New Hampshire 10 2230
2016 New Hampshire 10.5 1973
2017 New Hampshire 11 2002
2018 New Hampshire 11.125 1955
2008 Vermont 9.75 2130
2014 Vermont 10.5 2093
2015 Vermont 11 2042
2016 Vermont 11.75 2093
2017 Vermont 12 1981
2018 Vermont 11.67 1988
2008 Massachusetts 10 2361
2014 Massachusetts 10.15 2485
2015 Massachusetts 10.5 2916
2016 Massachusetts 11.41 3195
2017 Massachusetts 11.5 3143
2018 Massachusetts 12 2872
2008 Rhode Island 9 2579
2014 Rhode Island 10 2376
2015 Rhode Island 10 1762
2016 Rhode Island 11 1473
2017 Rhode Island 11.5 1436
2018 Rhode Island 12 1481
2008 Connecticut 10 3203
2014 Connecticut 10 2959
2015 Connecticut 10.5 1988
2016 Connecticut 11 1515
2017 Connecticut 12 1499
2018 Connecticut 13 1479
2008 New York 9.5 6972
2014 New York 10 7190
2015 New York 10 6896
2016 New York 10.25 6995
2017 New York 11.5 6750
2018 New York 12.225 6602
2008 New Jersey 9.5 3208
2014 New Jersey 10 3281
2015 New Jersey 10 3201
2016 New Jersey 10.2 3226
2017 New Jersey 10.725 3177
2018 New Jersey 12 3109
2008 Pennsylvania 8.5 4795
2014 Pennsylvania 10 4877
2015 Pennsylvania 9.96 4531
2016 Pennsylvania 10 4542
2017 Pennsylvania 10.5 4384
2018 Pennsylvania 11 4226
2008 Ohio 8.5 4198
2014 Ohio 9.5 4307
2015 Ohio 10 4242
2016 Ohio 10 4162
2017 Ohio 10 4106
2018 Ohio 10.87 3922
2008 Indiana 8.67 2412
2014 Indiana 9.5 2481
2015 Indiana 10 2526
2016 Indiana 10 2483
2017 Indiana 10 2518
2018 Indiana 11 2452
2008 Illinois 8.985001 4710
2014 Illinois 10 4850
2015 Illinois 10 4574
2016 Illinois 10 4478
2017 Illinois 10.75 4311
2018 Illinois 11.25 4094
2008 Michigan 8.72 3951
2014 Michigan 9.375 3942
2015 Michigan 10 3706
2016 Michigan 10 3770
2017 Michigan 10.5 3617
2018 Michigan 11 3559
2008 Wisconsin 9 2725
2014 Wisconsin 10 2751
2015 Wisconsin 10 2166
2016 Wisconsin 10 2003
2017 Wisconsin 10.5 1925
2018 Wisconsin 11 1956
2008 Minnesota 9.25 3332
2014 Minnesota 10 3149
2015 Minnesota 10.15 2126
2016 Minnesota 11.02 1814
2017 Minnesota 11.5 1777
2018 Minnesota 11.95 1826
2008 Iowa 8.75 2532
2014 Iowa 10 2370
2015 Iowa 10 1792
2016 Iowa 10.3 1641
2017 Iowa 11 1621
2018 Iowa 11 1548
2008 Missouri 8.5 2608
2014 Missouri 9.615 2474
2015 Missouri 9.5 2271
2016 Missouri 10 2208
2017 Missouri 10.5 2305
2018 Missouri 10.5 2137
2008 North Dakota 8.75 1683
2014 North Dakota 11 1850
2015 North Dakota 12 2021
2016 North Dakota 12 1991
2017 North Dakota 12 1969
2018 North Dakota 12.15 2011
2008 South Dakota 8.8 2037
2014 South Dakota 10 2148
2015 South Dakota 10.04 1571
2016 South Dakota 10.5 1595
2017 South Dakota 11 1610
2018 South Dakota 11 1607
2008 Nebraska 8.5 2058
2014 Nebraska 10 2012
2015 Nebraska 10 1841
2016 Nebraska 10.5 1785
2017 Nebraska 11 1748
2018 Nebraska 11.145 1718
2008 Kansas 8.5 2018
2014 Kansas 9.5 1984
2015 Kansas 10 1777
2016 Kansas 10 1765
2017 Kansas 10.5 1769
2018 Kansas 11 1774
2008 Delaware 9 2422
2014 Delaware 10 2570
2015 Delaware 10 2016
2016 Delaware 10.075 1870
2017 Delaware 10.5 1754
2018 Delaware 11.5 1783
2008 Maryland 9 3424
2014 Maryland 10 3159
2015 Maryland 10 2174
2016 Maryland 10.77 1777
2017 Maryland 10.65 1798
2018 Maryland 12 1808
2008 District of Columbia 10 1844
2014 District of Columbia 10.605 1920
2015 District of Columbia 11 1977
2016 District of Columbia 12 2102
2017 District of Columbia 12 2015
2018 District of Columbia 13 1920
2008 Virginia 9 2990
2014 Virginia 9.25 3190
2015 Virginia 9.5 2993
2016 Virginia 10 2859
2017 Virginia 10 2794
2018 Virginia 11.5 2701
2008 West Virginia 8 2160
2014 West Virginia 9 2656
2015 West Virginia 9.5 3788
2016 West Virginia 10 4084
2017 West Virginia 10.195 4087
2018 West Virginia 11 3941
2008 North Carolina 8.5 3218
2014 North Carolina 9 3467
2015 North Carolina 9.63 3704
2016 North Carolina 10 3714
2017 North Carolina 10 3663
2018 North Carolina 10.625 3500
2008 South Carolina 8 2234
2014 South Carolina 9.5 2369
2015 South Carolina 10 2644
2016 South Carolina 9.75 2665
2017 South Carolina 10 2675
2018 South Carolina 10.5 2680
2008 Georgia 9 3017
2014 Georgia 9.27 3597
2015 Georgia 10 3655
2016 Georgia 10 3553
2017 Georgia 10.5 3531
2018 Georgia 11 3577
2008 Florida 9 6880
2014 Florida 10 7320
2015 Florida 10 7954
2016 Florida 10 8083
2017 Florida 10.99 7822
2018 Florida 11 7580
2008 Kentucky 8.5 2498
2014 Kentucky 9.25 2484
2015 Kentucky 10 2308
2016 Kentucky 10 2198
2017 Kentucky 10 2149
2018 Kentucky 10.375 2047
2008 Tennessee 8.75 2251
2014 Tennessee 9.125 2628
2015 Tennessee 9.5 3071
2016 Tennessee 10 3209
2017 Tennessee 10.5 3183
2018 Tennessee 10.5 3130
2008 Alabama 8.58 1829
2014 Alabama 10 2340
2015 Alabama 9.5 3320
2016 Alabama 10 3602
2017 Alabama 10 3600
2018 Alabama 10.75 3364
2008 Mississippi 8.360001 1602
2014 Mississippi 9 2133
2015 Mississippi 9 3180
2016 Mississippi 9.5 3392
2017 Mississippi 10 3351
2018 Mississippi 10 3263
2008 Arkansas 8 1721
2014 Arkansas 9.285 2248
2015 Arkansas 9.4 2915
2016 Arkansas 10 3103
2017 Arkansas 10 3167
2018 Arkansas 11.04 3135
2008 Louisiana 8.5 1589
2014 Louisiana 9.5 2143
2015 Louisiana 9 3560
2016 Louisiana 10 3993
2017 Louisiana 10 3888
2018 Louisiana 10 3838
2008 Oklahoma 8 1885
2014 Oklahoma 9.86 2097
2015 Oklahoma 9.5 2313
2016 Oklahoma 10 2394
2017 Oklahoma 10.24 2381
2018 Oklahoma 10.5 2344
2008 Texas 8.04 7942
2014 Texas 9.025 8296
2015 Texas 9.4 8488
2016 Texas 10 8873
2017 Texas 10 8828
2018 Texas 10.5 8636
2008 Montana 9 1528
2014 Montana 10 1996
2015 Montana 10 2943
2016 Montana 10 3411
2017 Montana 11 3296
2018 Montana 11.75 3003
2008 Idaho 9 1783
2014 Idaho 9.5 1878
2015 Idaho 10 2262
2016 Idaho 10 2503
2017 Idaho 10 2479
2018 Idaho 11 2477
2008 Wyoming 9 1794
2014 Wyoming 10 1850
2015 Wyoming 10 1970
2016 Wyoming 10 2096
2017 Wyoming 11 2191
2018 Wyoming 11.225 2138
2008 Colorado 9.3 2873
2014 Colorado 10 2918
2015 Colorado 10.26 2119
2016 Colorado 11.295 1796
2017 Colorado 12 1801
2018 Colorado 12 1659
2008 New Mexico 9 1469
2014 New Mexico 10 1876
2015 New Mexico 10 2861
2016 New Mexico 10 3310
2017 New Mexico 10 3168
2018 New Mexico 10.63 2867
2008 Arizona 9.47 2055
2014 Arizona 10 2352
2015 Arizona 10 2705
2016 Arizona 10 2725
2017 Arizona 10.2 2587
2018 Arizona 11 2541
2008 Utah 9 1674
2014 Utah 10 1836
2015 Utah 10 1937
2016 Utah 10 2067
2017 Utah 11 1969
2018 Utah 11.1 2033
2008 Nevada 10 2572
2014 Nevada 10.3 2606
2015 Nevada 11 2211
2016 Nevada 11 2288
2017 Nevada 11 2238
2018 Nevada 12 2134
2008 Washington 9.75 2564
2014 Washington 10.2 2874
2015 Washington 10.8 2761
2016 Washington 12 2689
2017 Washington 12 2827
2018 Washington 12.75 2864
2008 Oregon 9 2262
2014 Oregon 10 2497
2015 Oregon 10.45 2548
2016 Oregon 10.5 2494
2017 Oregon 11.75 2445
2018 Oregon 12.75 2363
2008 California 9.36 13453
2014 California 10 14934
2015 California 10 14582
2016 California 11 14229
2017 California 11.75 14019
2018 California 12 13682
2008 Alaska 10.5 1777
2014 Alaska 12 1687
2015 Alaska 12 1703
2016 Alaska 12 1690
2017 Alaska 12.5 1635
2018 Alaska 12.5 1567
2008 Hawaii 10 2630
2014 Hawaii 10.3 2725
2015 Hawaii 11.25 2699
2016 Hawaii 12 2711
2017 Hawaii 11.5 2542
2018 Hawaii 12.25 2360