Dear Stata users,
I am currently doing research on CEO compensation. However STATA does not read my data as it should, or better said I do not know how to tell STATA to interpret the currencies right.
The variables salary and bonus are retrieved from a database, so the first salary is 765,769.00 and the bonus is 775,000.00. The variable Severance payment is usually the sum of salary and bonus multiplied by three, however this was mannually calculated in excell and then merged in STATA. The first Severance payment is 4,622,307.00.
The variable SalaryPercentChangeYeartoYe is a percentage and is converted to calculate the variable FutureCompensation. The first FutureCompensation therefore should be: 1,606,778.00
Can someone tell me how to tell STATA to interpret the currencies right? There is no need to include the decimals.
PS: My excell is in Dutch, I do not know if that had something to do with not interpreting the values right?
Thank you in advance!
I am currently doing research on CEO compensation. However STATA does not read my data as it should, or better said I do not know how to tell STATA to interpret the currencies right.
The variables salary and bonus are retrieved from a database, so the first salary is 765,769.00 and the bonus is 775,000.00. The variable Severance payment is usually the sum of salary and bonus multiplied by three, however this was mannually calculated in excell and then merged in STATA. The first Severance payment is 4,622,307.00.
The variable SalaryPercentChangeYeartoYe is a percentage and is converted to calculate the variable FutureCompensation. The first FutureCompensation therefore should be: 1,606,778.00
Code:
gen SalaryChange = (SalaryPercentChangeYeartoYe/100)+1 gen FutureCompensation = Salary * SalaryChange + Bonus
PS: My excell is in Dutch, I do not know if that had something to do with not interpreting the values right?
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double(Salary SalaryPercentChangeYeartoYe) float SalaryChange double Bonus float FutureCompensation double Severancepayment
765.769 8.62 1.0862 775 1606.7783 4622.307
433.138 14.514 1.14514 240.903 736.9067 0
451.731 7.496 1.07496 495.789 981.3818 2842.56
395 19.697 1.19697 230 702.8032 0
517 3.4 1.034 114 648.578 0
845.833 8.333 1.08333 418.281 1334.5973 4300
450 0 1 450 900 0
633.1 0 1 392.522 1025.622 4273.425
776.475 3.339 1.03339 0 802.4016 0
450 0 1 0 450 1350
625 152.427 2.52427 500.337 2078.0059 1875
594.166 5.162 1.05162 0 624.8369 1782.498
708.173 24.367 1.24367 665.683 1546.4165 5152.095
525.732 23.277 1.23277 525 1173.1066 1576.098
1044.336 2.468 1.02468 0 1070.1102 0
1200 50 1.5 2800 4600 30600
400 0 1 0 400 0
233.333 16.667 1.16667 45.678 317.9006 300
675 0 1 245.9 920.9 2753.491
574.997 7.476 1.07476 245 862.9838 2459.991
810 5.883 1.05883 800 1657.6523 0
574.304 3.759 1.03759 36.143 632.0351 1156.2
375.394 0 1 0 375.394 400
350 0 1 639.396 989.396 3850
415.35 3.838 1.03838 0 431.2911 1246.0500000000002
600 52.941 1.52941 60.885 978.531 2116.327
998.462 21.195 1.21195 1225 2435.086 8995.386
445.747 0 1 0 445.747 333.7
340.018 0 1 103.972 443.99 841.52
496.923 24.348 1.24348 354 971.9138 0
520 0 1 589.16 1109.16 0
512.629 0 1 202.2 714.829 2397.815
330 10 1.1 1670 2033 0
309.04 17.605 1.17605 138.376 501.8225 894.8320000000001
1234.641 45.252 1.45252 3806.33 5599.671 0
380.015 3.402 1.03402 0 392.9431 619.4
1200 9.087 1.09087 3000 4309.044 0
735 -20.541 .79459 1029 1613.0237 12900
494.766 9.073 1.09073 800.8 1340.456 4159.925
1133.524 34.878 1.34878 975 2503.8745 8029.445
575 12.153 1.12153 0 644.8798 4125
250 2.995 1.02995 157.5 414.9875 1222.5
750 19.048 1.19048 0 892.86 32250
735 5 1.05 124.95 896.7 1719.9
348 3.571 1.03571 420 780.4271 1880
692.5 4.924 1.04924 539.63 1266.2286 2543
901.939 .214 1.00214 100 1003.8692 6450
841.667 13.458 1.13458 1037 1991.9386 0
650 0 1 0 650 4133.4
675 5.456 1.05456 113.4 825.228 2805.444
283.33 0 1 300 583.33 1749.9899999999998
295.385 755.147 8.55147 76.475 2602.451 0
531.135 5.021 1.05021 390 947.8033 800
325 0 1 400 725 2175
531.599 0 1 0 531.599 1594.797
546 .044 1.00044 301.938 848.1782 0
1100 0 1 1100 2200 6600
990 -2.426 .97574 698.465 1664.4476 5065.395
500 0 1 0 500 4312.5
1462.5 14.706 1.14706 3000 4677.575 13387.5
540 8 1.08 425.2 1008.4 2895.6000000000004
1501.93 50.193 1.50193 2250 4505.794 0
422.917 6.562 1.06562 167.301 617.9698 2100
375 17.188 1.17188 461.825 901.28 2510.4750000000004
350 0 1 0 350 1050
553.334 .606 1.00606 282.15 838.8372 2506.4519999999998
470 0 1 322 792 2376
437 2.084 1.02084 233.402 679.5091 2011.2060000000001
256.833 0 1 86.94 343.773 1031.319
375 21.032 1.21032 75 528.87 0
290 7.407 1.07407 145 456.4803 0
535 8.438 1.08438 660 1240.1433 535
680.016 19.932 1.19932 1445 2260.5566 5400
863 9.657 1.09657 450 1396.34 5250
334.517 7.767 1.07767 247.031 607.5299 0
770 4.348 1.04348 0 803.4796 2810.5
400 6.667 1.06667 351.764 778.432 0
665.016 5.558 1.05558 1130.527 1832.5046 5386.629000000001
750 15.385 1.15385 1200 2065.3875 5850
746.539 8.134 1.08134 680 1487.2625 4036.5
524.14 12.116 1.12116 0 587.64484 4192.71
1300 8.333 1.08333 4011.663 5419.992 0
434.002 0 1 0 434.002 868.004
550 10.079 1.10079 300 905.4345 0
325 0 1 325 650 0
458.654 1.923 1.01923 401.322 868.7959 0
332.495 3.905 1.03905 0 345.4789 0
675.772 35.831 1.35831 350 1267.908 3077.316
520.833 5.86 1.0586 0 551.35376 4593.518
356.154 6.315 1.06315 300 678.6451 1312.308
586.538 3.812 1.03812 229.5 838.3969 0
603.056 6.629 1.06629 0 643.0326 2392.4840000000004
350 0 1 360.279 710.279 0
400 0 1 400 800 1600
1250 25 1.25 1850 3412.5 537.5
450 21.622 1.21622 282.15 829.449 1464.3
400 14.288 1.14288 517.48 974.632 0
285 3.636 1.03636 163.445 458.8076 1345.335
839.846 5.031 1.05031 409.483 1291.5817 3747.987
180.142 0 1 0 180.142 1600
end
Comment