[Andres Henriquez]

Thank you Clyde! Now I have the last issue: I need to merge this last gdg data base with other one. The prblem is that the structure of the data bases are different. This is the new one:
dataex ccode country year flag d1 A_dem_1800_to_1925

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input double ccode str31 country double year byte flag float(d1 A_dem_1800_to_1925)
2 "United States" 1800 0 1 126
2 "United States" 1801 0 1 126
2 "United States" 1802 0 1 126
2 "United States" 1803 0 1 126
2 "United States" 1804 0 1 126
2 "United States" 1805 0 1 126
2 "United States" 1806 0 1 126
2 "United States" 1807 0 1 126
2 "United States" 1808 0 1 126
2 "United States" 1809 0 1 126
2 "United States" 1810 0 1 126
2 "United States" 1811 0 1 126
2 "United States" 1812 0 1 126
2 "United States" 1813 0 1 126
2 "United States" 1814 0 1 126
2 "United States" 1815 0 1 126
2 "United States" 1816 0 1 126
2 "United States" 1817 0 1 126
2 "United States" 1818 0 1 126
2 "United States" 1819 0 1 126
2 "United States" 1820 0 1 126
2 "United States" 1821 0 1 126
2 "United States" 1822 0 1 126
2 "United States" 1823 0 1 126
2 "United States" 1824 0 1 126
2 "United States" 1825 0 1 126
2 "United States" 1826 0 1 126
2 "United States" 1827 0 1 126
2 "United States" 1828 0 1 126
2 "United States" 1829 0 1 126
2 "United States" 1830 0 1 126
2 "United States" 1831 0 1 126
2 "United States" 1832 0 1 126
2 "United States" 1833 0 1 126
2 "United States" 1834 0 1 126
2 "United States" 1835 0 1 126
2 "United States" 1836 0 1 126
2 "United States" 1837 0 1 126
2 "United States" 1838 0 1 126
2 "United States" 1839 0 1 126
2 "United States" 1840 0 1 126
2 "United States" 1841 0 1 126
2 "United States" 1842 0 1 126
2 "United States" 1843 0 1 126
2 "United States" 1844 0 1 126
2 "United States" 1845 0 1 126
2 "United States" 1846 0 1 126
2 "United States" 1847 0 1 126
2 "United States" 1848 0 1 126
2 "United States" 1849 0 1 126
2 "United States" 1850 0 1 126
2 "United States" 1851 0 1 126
2 "United States" 1852 0 1 126
2 "United States" 1853 0 1 126
2 "United States" 1854 0 1 126
2 "United States" 1855 0 1 126
2 "United States" 1856 0 1 126
2 "United States" 1857 0 1 126
2 "United States" 1858 0 1 126
2 "United States" 1859 0 1 126
2 "United States" 1860 0 1 126
2 "United States" 1861 0 1 126
2 "United States" 1862 0 1 126
2 "United States" 1863 0 1 126
2 "United States" 1864 0 1 126
2 "United States" 1865 0 1 126
2 "United States" 1866 0 1 126
2 "United States" 1867 0 1 126
2 "United States" 1868 0 1 126
2 "United States" 1869 0 1 126
2 "United States" 1870 0 1 126
2 "United States" 1871 0 1 126
2 "United States" 1872 0 1 126
2 "United States" 1873 0 1 126
2 "United States" 1874 0 1 126
2 "United States" 1875 0 1 126
2 "United States" 1876 0 1 126
2 "United States" 1877 0 1 126
2 "United States" 1878 0 1 126
2 "United States" 1879 0 1 126
2 "United States" 1880 0 1 126
2 "United States" 1881 0 1 126
2 "United States" 1882 0 1 126
2 "United States" 1883 0 1 126
2 "United States" 1884 0 1 126
2 "United States" 1885 0 1 126
2 "United States" 1886 0 1 126
2 "United States" 1887 0 1 126
2 "United States" 1888 0 1 126
2 "United States" 1889 0 1 126
2 "United States" 1890 0 1 126
2 "United States" 1891 0 1 126
2 "United States" 1892 0 1 126
2 "United States" 1893 0 1 126
2 "United States" 1894 0 1 126
2 "United States" 1895 0 1 126
2 "United States" 1896 0 1 126
2 "United States" 1897 0 1 126
2 "United States" 1898 0 1 126
2 "United States" 1899 0 1 126
end

