------------------------------------------------------------------------------- log: /disk/nber10/SCCS/mortality/1959-1967/ccr58_ccr60.log log type: text opened on: 27 Oct 2009, 14:49:30 . . **! unzip /homes/data/mortality/1959-1967/mort1961.dta.zip . **! unzip /homes/data/mortality/1959-1967/mort1962.dta.zip . *tempname ccr . *postfile `ccr' str120 dataset year str32 varname str32 value count using ccr > 59_1961, replace . **postfile `ccr' str120 dataset using ccr59_1961, replace . *local ds mort1961 . *use ucod ccr59 using mort1961.dta, clear . *levels ccr59, local(_59_list) . *foreach c in `_59_list' { . * qui tab ccr59 if ccr59==`c' . * post `ccr' ("`ds'") (1961) ("ccr59") ("`c'") (`r(N)') . * *post `ccr' ("`ds'") . *} . *postclose `ccr' . *postfile `ccr' str120 dataset year str32 varname str32 value count using ccr > 60_1962, replace . *use ucod ccr60 using mort1962.dta, clear . *levels ccr60, local(_60_list) . *foreach c in `_60_list' { . * qui tab ccr60 if ccr60==`c' . * post `ccr' ("mort1962") (1962) ("ccr60") ("`c'") (`r(N)') . *} . *postclose `ccr' . use ccr59_1961, clear . rename count count1961 . sort value . save ccr59_1961, replace file ccr59_1961.dta saved . use ccr60_1962, clear . rename count count1962 . sort value . save ccr60_1962, replace file ccr60_1962.dta saved . merge value using ccr59_1961 . list +------------------------------------------------------------------+ | dataset year varname value cou~1962 cou~1961 _merge | |------------------------------------------------------------------| 1. | mort1962 1962 ccr60 0 8792 . 1 | 2. | mort1962 1962 ccr60 1 714 9191 3 | 3. | mort1962 1962 ccr60 10 5791 434 3 | 4. | mort1962 1962 ccr60 11 6481 5606 3 | 5. | mort1962 1962 ccr60 12 92047 6322 3 | |------------------------------------------------------------------| 6. | mort1962 1962 ccr60 13 44644 91727 3 | 7. | mort1962 1962 ccr60 14 24958 42211 3 | 8. | mort1962 1962 ccr60 15 39590 24542 3 | 9. | mort1962 1962 ccr60 16 13299 39256 3 | 10. | mort1962 1962 ccr60 17 30791 13040 3 | |------------------------------------------------------------------| 11. | mort1962 1962 ccr60 18 12997 29977 3 | 12. | mort1962 1962 ccr60 19 13755 12873 3 | 13. | mort1962 1962 ccr60 2 2811 747 3 | 14. | mort1962 1962 ccr60 20 4681 13554 3 | 15. | mort1962 1962 ccr60 21 4896 4751 3 | |------------------------------------------------------------------| 16. | mort1962 1962 ccr60 22 31222 4910 3 | 17. | mort1962 1962 ccr60 23 3398 30098 3 | 18. | mort1962 1962 ccr60 24 2322 3280 3 | 19. | mort1962 1962 ccr60 25 197451 2263 3 | 20. | mort1962 1962 ccr60 26 17751 192951 3 | |------------------------------------------------------------------| 21. | mort1962 1962 ccr60 27 527561 17872 3 | 22. | mort1962 1962 ccr60 28 54645 502351 3 | 23. | mort1962 1962 ccr60 29 25876 54632 3 | 24. | mort1962 1962 ccr60 3 323 2850 3 | 25. | mort1962 1962 ccr60 30 62176 25254 3 | |------------------------------------------------------------------| 26. | mort1962 1962 ccr60 31 12497 63282 3 | 27. | mort1962 1962 ccr60 32 36848 12185 3 | 28. | mort1962 1962 ccr60 33 22632 35388 3 | 29. | mort1962 1962 ccr60 34 11372 20707 3 | 30. | mort1962 1962 ccr60 35 3431 11596 3 | |------------------------------------------------------------------| 31. | mort1962 1962 ccr60 36 56564 2137 3 | 32. | mort1962 1962 ccr60 37 4665 53038 3 | 33. | mort1962 1962 ccr60 38 20072 4064 3 | 34. | mort1962 1962 ccr60 39 12228 11540 3 | 35. | mort1962 1962 ccr60 4 102 300 3 | |------------------------------------------------------------------| 36. | mort1962 1962 ccr60 40 1800 1819 3 | 37. | mort1962 1962 ccr60 41 9723 9177 3 | 38. | mort1962 1962 ccr60 42 8194 7820 3 | 39. | mort1962 1962 ccr60 43 21824 20737 3 | 40. | mort1962 1962 ccr60 44 4831 4707 3 | |------------------------------------------------------------------| 41. | mort1962 1962 ccr60 45 1573 1584 3 | 42. | mort1962 1962 ccr60 46 8744 8095 3 | 43. | mort1962 1962 ccr60 47 4283 4158 3 | 44. | mort1962 1962 ccr60 48 305 324 3 | 45. | mort1962 1962 ccr60 49 1160 1249 3 | |------------------------------------------------------------------| 46. | mort1962 1962 ccr60 5 41 130 3 | 47. | mort1962 1962 ccr60 50 21192 21922 3 | 48. | mort1962 1962 ccr60 51 28199 28945 3 | 49. | mort1962 1962 ccr60 52 4551 4706 3 | 50. | mort1962 1962 ccr60 53 31455 32028 3 | |------------------------------------------------------------------| 51. | mort1962 1962 ccr60 54 19730 19094 3 | 52. | mort1962 1962 ccr60 55 52173 69452 3 | 53. | mort1962 1962 ccr60 56 40804 38091 3 | 54. | mort1962 1962 ccr60 57 56335 54158 3 | 55. | mort1962 1962 ccr60 58 20207 18999 3 | |------------------------------------------------------------------| 56. | mort1962 1962 ccr60 59 9013 8578 3 | 57. | mort1962 1962 ccr60 6 83 68 3 | 58. | mort1962 1962 ccr60 7 649 76 3 | 59. | mort1962 1962 ccr60 8 60 586 3 | 60. | mort1962 1962 ccr60 9 408 90 3 | +------------------------------------------------------------------+ . . end of do-file . sysuse auto,clear (1978 Automobile Data) . desc Contains data from /usr/local/stata10/ado/base/a/auto.dta obs: 74 1978 Automobile Data vars: 12 13 Apr 2007 17:45 size: 3,478 (99.9% of memory free) (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- make str18 %-18s Make and Model price int %8.0gc Price mpg int %8.0g Mileage (mpg) rep78 int %8.0g Repair Record 1978 headroom float %6.1f Headroom (in.) trunk int %8.0g Trunk space (cu. ft.) weight int %8.0gc Weight (lbs.) length int %8.0g Length (in.) turn int %8.0g Turn Circle (ft.) displacement int %8.0g Displacement (cu. in.) gear_ratio float %6.2f Gear Ratio foreign byte %8.0g origin Car type ------------------------------------------------------------------------------- Sorted by: foreign . exit