I tried to merge two panel datasets with the following command:
Code:
merge 1:1 timevar c_id using "C:\Users\svanpoppel\OneDrive - Deloitte (O365D)\Documents\Master Scriptie\Data\Stata\mergemap\an2 controlir.dta", update replace
variables timevar c_id do not uniquely identify observations in the using data
r(459);
So I looked into the using dataset for duplicates and if it is the right id variable:
Code:
duplicates drop c_id timevar, force
Also:
Code:
isid c_id timevar
Furthermore, there are no missing observations for c_id or timevar in both datasets.
Dataset1(master dataset):
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(date timevar oldid ir) int year float(sampl year2) str2 ggiso int(indg wc06011) byte ftsisc double totass long equity double(price ask bid) long(ncfo comshare) float fperiod double beta str12 isin float c_id 21276 21276 2 . 1802 . 2018 "AT" 98 1310 . 736969 316078 22.3 . . 37201 45790 21914 1.68 "AT00000FACC2" 2 21277 21277 2 . 1803 . 2018 "AT" 98 1310 . 736969 316078 21.1 21.25 21.2 37201 45790 21914 1.68 "AT00000FACC2" 2 21278 21278 2 . 1804 . 2018 "AT" 98 1310 . 736969 316078 21.9 21.85 21.7 37201 45790 21914 1.68 "AT00000FACC2" 2 21279 21279 2 . 1805 . 2018 "AT" 98 1310 . 736969 316078 22.65 22.65 22.55 37201 45790 21914 1.68 "AT00000FACC2" 2 21280 21280 2 . 1806 . 2018 "AT" 98 1310 . 736969 316078 22.8 22.8 22.7 37201 45790 21914 1.68 "AT00000FACC2" 2 21283 21283 2 . 1807 . 2018 "AT" 98 1310 . 736969 316078 22.15 22.25 22.15 37201 45790 21914 1.68 "AT00000FACC2" 2 21284 21284 2 . 1808 . 2018 "AT" 98 1310 . 736969 316078 21.95 22.05 21.95 37201 45790 21914 1.68 "AT00000FACC2" 2 21285 21285 2 . 1809 . 2018 "AT" 98 1310 . 736969 316078 21.5 21.6 21.55 37201 45790 21914 1.68 "AT00000FACC2" 2 21286 21286 2 . 1810 . 2018 "AT" 98 1310 . 736969 316078 22.05 22.05 21.95 37201 45790 21914 1.68 "AT00000FACC2" 2 21287 21287 2 . 1811 . 2018 "AT" 98 1310 . 736969 316078 22.05 22.05 21.95 37201 45790 21914 1.68 "AT00000FACC2" 2 21290 21290 2 . 1812 . 2018 "AT" 98 1310 . 736969 316078 22.05 22.15 22.05 37201 45790 21914 1.68 "AT00000FACC2" 2 21291 21291 2 . 1813 . 2018 "AT" 98 1310 . 736969 316078 21.6 21.65 21.6 37201 45790 21914 1.68 "AT00000FACC2" 2 21292 21292 2 . 1814 . 2018 "AT" 98 1310 . 736969 316078 21.45 21.5 21.45 37201 45790 21914 1.68 "AT00000FACC2" 2 21293 21293 2 . 1815 . 2018 "AT" 98 1310 . 736969 316078 22 22 21.95 37201 45790 21914 1.68 "AT00000FACC2" 2 21294 21294 2 . 1816 . 2018 "AT" 98 1310 . 736969 316078 21.6 21.6 21.5 37201 45790 21914 1.68 "AT00000FACC2" 2 21297 21297 2 . 1817 . 2018 "AT" 98 1310 . 736969 316078 21.65 21.75 21.65 37201 45790 21914 1.68 "AT00000FACC2" 2 21298 21298 2 . 1818 . 2018 "AT" 98 1310 . 736969 316078 22.1 22.05 21.95 37201 45790 21914 1.68 "AT00000FACC2" 2 21299 21299 2 . 1819 . 2018 "AT" 98 1310 . 736969 316078 20.85 21 20.9 37201 45790 21914 1.68 "AT00000FACC2" 2 21300 21300 2 . 1820 . 2018 "AT" 98 1310 . 736969 316078 20.5 20.6 20.5 37201 45790 21914 1.68 "AT00000FACC2" 2 21301 21301 2 . 1821 . 2018 "AT" 98 1310 . 736969 316078 20.55 20.6 20.55 37201 45790 21914 1.68 "AT00000FACC2" 2 21304 21304 2 . 1822 . 2018 "AT" 98 1310 . 736969 316078 20.55 20.55 20.5 37201 45790 21914 1.68 "AT00000FACC2" 2 21305 21305 2 . 1823 . 2018 "AT" 98 1310 . 736969 316078 20.55 . . 37201 45790 21914 1.68 "AT00000FACC2" 2 21306 21306 2 . 1824 . 2018 "AT" 98 1310 . 736969 316078 21.3 21.2 21.15 37201 45790 21914 1.68 "AT00000FACC2" 2 21307 21307 2 . 1825 . 2018 "AT" 98 1310 . 736969 316078 20.65 20.75 20.7 37201 45790 21914 1.68 "AT00000FACC2" 2 21308 21308 2 . 1826 . 2018 "AT" 98 1310 . 736969 316078 20.35 20.45 20.35 37201 45790 21914 1.68 "AT00000FACC2" 2 21311 21311 2 . 1827 . 2018 "AT" 98 1310 . 736969 316078 21.3 21.3 21.2 37201 45790 21914 1.68 "AT00000FACC2" 2 21312 21312 2 . 1828 . 2018 "AT" 98 1310 . 736969 316078 21.15 21.2 21.05 37201 45790 21914 1.68 "AT00000FACC2" 2 18753 18753 3 . 1 . 2011 "AT" 102 4310 83 146626982 9792892 35.3 35.45 35.27 -1155127 203169 18992 1.63 "AT0000606306" 3 18756 18756 3 . 2 . 2011 "AT" 102 4310 83 146626982 9792892 35.18 35.37 35.03 -1155127 203169 18992 1.63 "AT0000606306" 3 18757 18757 3 . 3 . 2011 "AT" 102 4310 83 146626982 9792892 35.43 35.5 35.3 -1155127 203169 18992 1.63 "AT0000606306" 3 18758 18758 3 . 4 . 2011 "AT" 102 4310 83 146626982 9792892 35.94 35.82 35.79 -1155127 203169 18992 1.63 "AT0000606306" 3 18759 18759 3 . 5 . 2011 "AT" 102 4310 83 146626982 9792892 35.94 35.92 35.91 -1155127 203169 18992 1.63 "AT0000606306" 3 18760 18760 3 . 6 . 2011 "AT" 102 4310 83 146626982 9792892 35.48 35.53 35.48 -1155127 203169 18992 1.63 "AT0000606306" 3 18763 18763 3 . 7 . 2011 "AT" 102 4310 83 146626982 9792892 35.44 35.34 35.24 -1155127 203169 18992 1.63 "AT0000606306" 3 18764 18764 3 . 8 . 2011 "AT" 102 4310 83 146626982 9792892 35.08 35.09 35 -1155127 203169 18992 1.63 "AT0000606306" 3 18765 18765 3 . 9 . 2011 "AT" 102 4310 83 146626982 9792892 35.32 35.4 35.33 -1155127 203169 18992 1.63 "AT0000606306" 3 18766 18766 3 . 10 . 2011 "AT" 102 4310 83 146626982 9792892 35.49 35.51 35.49 -1155127 203169 18992 1.63 "AT0000606306" 3 18767 18767 3 . 11 . 2011 "AT" 102 4310 83 146626982 9792892 35.33 35.24 35.21 -1155127 203169 18992 1.63 "AT0000606306" 3 18770 18770 3 . 12 . 2011 "AT" 102 4310 83 146626982 9792892 34.77 34.67 34.57 -1155127 203169 18992 1.63 "AT0000606306" 3 18771 18771 3 . 13 . 2011 "AT" 102 4310 83 146626982 9792892 34.79 34.9 34.81 -1155127 203169 18992 1.63 "AT0000606306" 3 18772 18772 3 . 14 . 2011 "AT" 102 4310 83 146626982 9792892 34.47 34.57 34.53 -1155127 203169 18992 1.63 "AT0000606306" 3 18773 18773 3 . 15 . 2011 "AT" 102 4310 83 146626982 9792892 35.09 35.17 35.06 -1155127 203169 18992 1.63 "AT0000606306" 3 18774 18774 3 . 16 . 2011 "AT" 102 4310 83 146626982 9792892 35.91 35.87 35.83 -1155127 203169 18992 1.63 "AT0000606306" 3 18777 18777 3 . 17 . 2011 "AT" 102 4310 83 146626982 9792892 35.93 36.1 35.96 -1155127 203169 18992 1.63 "AT0000606306" 3 18778 18778 3 . 18 . 2011 "AT" 102 4310 83 146626982 9792892 36.38 36.21 36.2 -1155127 203169 18992 1.63 "AT0000606306" 3 18779 18779 3 . 19 . 2011 "AT" 102 4310 83 146626982 9792892 36.12 36.2 36.1 -1155127 203169 18992 1.63 "AT0000606306" 3 18780 18780 3 . 20 . 2011 "AT" 102 4310 83 146626982 9792892 36.12 . . -1155127 203169 18992 1.63 "AT0000606306" 3 18781 18781 3 . 21 . 2011 "AT" 102 4310 83 146626982 9792892 35.66 35.67 35.67 -1155127 203169 18992 1.63 "AT0000606306" 3 18784 18784 3 . 22 . 2011 "AT" 102 4310 83 146626982 9792892 34.47 34.49 34.49 -1155127 203169 18992 1.63 "AT0000606306" 3 18785 18785 3 . 23 . 2011 "AT" 102 4310 83 146626982 9792892 34.16 34.32 34.24 -1155127 203169 18992 1.63 "AT0000606306" 3 18786 18786 3 . 24 . 2011 "AT" 102 4310 83 146626982 9792892 33.45 33.52 33.42 -1155127 203169 18992 1.63 "AT0000606306" 3 18787 18787 3 . 25 . 2011 "AT" 102 4310 83 146626982 9792892 33.51 33.51 33.49 -1155127 203169 18992 1.63 "AT0000606306" 3 18788 18788 3 . 26 . 2011 "AT" 102 4310 83 146626982 9792892 32.98 33.07 33.06 -1155127 203169 18992 1.63 "AT0000606306" 3 18791 18791 3 . 27 . 2011 "AT" 102 4310 83 146626982 9792892 32.98 . . -1155127 203169 18992 1.63 "AT0000606306" 3 18792 18792 3 . 28 . 2011 "AT" 102 4310 83 146626982 9792892 33.35 33.38 33.3 -1155127 203169 18992 1.63 "AT0000606306" 3 18793 18793 3 . 29 . 2011 "AT" 102 4310 83 146626982 9792892 32.97 32.75 32.7 -1155127 203169 18992 1.63 "AT0000606306" 3 18794 18794 3 . 30 . 2011 "AT" 102 4310 83 146626982 9792892 31.86 31.76 31.68 -1155127 203169 18992 1.63 "AT0000606306" 3 18795 18795 3 . 31 . 2011 "AT" 102 4310 83 146626982 9792892 32.49 32.62 32.61 -1155127 203169 18992 1.63 "AT0000606306" 3 18798 18798 3 . 32 . 2011 "AT" 102 4310 83 146626982 9792892 32.13 32.19 32.1 -1155127 203169 18992 1.63 "AT0000606306" 3 18799 18799 3 . 33 . 2011 "AT" 102 4310 83 146626982 9792892 33.23 33.23 33.18 -1155127 203169 18992 1.63 "AT0000606306" 3 18800 18800 3 . 34 . 2011 "AT" 102 4310 83 146626982 9792892 32.8 32.96 32.87 -1155127 203169 18992 1.63 "AT0000606306" 3 18801 18801 3 . 35 . 2011 "AT" 102 4310 83 146626982 9792892 32.8 . . -1155127 203169 18992 1.63 "AT0000606306" 3 18802 18802 3 . 36 . 2011 "AT" 102 4310 83 146626982 9792892 31.37 32.53 32.45 -1155127 203169 18992 1.63 "AT0000606306" 3 18805 18805 3 . 37 . 2011 "AT" 102 4310 83 146626982 9792892 31.15 31.31 31.24 -1155127 203169 18992 1.63 "AT0000606306" 3 18806 18806 3 . 38 . 2011 "AT" 102 4310 83 146626982 9792892 32.12 32.08 32.01 -1155127 203169 18992 1.63 "AT0000606306" 3 18807 18807 3 . 39 . 2011 "AT" 102 4310 83 146626982 9792892 33.08 32.98 32.9 -1155127 203169 18992 1.63 "AT0000606306" 3 18808 18808 3 . 40 . 2011 "AT" 102 4310 83 146626982 9792892 34.03 33.99 33.92 -1155127 203169 18992 1.63 "AT0000606306" 3 18809 18809 3 . 41 . 2011 "AT" 102 4310 83 146626982 9792892 35.43 35.36 35.34 -1155127 203169 18992 1.63 "AT0000606306" 3 18812 18812 3 . 42 . 2011 "AT" 102 4310 83 146626982 9792892 35.16 35.14 35.12 -1155127 203169 18992 1.63 "AT0000606306" 3 18813 18813 3 . 43 . 2011 "AT" 102 4310 83 146626982 9792892 34.95 34.89 34.82 -1155127 203169 18992 1.63 "AT0000606306" 3 18814 18814 3 . 44 . 2011 "AT" 102 4310 83 146626982 9792892 34.04 34.16 34.05 -1155127 203169 18992 1.63 "AT0000606306" 3 18815 18815 3 . 45 . 2011 "AT" 102 4310 83 146626982 9792892 33.94 34.11 33.91 -1155127 203169 18992 1.63 "AT0000606306" 3 18816 18816 3 . 46 . 2011 "AT" 102 4310 83 146626982 9792892 33.82 34.16 33.81 -1155127 203169 18992 1.63 "AT0000606306" 3 18819 18819 3 . 47 . 2011 "AT" 102 4310 83 146626982 9792892 32.25 32.33 32.21 -1155127 203169 18992 1.63 "AT0000606306" 3 18820 18820 3 . 48 . 2011 "AT" 102 4310 83 146626982 9792892 32.36 32.22 32.16 -1155127 203169 18992 1.63 "AT0000606306" 3 18821 18821 3 . 49 . 2011 "AT" 102 4310 83 146626982 9792892 32.34 32.34 32.26 -1155127 203169 18992 1.63 "AT0000606306" 3 18822 18822 3 . 50 . 2011 "AT" 102 4310 83 146626982 9792892 32.06 32.17 32.16 -1155127 203169 18992 1.63 "AT0000606306" 3 18823 18823 3 . 51 . 2011 "AT" 102 4310 83 146626982 9792892 31.89 32.13 31.95 -1155127 203169 18992 1.63 "AT0000606306" 3 18826 18826 3 . 52 . 2011 "AT" 102 4310 83 146626982 9792892 31.16 31.36 31.24 -1155127 203169 18992 1.63 "AT0000606306" 3 18827 18827 3 . 53 . 2011 "AT" 102 4310 83 146626982 9792892 32.12 32.34 32.24 -1155127 203169 18992 1.63 "AT0000606306" 3 18828 18828 3 . 54 . 2011 "AT" 102 4310 83 146626982 9792892 32.7 32.7 32.55 -1155127 203169 18992 1.63 "AT0000606306" 3 18829 18829 3 . 55 . 2011 "AT" 102 4310 83 146626982 9792892 34.75 34.69 34.53 -1155127 203169 18992 1.63 "AT0000606306" 3 18830 18830 3 . 56 . 2011 "AT" 102 4310 83 146626982 9792892 34.81 34.86 34.79 -1155127 203169 18992 1.63 "AT0000606306" 3 18833 18833 3 . 57 . 2011 "AT" 102 4310 83 146626982 9792892 33.98 34.24 34.2 -1155127 203169 18992 1.63 "AT0000606306" 3 18834 18834 3 . 58 . 2011 "AT" 102 4310 83 146626982 9792892 33.98 33.97 33.95 -1155127 203169 18992 1.63 "AT0000606306" 3 18835 18835 3 . 59 . 2011 "AT" 102 4310 83 146626982 9792892 33.59 33.87 33.76 -1155127 203169 18992 1.63 "AT0000606306" 3 18836 18836 3 . 60 . 2011 "AT" 102 4310 83 146626982 9792892 33.52 33.61 33.44 -1155127 203169 18992 1.63 "AT0000606306" 3 18837 18837 3 . 61 . 2011 "AT" 102 4310 83 146626982 9792892 33.45 33.42 33.27 -1155127 203169 18992 1.63 "AT0000606306" 3 18840 18840 3 . 62 . 2011 "AT" 102 4310 83 146626982 9792892 32.43 32.56 32.47 -1155127 203169 18992 1.63 "AT0000606306" 3 18841 18841 3 . 63 . 2011 "AT" 102 4310 83 146626982 9792892 30.97 31.15 31.12 -1155127 203169 18992 1.63 "AT0000606306" 3 18842 18842 3 . 64 . 2011 "AT" 102 4310 83 146626982 9792892 30.76 30.84 30.83 -1155127 203169 18992 1.63 "AT0000606306" 3 18843 18843 3 . 65 . 2011 "AT" 102 4310 83 146626982 9792892 29.96 30.04 29.86 -1155127 203169 18992 1.63 "AT0000606306" 3 18844 18844 3 . 66 . 2011 "AT" 102 4310 83 146626982 9792892 28.85 29.26 28.86 -1155127 203169 18992 1.63 "AT0000606306" 3 18847 18847 3 . 67 . 2011 "AT" 102 4310 83 146626982 9792892 27.29 27.55 27.53 -1155127 203169 18992 1.63 "AT0000606306" 3 18848 18848 3 . 68 . 2011 "AT" 102 4310 83 146626982 9792892 27.09 27.48 27.36 -1155127 203169 18992 1.63 "AT0000606306" 3 18849 18849 3 . 69 . 2011 "AT" 102 4310 83 146626982 9792892 25.5 25.62 25.55 -1155127 203169 18992 1.63 "AT0000606306" 3 18850 18850 3 . 70 . 2011 "AT" 102 4310 83 146626982 9792892 26.39 26.35 26.07 -1155127 203169 18992 1.63 "AT0000606306" 3 18851 18851 3 . 71 . 2011 "AT" 102 4310 83 146626982 9792892 27.6 27.45 27.45 -1155127 203169 18992 1.63 "AT0000606306" 3 18854 18854 3 . 72 . 2011 "AT" 102 4310 83 146626982 9792892 27.6 . . -1155127 203169 18992 1.63 "AT0000606306" 3 18855 18855 3 . 73 . 2011 "AT" 102 4310 83 146626982 9792892 27.39 27.39 27.3 -1155127 203169 18992 1.63 "AT0000606306" 3 end format %tdDD/NN/CCYY date format %tdDD/NN/CCYY fperiod
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int year double(bsize bstr govp envp mtb mvalue socp rev inc lond) float(c_id date timevar) str12 isin 2329 12 .06 25.73 56.81 2.15 680.44 74.24 798043 25273 168490 2 21655 21655 "AT00000FACC2" 2330 12 .06 25.73 56.81 2.16 682.73 74.24 798043 25273 168490 2 21656 21656 "AT00000FACC2" 2331 12 .06 25.73 56.81 2.15 679.07 74.24 798043 25273 168490 2 21657 21657 "AT00000FACC2" 2332 12 .06 25.73 56.81 2.15 679.07 74.24 798043 25273 168490 2 21658 21658 "AT00000FACC2" 2333 12 .06 25.73 56.81 2.15 679.07 74.24 798043 25273 168490 2 21661 21661 "AT00000FACC2" 2334 12 .06 25.73 56.81 2.15 679.98 74.24 798043 25273 168490 2 21662 21662 "AT00000FACC2" 2335 12 .06 25.73 56.81 2.18 687.77 74.24 798043 25273 168490 2 21663 21663 "AT00000FACC2" 2336 12 .06 25.73 56.81 2.16 684.1 74.24 798043 25273 168490 2 21664 21664 "AT00000FACC2" 2337 12 .06 25.73 56.81 2.14 677.69 74.24 798043 25273 168490 2 21665 21665 "AT00000FACC2" 2338 12 .06 25.73 56.81 2.19 691.43 74.24 798043 25273 168490 2 21668 21668 "AT00000FACC2" 2339 12 .06 25.73 56.81 2.12 669.45 74.24 798043 25273 168490 2 21669 21669 "AT00000FACC2" 2340 12 .06 25.73 56.81 2.12 669.45 74.24 798043 25273 168490 2 21670 21670 "AT00000FACC2" 2341 12 .06 25.73 56.81 2.07 654.8 74.24 798043 25273 168490 2 21671 21671 "AT00000FACC2" 2342 12 .06 25.73 56.81 2.04 646.1 74.24 798043 25273 168490 2 21672 21672 "AT00000FACC2" 2343 12 .06 25.73 56.81 2.04 644.72 74.24 798043 25273 168490 2 21675 21675 "AT00000FACC2" 2344 12 .06 25.73 56.81 1.99 629.15 74.24 798043 25273 168490 2 21676 21676 "AT00000FACC2" 2345 12 .06 25.73 56.81 2.03 640.6 74.24 798043 25273 168490 2 21677 21677 "AT00000FACC2" 2346 12 .06 25.73 56.81 1.96 620.91 74.24 798043 25273 168490 2 21678 21678 "AT00000FACC2" 2347 12 .06 25.73 56.81 1.98 626.41 74.24 798043 25273 168490 2 21679 21679 "AT00000FACC2" 2348 12 .06 25.73 56.81 1.94 613.13 74.24 798043 25273 168490 2 21682 21682 "AT00000FACC2" 2 16 .95 38.38 44.75 .79 5413.36 64.09 9581409 1087475 24160674 3 18396 18396 "AT0000606306" 3 16 .95 38.38 44.75 .77 5233.95 64.09 9581409 1087475 24160674 3 18399 18399 "AT0000606306" 4 16 .95 38.38 44.75 .79 5400.99 64.09 9581409 1087475 24160674 3 18400 18400 "AT0000606306" 5 16 .95 38.38 44.75 .78 5351.49 64.09 9581409 1087475 24160674 3 18401 18401 "AT0000606306" 6 16 .95 38.38 44.75 .76 5195.28 64.09 9581409 1087475 24160674 3 18402 18402 "AT0000606306" 7 16 .95 38.38 44.75 .78 5311.28 64.09 9581409 1087475 24160674 3 18403 18403 "AT0000606306" 8 16 .95 38.38 44.75 .78 5311.28 64.09 9581409 1087475 24160674 3 18406 18406 "AT0000606306" 9 16 .95 38.38 44.75 .73 4986.48 64.09 9581409 1087475 24160674 3 18407 18407 "AT0000606306" 10 16 .95 38.38 44.75 .75 5134.96 64.09 9581409 1087475 24160674 3 18408 18408 "AT0000606306" 11 16 .95 38.38 44.75 .79 5394.8 64.09 9581409 1087475 24160674 3 18409 18409 "AT0000606306" 12 16 .95 38.38 44.75 .79 5411.81 64.09 9581409 1087475 24160674 3 18410 18410 "AT0000606306" 13 16 .95 38.38 44.75 .79 5428.83 64.09 9581409 1087475 24160674 3 18413 18413 "AT0000606306" 14 16 .95 38.38 44.75 .77 5280.35 64.09 9581409 1087475 24160674 3 18414 18414 "AT0000606306" 15 16 .95 38.38 44.75 .77 5255.6 64.09 9581409 1087475 24160674 3 18415 18415 "AT0000606306" 16 16 .95 38.38 44.75 .77 5255.6 64.09 9581409 1087475 24160674 3 18416 18416 "AT0000606306" 17 16 .95 38.38 44.75 .7 4817.89 64.09 9581409 1087475 24160674 3 18417 18417 "AT0000606306" 18 16 .95 38.38 44.75 .69 4725.09 64.09 9581409 1087475 24160674 3 18420 18420 "AT0000606306" 19 16 .95 38.38 44.75 .68 4669.41 64.09 9581409 1087475 24160674 3 18421 18421 "AT0000606306" 20 16 .95 38.38 44.75 .7 4802.42 64.09 9581409 1087475 24160674 3 18422 18422 "AT0000606306" 21 16 .95 38.38 44.75 .74 5026.7 64.09 9581409 1087475 24160674 3 18423 18423 "AT0000606306" 22 16 .95 38.38 44.75 .74 5063.81 64.09 9581409 1087475 24160674 3 18424 18424 "AT0000606306" 23 16 .95 38.38 44.75 .76 5165.89 64.09 9581409 1087475 24160674 3 18427 18427 "AT0000606306" 24 16 .95 38.38 44.75 .75 5162.8 64.09 9581409 1087475 24160674 3 18428 18428 "AT0000606306" 25 16 .95 38.38 44.75 .74 5034.43 64.09 9581409 1087475 24160674 3 18429 18429 "AT0000606306" 26 16 .95 38.38 44.75 .75 5116.4 64.09 9581409 1087475 24160674 3 18430 18430 "AT0000606306" 27 16 .95 38.38 44.75 .78 5305.09 64.09 9581409 1087475 24160674 3 18431 18431 "AT0000606306" 28 16 .95 38.38 44.75 .8 5436.56 64.09 9581409 1087475 24160674 3 18434 18434 "AT0000606306" 29 16 .95 38.38 44.75 .8 5444.29 64.09 9581409 1087475 24160674 3 18435 18435 "AT0000606306" 30 16 .95 38.38 44.75 .79 5387.07 64.09 9581409 1087475 24160674 3 18436 18436 "AT0000606306" 31 16 .95 38.38 44.75 .76 5204.56 64.09 9581409 1087475 24160674 3 18437 18437 "AT0000606306" 32 16 .95 38.38 44.75 .75 5114.85 64.09 9581409 1087475 24160674 3 18438 18438 "AT0000606306" 33 16 .95 38.38 44.75 .76 5226.98 64.09 9581409 1087475 24160674 3 18441 18441 "AT0000606306" 34 16 .95 38.38 44.75 .74 5070 64.09 9581409 1087475 24160674 3 18442 18442 "AT0000606306" 35 16 .95 38.38 44.75 .71 4870.48 64.09 9581409 1087475 24160674 3 18443 18443 "AT0000606306" 36 16 .95 38.38 44.75 .67 4593.63 64.09 9581409 1087475 24160674 3 18444 18444 "AT0000606306" 37 16 .95 38.38 44.75 .66 4486.13 64.09 9581409 1087475 24160674 3 18445 18445 "AT0000606306" 38 16 .95 38.38 44.75 .66 4502.37 64.09 9581409 1087475 24160674 3 18448 18448 "AT0000606306" 39 16 .95 38.38 44.75 .67 4562.69 64.09 9581409 1087475 24160674 3 18449 18449 "AT0000606306" 40 16 .95 38.38 44.75 .7 4796.24 64.09 9581409 1087475 24160674 3 18450 18450 "AT0000606306" 41 16 .95 38.38 44.75 .72 4931.57 64.09 9581409 1087475 24160674 3 18451 18451 "AT0000606306" 42 16 .95 38.38 44.75 .72 4940.07 64.09 9581409 1087475 24160674 3 18452 18452 "AT0000606306" 43 16 .95 38.38 44.75 .71 4887.49 64.09 9581409 1087475 24160674 3 18455 18455 "AT0000606306" 44 16 .95 38.38 44.75 .74 5071.55 64.09 9581409 1087475 24160674 3 18456 18456 "AT0000606306" 45 16 .95 38.38 44.75 .74 5051.44 64.09 9581409 1087475 24160674 3 18457 18457 "AT0000606306" 46 16 .95 38.38 44.75 .75 5104.03 64.09 9581409 1087475 24160674 3 18458 18458 "AT0000606306" 47 16 .95 38.38 44.75 .72 4926.16 64.09 9581409 1087475 24160674 3 18459 18459 "AT0000606306" 48 16 .95 38.38 44.75 .7 4769.95 64.09 9581409 1087475 24160674 3 18462 18462 "AT0000606306" 49 16 .95 38.38 44.75 .69 4750.61 64.09 9581409 1087475 24160674 3 18463 18463 "AT0000606306" 50 16 .95 38.38 44.75 .72 4957.09 64.09 9581409 1087475 24160674 3 18464 18464 "AT0000606306" 51 16 .95 38.38 44.75 .76 5175.17 64.09 9581409 1087475 24160674 3 18465 18465 "AT0000606306" 52 16 .95 38.38 44.75 .74 5090.88 64.09 9581409 1087475 24160674 3 18466 18466 "AT0000606306" 53 16 .95 38.38 44.75 .78 5337.57 64.09 9581409 1087475 24160674 3 18469 18469 "AT0000606306" 54 16 .95 38.38 44.75 .82 5583.49 64.09 9581409 1087475 24160674 3 18470 18470 "AT0000606306" 55 16 .95 38.38 44.75 .8 5472.13 64.09 9581409 1087475 24160674 3 18471 18471 "AT0000606306" 56 16 .95 38.38 44.75 .81 5529.36 64.09 9581409 1087475 24160674 3 18472 18472 "AT0000606306" 57 16 .95 38.38 44.75 .79 5394.8 64.09 9581409 1087475 24160674 3 18473 18473 "AT0000606306" 58 16 .95 38.38 44.75 .82 5641.5 64.09 9581409 1087475 24160674 3 18476 18476 "AT0000606306" 59 16 .95 38.38 44.75 .83 5645.36 64.09 9581409 1087475 24160674 3 18477 18477 "AT0000606306" 60 16 .95 38.38 44.75 .83 5642.27 64.09 9581409 1087475 24160674 3 18478 18478 "AT0000606306" 61 16 .95 38.38 44.75 .81 5568.8 64.09 9581409 1087475 24160674 3 18479 18479 "AT0000606306" 62 16 .95 38.38 44.75 .79 5382.43 64.09 9581409 1087475 24160674 3 18480 18480 "AT0000606306" 63 16 .95 38.38 44.75 .8 5444.29 64.09 9581409 1087475 24160674 3 18483 18483 "AT0000606306" 64 16 .95 38.38 44.75 .78 5302 64.09 9581409 1087475 24160674 3 18484 18484 "AT0000606306" 65 16 .95 38.38 44.75 .75 5151.2 64.09 9581409 1087475 24160674 3 18485 18485 "AT0000606306" 66 16 .95 38.38 44.75 .74 5032.88 64.09 9581409 1087475 24160674 3 18486 18486 "AT0000606306" 67 16 .95 38.38 44.75 .75 5107.89 64.09 9581409 1087475 24160674 3 18487 18487 "AT0000606306" 68 16 .95 38.38 44.75 .76 5165.89 64.09 9581409 1087475 24160674 3 18490 18490 "AT0000606306" 69 16 .95 38.38 44.75 .8 5444.29 64.09 9581409 1087475 24160674 3 18491 18491 "AT0000606306" 70 16 .95 38.38 44.75 .78 5351.49 64.09 9581409 1087475 24160674 3 18492 18492 "AT0000606306" 71 16 .95 38.38 44.75 .76 5225.44 64.09 9581409 1087475 24160674 3 18493 18493 "AT0000606306" 72 16 .95 38.38 44.75 .76 5181.36 64.09 9581409 1087475 24160674 3 18494 18494 "AT0000606306" 73 16 .95 38.38 44.75 .77 5258.7 64.09 9581409 1087475 24160674 3 18497 18497 "AT0000606306" 74 16 .95 38.38 44.75 .75 5094.74 64.09 9581409 1087475 24160674 3 18498 18498 "AT0000606306" 75 16 .95 38.38 44.75 .72 4946.26 64.09 9581409 1087475 24160674 3 18499 18499 "AT0000606306" 76 16 .95 38.38 44.75 .74 5077.73 64.09 9581409 1087475 24160674 3 18500 18500 "AT0000606306" 77 16 .95 38.38 44.75 .73 4974.88 64.09 9581409 1087475 24160674 3 18501 18501 "AT0000606306" 78 16 .95 38.38 44.75 .75 5111.76 64.09 9581409 1087475 24160674 3 18504 18504 "AT0000606306" 79 16 .95 38.38 44.75 .73 4988.02 64.09 9581409 1087475 24160674 3 18505 18505 "AT0000606306" 80 16 .95 38.38 44.75 .75 5130.32 64.09 9581409 1087475 24160674 3 18506 18506 "AT0000606306" 81 16 .95 38.38 44.75 .75 5097.84 64.09 9581409 1087475 24160674 3 18507 18507 "AT0000606306" end format %tdDD/NN/CCYY date
The c_id variable as well as the isin variable are the same for both datasets. What could be the underlying problem?
Many thanks!
0 Response to Merge variables do not uniquely identify observations in the using data
Post a Comment