------------------ copy up to and including the previous line ------------------

Listed 100 out of 38698 observations
Use the count() option to list more
summarize

Variable | Obs Mean Std. dev. Min Max
-------------+---------------------------------------------------------
cyear | 16,727 4018799 2495545 21800 9502013
ccode | 38,698 1453.097 2699.1 2 10259
scode | 0
country | 0
year | 38,698 1915.113 57.24906 1800 2013
-------------+---------------------------------------------------------
flag | 16,594 .0066892 .1000986 0 2
fragment | 2,385 .2067086 .6796085 0 3
democ | 16,727 -.2173133 17.5181 -88 10
autoc | 16,727 .4301429 17.5824 -88 10
polity | 16,727 -4.181503 17.68473 -88 10
-------------+---------------------------------------------------------
polity2 | 16,491 -.6855861 7.058427 -10 10
durable | 15,463 21.33836 25.81865 0 204
xrreg | 16,727 -1.170861 16.90891 -88 3
xrcomp | 16,727 -2.020267 16.74468 -88 3
xropen | 16,727 -.7778442 17.04868 -88 4
-------------+---------------------------------------------------------
xconst | 16,727 .0457344 17.31937 -88 7
parreg | 16,727 -.1661386 17.14362 -88 5
parcomp | 16,727 -1.009984 16.99311 -88 5
exrec | 16,526 .8125983 17.63531 -88 8
exconst | 16,727 .0457942 17.31939 -88 7
-------------+---------------------------------------------------------
polcomp | 16,601 1.252515 17.79555 -88 10
prior | 1,298 -1.083975 9.918552 -10 99
emonth | 1,353 6.742055 3.354871 1 12
eday | 1,353 16.78271 9.270672 1 31
eyear | 1,353 1953.944 58.7256 1801 3013
-------------+---------------------------------------------------------
eprec | 1,352 1.734467 2.73742 -77 9
interim | 1,159 -65.4038 31.26831 -88 8
bmonth | 1,210 6.609091 3.369215 1 12
bday | 1,210 13.58678 9.617816 1 31
byear | 1,210 1949.55 56.60526 1800 2013
-------------+---------------------------------------------------------
bprec | 1,210 1.734711 1.684317 0 9
post | 1,197 -1.263993 10.22754 -88 98
change | 2,057 -2.929509 46.11974 -77 99
d4 | 1,224 1 0 1 1
sf | 246 1 0 1 1
-------------+---------------------------------------------------------
regtrans | 2,058 -3.990768 44.97424 -77 99
d1 | 16,491 .4057365 .4910489 0 1
A_dem_1~1925 | 16,727 17.46978 28.08452 0 126
A_dem_1~1950 | 16,727 24.25253 35.02112 0 151
A_dem_1~1975 | 16,727 32.78944 42.11843 0 176
-------------+---------------------------------------------------------
A_dem_1~1997 | 16,727 43.53482 48.49193 0 198
A_dem_1~2000 | 16,727 45.57028 49.18633 0 201
abbreviation | 0
sovereign | 18,049 .8912405 .3113458 0 1
cyear_pol~07 | 15,512 4000387 2505869 21800 9502007
-------------+---------------------------------------------------------
ccode_pol~07 | 15,512 399.8455 250.5857 2 950
scode_pol~07 | 0
country_p~07 | 0
year_poli~07 | 15,512 1932.467 57.97188 1800 2007
flag_poli~07 | 15,512 .0197911 .169745 0 2
-------------+---------------------------------------------------------
fragment_~07 | 1,311 .2303585 .7217619 0 3
democ_pol~07 | 14,802 3.293204 3.838397 0 10
autoc_pol~07 | 14,802 4.349818 3.506195 0 10
polity_po~07 | 14,802 -1.056614 7.08944 -10 10
polity2_p~07 | 15,294 -1.055381 6.99994 -10 10
-------------+---------------------------------------------------------
durable_p~07 | 14,248 21.00512 25.43847 0 198
xrreg_pol~07 | 14,802 2.472774 .6625651 1 3
xrcomp_po~07 | 14,802 1.549115 1.04078 0 3
xropen_po~07 | 14,802 2.844075 1.557061 0 4
xconst_po~07 | 14,802 3.637076 2.405969 1 7
-------------+---------------------------------------------------------
parreg_po~07 | 14,802 3.543981 1.017576 1 5
parcomp_p~07 | 14,802 2.582219 1.469286 0 5
exrec_pol~07 | 14,654 4.464583 2.706321 1 8
exconst_p~07 | 14,802 3.637076 2.405969 1 7
polcomp_p~07 | 14,716 4.890052 3.34654 1 10
-------------+---------------------------------------------------------
imfcode | 15,532 99.02273 57.14684 1 301
democracy | 17,157 .2775544 .4478053 0 1
typeii_error | 14,931 .0523743 .2227881 0 1
dummy_pol~07 | 37,532 .701588 .4575673 0 1
normalpol~07 | 14,802 .4471693 .354472 0 1
-------------+---------------------------------------------------------
chnormalp~07 | 14,410 .0007217 .0663758 -.95 .8
max10norm~07 | 15,385 .4710205 .3515767 0 1
min10norm~07 | 15,385 .3931687 .3454384 0 1
democracy_~s | 17,091 .0035691 .115195 -1 1
democracy_~e | 17,157 44.49904 42.93431 1 208
-------------+---------------------------------------------------------
B_dem_1~1925 | 37,539 4.350196 15.05304 0 126
B_dem_1~1950 | 37,539 7.226644 20.69391 0 151
B_dem_1~1975 | 37,539 12.08865 27.28657 0 176
B_dem_1~1997 | 37,539 19.37476 33.30013 0 198
B_dem_1~2000 | 37,539 20.79493 34.08461 0 201
-------------+---------------------------------------------------------
_merge | 38,698 2.372345 .5418593 1 3

