----------------------------------------------------------------------------------------------------------------------------------------- log: /disk/homes2c/nber/jroth/ces/y1_1x_to_4_and_y2_1_each_have_unique_newid.log log type: text opened on: 15 Oct 2009, 10:58:28 . ** by Jean Roth, jroth@nber.org , 2009-10-15 . ** Purpose: Demonstrate that y1_1x to y1_4 and y2_1 have unique NEWIDs . forval year1 = 2001/2007 { 2. local yr1=substr(`"`year1'"',3,2) 3. local year2=`year1'+1 4. local yr2=substr(`"`year2'"',3,2) 5. display "year1=`year1' year2=`year2' yr1=`yr1' yr2=`yr2'" 6. local _1 `yr1'1x 7. local _2 `yr1'2 8. local _3 `yr1'3 9. local _4 `yr1'4 10. local _5 `yr2'1 11. local merge_list `_2' `_3' `_4' `_5' 12. use ~/bulk/ces/fmli`_1' 13. quietly describe 14. local last_n `r(N)' 15. foreach i of local merge_list { 16. ** Merging quietly to suppress messages about recasting of variables from, for example, int to long . quietly merge newid using /homes/nber/jroth/bulk/ces/fmli`i', _merge(_`i') 17. tab _`i' 18. assert _`i' <3 19. sort newid 20. ** # of records should be increasing with each merge to test newid uniqueness . quietly describe 21. assert `r(N)' > `last_n' 22. local last_n `r(N)' 23. } 24. clear 25. } year1=2001 year2=2002 yr1=01 yr2=02 _012 | Freq. Percent Cum. ------------+----------------------------------- 1 | 7,712 50.43 50.43 2 | 7,579 49.57 100.00 ------------+----------------------------------- Total | 15,291 100.00 _013 | Freq. Percent Cum. ------------+----------------------------------- 1 | 15,291 67.39 67.39 2 | 7,398 32.61 100.00 ------------+----------------------------------- Total | 22,689 100.00 _014 | Freq. Percent Cum. ------------+----------------------------------- 1 | 22,689 74.85 74.85 2 | 7,624 25.15 100.00 ------------+----------------------------------- Total | 30,313 100.00 _021 | Freq. Percent Cum. ------------+----------------------------------- 1 | 30,313 79.76 79.76 2 | 7,691 20.24 100.00 ------------+----------------------------------- Total | 38,004 100.00 year1=2002 year2=2003 yr1=02 yr2=03 _022 | Freq. Percent Cum. ------------+----------------------------------- 1 | 7,691 49.72 49.72 2 | 7,778 50.28 100.00 ------------+----------------------------------- Total | 15,469 100.00 _023 | Freq. Percent Cum. ------------+----------------------------------- 1 | 15,469 66.38 66.38 2 | 7,833 33.62 100.00 ------------+----------------------------------- Total | 23,302 100.00 _024 | Freq. Percent Cum. ------------+----------------------------------- 1 | 23,302 74.39 74.39 2 | 8,024 25.61 100.00 ------------+----------------------------------- Total | 31,326 100.00 _031 | Freq. Percent Cum. ------------+----------------------------------- 1 | 31,326 79.48 79.48 2 | 8,086 20.52 100.00 ------------+----------------------------------- Total | 39,412 100.00 year1=2003 year2=2004 yr1=03 yr2=04 _032 | Freq. Percent Cum. ------------+----------------------------------- 1 | 8,086 49.66 49.66 2 | 8,196 50.34 100.00 ------------+----------------------------------- Total | 16,282 100.00 _033 | Freq. Percent Cum. ------------+----------------------------------- 1 | 16,282 66.86 66.86 2 | 8,072 33.14 100.00 ------------+----------------------------------- Total | 24,354 100.00 _034 | Freq. Percent Cum. ------------+----------------------------------- 1 | 24,354 75.17 75.17 2 | 8,044 24.83 100.00 ------------+----------------------------------- Total | 32,398 100.00 _041 | Freq. Percent Cum. ------------+----------------------------------- 1 | 32,398 80.24 80.24 2 | 7,976 19.76 100.00 ------------+----------------------------------- Total | 40,374 100.00 year1=2004 year2=2005 yr1=04 yr2=05 _042 | Freq. Percent Cum. ------------+----------------------------------- 1 | 7,976 50.63 50.63 2 | 7,779 49.37 100.00 ------------+----------------------------------- Total | 15,755 100.00 _043 | Freq. Percent Cum. ------------+----------------------------------- 1 | 15,755 67.33 67.33 2 | 7,643 32.67 100.00 ------------+----------------------------------- Total | 23,398 100.00 _044 | Freq. Percent Cum. ------------+----------------------------------- 1 | 23,398 75.27 75.27 2 | 7,687 24.73 100.00 ------------+----------------------------------- Total | 31,085 100.00 _051 | Freq. Percent Cum. ------------+----------------------------------- 1 | 31,085 80.03 80.03 2 | 7,759 19.97 100.00 ------------+----------------------------------- Total | 38,844 100.00 year1=2005 year2=2006 yr1=05 yr2=06 _052 | Freq. Percent Cum. ------------+----------------------------------- 1 | 5,081 39.70 39.70 2 | 7,717 60.30 100.00 ------------+----------------------------------- Total | 12,798 100.00 _053 | Freq. Percent Cum. ------------+----------------------------------- 1 | 12,798 63.19 63.19 2 | 7,456 36.81 100.00 ------------+----------------------------------- Total | 20,254 100.00 _054 | Freq. Percent Cum. ------------+----------------------------------- 1 | 20,254 72.75 72.75 2 | 7,585 27.25 100.00 ------------+----------------------------------- Total | 27,839 100.00 _061 | Freq. Percent Cum. ------------+----------------------------------- 1 | 27,839 78.14 78.14 2 | 7,786 21.86 100.00 ------------+----------------------------------- Total | 35,625 100.00 year1=2006 year2=2007 yr1=06 yr2=07 _062 | Freq. Percent Cum. ------------+----------------------------------- 1 | 7,786 52.63 52.63 2 | 7,009 47.37 100.00 ------------+----------------------------------- Total | 14,795 100.00 _063 | Freq. Percent Cum. ------------+----------------------------------- 1 | 14,795 67.92 67.92 2 | 6,988 32.08 100.00 ------------+----------------------------------- Total | 21,783 100.00 _064 | Freq. Percent Cum. ------------+----------------------------------- 1 | 21,783 75.46 75.46 2 | 7,084 24.54 100.00 ------------+----------------------------------- Total | 28,867 100.00 _071 | Freq. Percent Cum. ------------+----------------------------------- 1 | 28,867 80.56 80.56 2 | 6,965 19.44 100.00 ------------+----------------------------------- Total | 35,832 100.00 year1=2007 year2=2008 yr1=07 yr2=08 _072 | Freq. Percent Cum. ------------+----------------------------------- 1 | 6,965 50.49 50.49 2 | 6,829 49.51 100.00 ------------+----------------------------------- Total | 13,794 100.00 _073 | Freq. Percent Cum. ------------+----------------------------------- 1 | 13,794 67.27 67.27 2 | 6,711 32.73 100.00 ------------+----------------------------------- Total | 20,505 100.00 _074 | Freq. Percent Cum. ------------+----------------------------------- 1 | 20,505 75.01 75.01 2 | 6,830 24.99 100.00 ------------+----------------------------------- Total | 27,335 100.00 _081 | Freq. Percent Cum. ------------+----------------------------------- 1 | 27,335 79.81 79.81 2 | 6,914 20.19 100.00 ------------+----------------------------------- Total | 34,249 100.00 . end of do-file . exit,clear