I have a matched treated-control firm-year panel dataset which I matched on different variables using the -rangejoin- command. The matching went well from looking at descriptive statistics for each group. The treated-control firms are differentiated in the dataset by virtue of the 'treated' dummy variable (1= treated, 0=control). Each treated firm was matched to up to 5 control firms, so some have 1control firm, others may have 5.
The pair_num variable showed the number of the treated-control pair, but when I reshaped the data after the matching process, I only kept one observation for each firm-year (so if treated firm A had 4 matches, I only kept one observation for each firm-year row of treated firm A (not all 4)).
What I am looking for is a way to identify each treated firm and all of its corresponding matched control firms. So for example, Group 1 equals target firms 1 and all of its correpsonding controls; Group 2 equals target firms 2 and all of its corresponding controls, and so on.
When I sort using the following code:
Code:
sort pair_num id Year
I'm not sure whether what I am looking to do is possible, or whether I need to do something differently when I run the matching or reshaping code.
Any advice is greatly appreciated,
Paul
Please see below for an example of the data:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long pair_num str136 Companyname str9 Registerednumber str15 BvDIDnumber float(DealYear treated) long p_status int Year double(FixedAssets TangibleAssets IntangibleAssets Investments OtherFixedAssets CurrentAssets) 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2001 2850 2465 . 384 . 40421 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2002 4088.014 3703.597 . 384.417 . 33792.998 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2003 4849.128 4464.711 . 384.417 . 52603.411 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2004 5609.843 5268.825 . 341.018 . 59359.373 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2005 6793.554 6452.536 . 341.018 . 64947.815 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2006 2958.092 2617.074 . 341.018 . 87492.936 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2007 1999.354 1658.336 . 341.018 . 141324.627 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2008 1198.472 857.454 . 341.018 . 191080.617 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2009 521.467 478.068 . 43.399 . 209791.526 1 "SHELL INTERNATIONAL TRADING AND SHIPPING COMPANY LIMITED" "00525037" "GB00525037" 2004 0 3 2010 417.514 417.514 . . 165.679 240329.465 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2001 35707 34336 23 1349 . 11852 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2002 31720.372 30004.018 18.09 1698.264 . 16206.858 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2003 37079.622 37799.772 -4012.149 3291.999 . 17046.216 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2004 33069 28066 -313 5316 . 26038 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2005 44939 39211 259 5469 . 21806 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2006 40296 32500 . 7796 . 34154 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2007 66002 53168 . 12835 . 40940 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2008 88003 55123 . 32880 . 65469 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2009 82786 52107 . 30680 . 59307 2 "CARISBROOKE SHIPPING HOLDINGS LIMITED" "03783705" "GB03783705" 2004 0 3 2010 82165 44676 . 37490 . 53379 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2001 31223 31075 . 148 . 48959 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2002 30359 30211 . 148 . 46479 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2003 36882 36734 . 148 . 40210 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2004 38717.4 38569.4 . 148 . 33016.7 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2005 38271.9 38123.9 . 148 . 28900.8 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2006 36584.9 36436.9 . 148 . 26811.1 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2007 34666.6 34518.6 . 148 . 31530.8 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2008 32485 32337 . 148 . 37596 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2009 32389 32241 . 148 . 41520 3 "SOUTHAMPTON ISLE OF WIGHT AND SOUTH OF ENGLAND ROYAL MAIL STEAM PACKET COMPANY LIMITED" "00002404" "GB00002404" 2004 1 4 2010 30954 30806 . 148 . 50503 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2001 17424 114 . 17310 . 1324 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2002 17461.307 163.587 . 17297.72 . 5382.401 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2003 16450.499 1212.929 15237.571 . . 31977.203 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2004 15290.808 687.116 14603.692 . . 15513.862 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2005 16022.078 133.929 15888.148 . . 13674.957 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2006 78.544 78.392 . .152 . 9710.64 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2007 138.495 138.345 . .15 . 23183.767 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2008 189.195 188.989 . .205 . 38029.286 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2009 118.592 111.456 . 7.136 111.456 19526.875 3 "GLOBAL LNG UK LTD" "03971528" "GB03971528" 2004 0 3 2010 103.424 73.071 . 30.353 73.071 19973.668 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2001 127686 124123 . 3563 . 48708 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2002 151745 148184 . 3561 . 46705 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2003 165750 160704 . 5046 . 56521 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2004 . . . . . . 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2005 180826 180826 . . 10969 89176 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2006 184325 184325 . . 3638 44315 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2007 196783 196783 . . . 41423 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2008 211141 210455 686 . 13891 39283 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2009 . . . . . . 4 "GREGGS PLC" "00502851" "GB00502851" 2004 0 3 2010 211734 211155 579 . . 67711 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2001 97299 92351 . 4948 . 45771 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2002 112814 109136 . 3678 . 58247 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2003 139732 136054 . 3678 . 56811 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2004 153674 149996 . 3678 . 88875 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2005 195612 191934 . 3678 . 68173 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2006 209356 209355 . 1 . 75703 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2007 231506 231505 . 1 . 98635 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2008 213971 213970 . 1 . 209444 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2009 270446 270445 . 1 . 129577 5 "WARBURTONS LIMITED" "00178711" "GB00178711" 2004 0 3 2010 214805 210804 . 4001 . 208072 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2001 200655 192946 2792 4917 . 124412 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2002 199206 191652 2324 5230 . 131805 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2003 193673 186040 2232 5401 . 165142 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2004 161817 120722 . 41095 . 207269 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2005 153395 113661 . 39734 . 215055 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2006 143800 106970 854 35976 . 268110 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2007 138055 105239 811 32005 . 348264 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2008 136830 104375 767 31688 . 401375 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2009 138762 105900 724 32138 . 487165 5 "WEETABIX LIMITED" "00267687" "GB00267687" 2004 1 4 2010 . . . . . . 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2001 4431 4431 . . . 18745 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2002 3892 3892 . . . 24149 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2003 4116 4116 . . . 31733 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2004 5360 5360 . . . 40587 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2005 4866 4866 . . . 42916 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2006 5001 5001 . . . 41939 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2007 4282 4282 . . . 51727 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2008 4190 4190 . . . 51526 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2009 3875 3875 . . . 38315 6 "SWIFT GROUP LIMITED" "00832994" "GB00832994" 2004 0 3 2010 3497 3497 . . . 45897 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2001 2789 2789 . . . 28656 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2002 3008 3008 . . . 35736 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2003 3028 3028 . . . 42709 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2004 3618 3618 . . . 37889 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2005 3957.785 3957.785 . . . 39611.471 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2006 3297.866 3297.866 . . . 51623.437 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2007 2781.356 2781.356 . . . 70023.456 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2008 2598.189 2598.189 . . . 62710.047 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2009 2463.659 2463.659 . . . 77259.845 7 "WILLERBY LIMITED" "00387583" "GB00387583" 2004 1 4 2010 2069.418 2069.418 . . . 88325.396 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2001 16661 14361 . 2300 . 17702 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2002 15344 13044 . 2300 . 15800 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2003 13535 11235 . 2300 . 18198 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2004 27182 13596 . 13586 . 33358 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2005 28150 14564 . 13586 . 27833 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2006 27616 14030 . 13586 . 34891 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2007 12820 12820 . . . 38169 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2008 15070 14899 171 . . 33870 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2009 16402 16264 138 . . 20023 7 "SOGEFI FILTRATION LIMITED" "00693949" "GB00693949" 2004 0 3 2010 17479 15338 408 1733 . 20790 end label values p_status p_status label def p_status 3 "_U", modify label def p_status 4 "_p", modify
0 Response to Code to be able identify treated-control firm(s) groups for matched data
Post a Comment