.
end of do-file

[Andres Henriquez]

Thank you Clyde! Now I have the last issue: I need to merge this last gdg data base with other one. The prblem is that the structure of the data bases are different. This is the new one:
dataex ccode country year flag d1 A_dem_1800_to_1925

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input double ccode str31 country double year byte flag float(d1 A_dem_1800_to_1925)
2 "United States" 1800 0 1 126
2 "United States" 1801 0 1 126
2 "United States" 1802 0 1 126
2 "United States" 1803 0 1 126
2 "United States" 1804 0 1 126
2 "United States" 1805 0 1 126
2 "United States" 1806 0 1 126
2 "United States" 1807 0 1 126
2 "United States" 1808 0 1 126
2 "United States" 1809 0 1 126
2 "United States" 1810 0 1 126
2 "United States" 1811 0 1 126
2 "United States" 1812 0 1 126
2 "United States" 1813 0 1 126
2 "United States" 1814 0 1 126
2 "United States" 1815 0 1 126
2 "United States" 1816 0 1 126
2 "United States" 1817 0 1 126
2 "United States" 1818 0 1 126
2 "United States" 1819 0 1 126
2 "United States" 1820 0 1 126
2 "United States" 1821 0 1 126
2 "United States" 1822 0 1 126
2 "United States" 1823 0 1 126
2 "United States" 1824 0 1 126
2 "United States" 1825 0 1 126
2 "United States" 1826 0 1 126
2 "United States" 1827 0 1 126
2 "United States" 1828 0 1 126
2 "United States" 1829 0 1 126
2 "United States" 1830 0 1 126
2 "United States" 1831 0 1 126
2 "United States" 1832 0 1 126
2 "United States" 1833 0 1 126
2 "United States" 1834 0 1 126
2 "United States" 1835 0 1 126
2 "United States" 1836 0 1 126
2 "United States" 1837 0 1 126
2 "United States" 1838 0 1 126
2 "United States" 1839 0 1 126
2 "United States" 1840 0 1 126
2 "United States" 1841 0 1 126
2 "United States" 1842 0 1 126
2 "United States" 1843 0 1 126
2 "United States" 1844 0 1 126
2 "United States" 1845 0 1 126
2 "United States" 1846 0 1 126
2 "United States" 1847 0 1 126
2 "United States" 1848 0 1 126
2 "United States" 1849 0 1 126
2 "United States" 1850 0 1 126
2 "United States" 1851 0 1 126
2 "United States" 1852 0 1 126
2 "United States" 1853 0 1 126
2 "United States" 1854 0 1 126
2 "United States" 1855 0 1 126
2 "United States" 1856 0 1 126
2 "United States" 1857 0 1 126
2 "United States" 1858 0 1 126
2 "United States" 1859 0 1 126
2 "United States" 1860 0 1 126
2 "United States" 1861 0 1 126
2 "United States" 1862 0 1 126
2 "United States" 1863 0 1 126
2 "United States" 1864 0 1 126
2 "United States" 1865 0 1 126
2 "United States" 1866 0 1 126
2 "United States" 1867 0 1 126
2 "United States" 1868 0 1 126
2 "United States" 1869 0 1 126
2 "United States" 1870 0 1 126
2 "United States" 1871 0 1 126
2 "United States" 1872 0 1 126
2 "United States" 1873 0 1 126
2 "United States" 1874 0 1 126
2 "United States" 1875 0 1 126
2 "United States" 1876 0 1 126
2 "United States" 1877 0 1 126
2 "United States" 1878 0 1 126
2 "United States" 1879 0 1 126
2 "United States" 1880 0 1 126
2 "United States" 1881 0 1 126
2 "United States" 1882 0 1 126
2 "United States" 1883 0 1 126
2 "United States" 1884 0 1 126
2 "United States" 1885 0 1 126
2 "United States" 1886 0 1 126
2 "United States" 1887 0 1 126
2 "United States" 1888 0 1 126
2 "United States" 1889 0 1 126
2 "United States" 1890 0 1 126
2 "United States" 1891 0 1 126
2 "United States" 1892 0 1 126
2 "United States" 1893 0 1 126
2 "United States" 1894 0 1 126
2 "United States" 1895 0 1 126
2 "United States" 1896 0 1 126
2 "United States" 1897 0 1 126
2 "United States" 1898 0 1 126
2 "United States" 1899 0 1 126
end

