I do have the following data firm level data:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str18 country double firm_id float(total_sales1 total_sales2 total_sales3 total_RD_y1_ind total_RD_y2_ind total_RD_y3_ind RD_intensity_1 RD_intensity_2 RD_intensity_3) byte dforeign_y3 double(sales_y1 sales_y2 sales_y3 ttexp_y1 ttexp_y2 ttexp_y3) "Chile" 200031 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 2026434944 3770808064 . . . . "Colombia" 147156 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 14847947776 . . . . "Chile" 101837 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 144106000 76639000 . . . . "Colombia" 142899 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1.182e+09 . . . . "Colombia" 144048 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 981707 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 982524 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Argentina" 864140 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 43214688 58765828 79827048 . . . "Colombia" 975822 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1.910e+12 . 0 0 . "Argentina" 816743 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 18534438 42266820 47798448 . . . "Colombia" 986804 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 13851177984 . . . . "Colombia" 865778 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 146594 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 143531 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1579171968 . . . . "Colombia" 866998 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 14489676800 . 0 0 . "Colombia" 144722 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 2907795968 . . . . "Argentina" 149511 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 1 9.510e+08 1.254e+09 1.532e+09 . . . "Colombia" 986641 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 4223451904 . . . . "Uruguay" 3621 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 . . 1197303040 . . . "Argentina" 114751 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 680061 1821817 2245328 . . . "Colombia" 975586 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 978232 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 980681 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 2.420e+08 . . . . "Colombia" 973348 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 30860777472 . . . . "Colombia" 145396 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 5376013824 . 0 0 . "Colombia" 978248 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 25000000 35000000 . "Colombia" 978299 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 986318 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 980662 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 276417984 114380000 . "Argentina" 949913 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 1 25329552 27873484 30938072 . . . "Colombia" 980863 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 427285 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 147319 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 982423 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 23323588608 . . . . "Chile" 201419 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 5416278016 9357216768 . . . . "Colombia" 867075 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Chile" 100034 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 3927260928 3524687104 . . . . "Colombia" 979121 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 980896 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 297008000 . . . . "Chile" 201389 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 21893240832 21876649984 . . . . "Colombia" 867321 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Chile" 201467 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 66331209728 61389864960 . 0 0 . "Chile" 100096 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 137706000 126948000 . . . . "Argentina" 627025 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 11946822 22396824 30617252 . . . "Colombia" 973230 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Argentina" 830576 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 6464928 8873396 11973343 . . . "Argentina" 405196 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 6150000 7845000 9142500 . . . "Colombia" 366989 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 142943008 . . . . "Argentina" 906655 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 4304025 6266894 7262848 . . . "Colombia" 427568 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 982174 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 6.860e+11 . . . . "Argentina" 614559 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 8981726 16480901 22130754 . . . "Colombia" 982524 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 27823288320 . . . . "Colombia" 142522 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 20219371520 . . . . "Colombia" 867351 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 139964992 . . . . "Colombia" 973350 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1.380e+11 . . . . "Colombia" 865408 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 4081722112 . . . . "Chile" 200383 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 2267186944 2757421056 . 0 7574000 . "Colombia" 986628 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 147146 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Chile" 204119 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 11683830784 18200739840 . 0 0 . "Colombia" 986378 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Uruguay" 606 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 . . 43000000 . . . "Colombia" 144169 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 66151000 . 0 0 . "Colombia" 982239 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Argentina" 704717 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 1 149861248 225940336 262746400 . . . "Colombia" 145815 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1721950976 . . . . "Argentina" 735605 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 32114802 42479480 63034752 . . . "Colombia" 978279 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Chile" 200915 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 5093669888 4956000256 . 0 0 . "Colombia" 865579 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 145744 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 3608020992 . . . . "Panama" 29860 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . 199715 . . . "Colombia" 986463 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 986262 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 56176779264 . 0 0 . "Argentina" 130103 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 21441864 25467152 17226286 . . . "Colombia" 982257 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 44674076672 . . . . "Panama" 19129 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . 176691 . . . "Colombia" 144400 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 4393129984 . 0 0 . "Colombia" 145397 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 981658 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 5092732928 . 0 0 . "Colombia" 366880 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 146443 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 830649984 . . . . "Colombia" 866171 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 2736587008 . . . . "Colombia" 366537 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 285692000 . . . . "Argentina" 299233 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 4.011e+08 5.357e+08 719500032 . . . "Colombia" 986592 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Colombia" 145418 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 1977997056 . . . . "Colombia" 145597 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 414991008 . . . . "Panama" 14392 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . 72216 . . . "Argentina" 712929 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 948951168 1251433216 1529548928 . . . "Colombia" 147589 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 367363 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Colombia" 147167 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . . . . "Argentina" 950012 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 0 23487832 37718632 41779488 . . . "Colombia" 143477 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 421918016 . . . . "Colombia" 866714 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 11212934144 . . . . "Colombia" 427460 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . 314967008 . . . . "Colombia" 986295 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . . . . 0 0 . "Chile" 202164 2.399476e+13 1.595935e+14 2.943715e+11 237710950400 3.61665e+11 330186432 .009906786 .0022661635 .0011216658 . 17192112128 22868748288 . 0 0 . end
Where I constructed
Code:
gen ttexp_sales3= ttexp_y3/ sales_y3
Code:
reg ttexp_sales3 i.dforeign_y3##i.tech_intensity i.isic3_2d, robust
Code:
reg ttexp_sales2 i.dforeign_y3##i.tech_intensity i.isic3_2d, robust
note: 28.isic3_2d omitted because of collinearity
note: 36.isic3_2d omitted because of collinearity
Linear regression Number of obs = 215
F(20, 194) = 0.92
Prob > F = 0.5620
R-squared = 0.1225
Root MSE = .04013
--------------------------------------------------------------------------------------------
| Robust
ttexp_sales2 | Coef. Std. Err. t P>|t| [95% Conf. Interval]
---------------------------+----------------------------------------------------------------
1.dforeign_y3 | .0030758 .0116993 0.26 0.793 -.0199983 .0261498
|
tech_intensity |
2 | -.0024561 .0033194 -0.74 0.460 -.0090029 .0040906
3 | .0101011 .009589 1.05 0.293 -.0088109 .0290131
|
dforeign_y3#tech_intensity |
1 2 | -.0002287 .0124497 -0.02 0.985 -.0247829 .0243255
1 3 | .0164692 .0183075 0.90 0.369 -.0196381 .0525766
|
isic3_2d |
17 | -.0054391 .0028378 -1.92 0.057 -.011036 .0001578
18 | -.0043643 .003199 -1.36 0.174 -.0106736 .0019451
19 | -.0046627 .0036099 -1.29 0.198 -.0117825 .002457
20 | -.0054079 .0032356 -1.67 0.096 -.0117894 .0009737
21 | -.0068413 .0067126 -1.02 0.309 -.0200804 .0063978
22 | .0709638 .0711941 1.00 0.320 -.06945 .2113776
24 | -.0020775 .0112219 -0.19 0.853 -.02421 .0200551
25 | .0009922 .0041954 0.24 0.813 -.0072822 .0092667
26 | -.0011505 .0053064 -0.22 0.829 -.0116162 .0093153
27 | -.001142 .004133 -0.28 0.783 -.0092933 .0070094
28 | 0 (omitted)
29 | -.0180382 .0109757 -1.64 0.102 -.0396852 .0036088
30 | -.0127187 .0097381 -1.31 0.193 -.0319249 .0064875
33 | -.0122287 .0098828 -1.24 0.217 -.0317202 .0072629
34 | -.017296 .0105729 -1.64 0.103 -.0381486 .0035566
35 | .0133179 .0251763 0.53 0.597 -.0363365 .0629722
36 | 0 (omitted)
|
_cons | .0079074 .0024444 3.23 0.001 .0030864 .0127284
--------------------------------------------------------------------------------------------Thank you!
0 Response to Question about regression output
Post a Comment