------------------ copy up to and including the previous line ------------------

Listed 100 out of 38698 observations
Use the count() option to list more
summarize

Variable | Obs Mean Std. dev. Min Max
-------------+---------------------------------------------------------
cyear | 16,727 4018799 2495545 21800 9502013
ccode | 38,698 1453.097 2699.1 2 10259
scode | 0
country | 0
year | 38,698 1915.113 57.24906 1800 2013
-------------+---------------------------------------------------------
flag | 16,594 .0066892 .1000986 0 2
fragment | 2,385 .2067086 .6796085 0 3
democ | 16,727 -.2173133 17.5181 -88 10
autoc | 16,727 .4301429 17.5824 -88 10
polity | 16,727 -4.181503 17.68473 -88 10
-------------+---------------------------------------------------------
polity2 | 16,491 -.6855861 7.058427 -10 10
durable | 15,463 21.33836 25.81865 0 204
xrreg | 16,727 -1.170861 16.90891 -88 3
xrcomp | 16,727 -2.020267 16.74468 -88 3
xropen | 16,727 -.7778442 17.04868 -88 4
-------------+---------------------------------------------------------
xconst | 16,727 .0457344 17.31937 -88 7
parreg | 16,727 -.1661386 17.14362 -88 5
parcomp | 16,727 -1.009984 16.99311 -88 5
exrec | 16,526 .8125983 17.63531 -88 8
exconst | 16,727 .0457942 17.31939 -88 7
-------------+---------------------------------------------------------
polcomp | 16,601 1.252515 17.79555 -88 10
prior | 1,298 -1.083975 9.918552 -10 99
emonth | 1,353 6.742055 3.354871 1 12
eday | 1,353 16.78271 9.270672 1 31
eyear | 1,353 1953.944 58.7256 1801 3013
-------------+---------------------------------------------------------
eprec | 1,352 1.734467 2.73742 -77 9
interim | 1,159 -65.4038 31.26831 -88 8
bmonth | 1,210 6.609091 3.369215 1 12
bday | 1,210 13.58678 9.617816 1 31
byear | 1,210 1949.55 56.60526 1800 2013
-------------+---------------------------------------------------------
bprec | 1,210 1.734711 1.684317 0 9
post | 1,197 -1.263993 10.22754 -88 98
change | 2,057 -2.929509 46.11974 -77 99
d4 | 1,224 1 0 1 1
sf | 246 1 0 1 1
-------------+---------------------------------------------------------
regtrans | 2,058 -3.990768 44.97424 -77 99
d1 | 16,491 .4057365 .4910489 0 1
A_dem_1~1925 | 16,727 17.46978 28.08452 0 126
A_dem_1~1950 | 16,727 24.25253 35.02112 0 151
A_dem_1~1975 | 16,727 32.78944 42.11843 0 176
-------------+---------------------------------------------------------
A_dem_1~1997 | 16,727 43.53482 48.49193 0 198
A_dem_1~2000 | 16,727 45.57028 49.18633 0 201
abbreviation | 0
sovereign | 18,049 .8912405 .3113458 0 1
cyear_pol~07 | 15,512 4000387 2505869 21800 9502007
-------------+---------------------------------------------------------
ccode_pol~07 | 15,512 399.8455 250.5857 2 950
scode_pol~07 | 0
country_p~07 | 0
year_poli~07 | 15,512 1932.467 57.97188 1800 2007
flag_poli~07 | 15,512 .0197911 .169745 0 2
-------------+---------------------------------------------------------
fragment_~07 | 1,311 .2303585 .7217619 0 3
democ_pol~07 | 14,802 3.293204 3.838397 0 10
autoc_pol~07 | 14,802 4.349818 3.506195 0 10
polity_po~07 | 14,802 -1.056614 7.08944 -10 10
polity2_p~07 | 15,294 -1.055381 6.99994 -10 10
-------------+---------------------------------------------------------
durable_p~07 | 14,248 21.00512 25.43847 0 198
xrreg_pol~07 | 14,802 2.472774 .6625651 1 3
xrcomp_po~07 | 14,802 1.549115 1.04078 0 3
xropen_po~07 | 14,802 2.844075 1.557061 0 4
xconst_po~07 | 14,802 3.637076 2.405969 1 7
-------------+---------------------------------------------------------
parreg_po~07 | 14,802 3.543981 1.017576 1 5
parcomp_p~07 | 14,802 2.582219 1.469286 0 5
exrec_pol~07 | 14,654 4.464583 2.706321 1 8
exconst_p~07 | 14,802 3.637076 2.405969 1 7
polcomp_p~07 | 14,716 4.890052 3.34654 1 10
-------------+---------------------------------------------------------
imfcode | 15,532 99.02273 57.14684 1 301
democracy | 17,157 .2775544 .4478053 0 1
typeii_error | 14,931 .0523743 .2227881 0 1
dummy_pol~07 | 37,532 .701588 .4575673 0 1
normalpol~07 | 14,802 .4471693 .354472 0 1
-------------+---------------------------------------------------------
chnormalp~07 | 14,410 .0007217 .0663758 -.95 .8
max10norm~07 | 15,385 .4710205 .3515767 0 1
min10norm~07 | 15,385 .3931687 .3454384 0 1
democracy_~s | 17,091 .0035691 .115195 -1 1
democracy_~e | 17,157 44.49904 42.93431 1 208
-------------+---------------------------------------------------------
B_dem_1~1925 | 37,539 4.350196 15.05304 0 126
B_dem_1~1950 | 37,539 7.226644 20.69391 0 151
B_dem_1~1975 | 37,539 12.08865 27.28657 0 176
B_dem_1~1997 | 37,539 19.37476 33.30013 0 198
B_dem_1~2000 | 37,539 20.79493 34.08461 0 201
-------------+---------------------------------------------------------
_merge | 38,698 2.372345 .5418593 1 3

.
end of do-file

[Clyde Schechter]

The prblem is that the structure of the data bases are different.

That is precisely the point I was making: you need to put these two data bases together, and to do that, you have to get the GDP data into the long layout that is similar to the democracy data. That's why I encouraged you to do the -reshape- before log-transforming the GDP's.

If you follow the advice I gave you in #12 and fix the errors in your data set, then you will be able to run the code in #3. That will give you a data set that is compatible with the democracy data. You will be able to combine them with:

use democracy_data_set, clear
drop _merge
merge 1:1 country year using gdp_data_set_in_long_layout

The only trouble you may get into with this -merge- is if the naming of the countries is different in the two data sets. If one of them has "United States" and the other has "USA", then those won't match properly. So you need to check for that after you do the _merge. Make sure you identify any unmatched observations:

tab country year if _merge != 3

You may have to backtrack and fix up the country names in one of the data sets to get everything paired up properly.

Note, also, that the -merge- will fail, just as the -reshape- did if you do not fix the problem with duplicate observations for some combinations of country and year.