COR725 11/16/00 UPDATE OF BMFOC1U, BMFOC2U, and BMFOC3U The purpose of this COR is to explain how the best measures for father's occupational status (BMFOC1U, BMFOC2U, and BMFOC3U) were updated for the September 2000 new release. According to Change Notice #18 and COR612 some of the 1970 census occupation and industry codes were incorrect which affected several variables including OCSH57U. Most affected variables were updated, however BMFOC1U, BMFOC2U, and BMFOC3U were inadvertently not updated during this change. This COR details how these best measure variables were updated. The updated variables will still be called BMFOC1U-BMFOC3U and the old variables by this name will not be archived. The updated variables can be found in the following locations: 2228-2230 BMFOC1U 2231-2233 BMFOC2U 2234-2236 BMFOC3U This COR is divided into three sections: previous best measure variables, new best measure variables, and a comparison of the old and new best measure variables. I. Previous Best Measure Variables The best measure variables that existed prior to this update were created via the following SAS program as detailed in COR612: *Best measures of SEI for Head of Household - BMFOC1; if OCSH57U<997 then BMFOC1U=OCSH57U; else if OCSF57<97 then BMFOC1U=OCSF57*10; else BMFOC1U=999; *Best measures of SEI for Head of Household - BMFOC2; if OCSF57<97 then BMFOC2U=OCSF57*10; else if OCSH57U<997 then BMFOC2U=OCSH57U; else BMFOC2U=999; *Best measures of SEI for Head of Household - BMFOC3; if OCSF57<97 and OCSH57U<997 then BMFOC3U=ROUND(.5*((OCSF57*10)+OCSH57U)); else if OCSF57<97 and OCSH57U>=997 then BMFOC3U=OCSF57*10; else if OCSH57U<997 and OCSF57>=97 then BMFOC3U=OCSH57U; else BMFOC3U=999; II. Updated Best Measure Variables The best measure variables were updated using the same programming logic found in COR612 except that the new best measure variables draw from OCSH57U2 instead of OCSH57U (see COR612 or Change Notice #18 for the difference between these two variables). The data were updated in Stata with the following code: *Best measures of SEI for Head of Household - BMFOC1U gen bmfoc1u = 999 . replace bmfoc1u = ocsf57*10 if ocsf57<97 (8971 real changes made) . replace bmfoc1u = ocsh57u2 if ocsh57u2<997 (7230 real changes made) *Best measures of SEI for Head of Household - BMFOC2U . gen bmfoc2u = 999 . replace bmfoc2u = ocsh57u2 if ocsh57u2<997 (9375 real changes made) . replace bmfoc2u = ocsf57*10 if ocsf57<97 (6826 real changes made) *Best measures of SEI for Head of Household - BMFOC3U . gen bmfoc3u = 999 . replace bmfoc3u = ocsh57u2 if (ocsh57u2 < 997 & ocsf57>=97) (1106 real changes made) . replace bmfoc3u = ocsf57*10 if (ocsf57<97 & ocsh57u2>=997) (702 real changes made) . replace bmfoc3u = round((.5*((ocsf57*10)+ocsh57u2)),1) if (ocsf57<97 & ocsh57u2 < 997) (8269 real changes made) III. Comparison of Previous and Updated BMFOC1U, BMFOC2U, and BMFOC3U For the purpose of this comparison the previous BMFOC1U-BMFOC3U variables are called bmf1_old, bmf2_old, and bmf3_old Before looking at the BMFOC1U-BMFOC3U variables I am going to list the differences in the OCSH57U and OCSH57U2 variables which are the root of the changes in the best measure variables. You can see that there are 41 cases with different values on OCSH57U and OCSH57U2, however cases IDUSER numbers 24030, 24039, and 278011 are different only in how they are coded as missing (ie 997 vs 998). These three cases will not have different values on previous and updated BMFOC1U-BMFOC3U variables because they are consistently coded as missing. . compare ocsh57u ocsh57u2 ---------- difference ---------- count minimum average maximum ----------------------------------------------------------------------- ocsh57uocsh57u2 11 40 504 919 ---------- jointly defined 10317 -529 .0848115 919 ---------- total 10317 . list iduser ocsf57 ocsh57u ocsh57u2 if ocsh57u~=ocsh57u2 iduser ocsf57 ocsh57u ocsh57u2 100. 1100 47 440 650 231. 10017 87 840 578 457. 24030 48 998 999 466. 24039 99 997 998 1070. 52013 49 192 530 1107. 52050 19 190 257 1370. 62017 99 997 78 1520. 65012 32 650 802 1665. 74002 12 120 540 1908. 81057 33 437 508 2852. 133036 61 768 508 3146. 140001 99 997 120 3365. 151036 87 127 440 3411. 151082 18 160 189 3448. 151119 23 440 598 3492. 153007 79 620 747 3519. 153034 49 447 620 3736. 159080 99 437 790 3833. 160051 44 390 490 4313. 180020 37 410 150 5159. 217001 18 335 220 5322. 226005 44 71 600 5329. 226012 99 410 790 5489. 231017 15 997 160 5778. 236029 33 192 266 5810. 236061 18 997 100 6064. 245012 14 172 184 6078. 245026 22 219 330 6124. 245072 21 151 210 6512. 262004 58 220 329 6907. 278011 19 998 999 7439. 304004 99 150 190 7811. 323096 18 210 330 7859. 327001 14 840 620 9187. 380003 14 160 172 9260. 383002 44 997 140 9283. 385008 44 508 619 9319. 388003 99 63 360 9466. 390035 99 192 419 9767. 417002 14 200 160 10232. 432044 37 266 340 B. BMFOC1U/bmf1_old Comparing the previous and updated BMFOC1U variable we find that 38 cases are different-as we would expect given the differences in OCSH57U and OCHS57U2. . compare bmfoc1u bmf1_old --------- difference ---------- count minimum average maximum ----------------------------------------------------------------------- bmfoc1ubmf1_old 28 10 167 529 ---------- jointly defined 10317 -921 .1297858 529 ---------- total 10317 . list iduser ocsf57 ocsh57u ocsh57u2 bmf1_old bmfoc1u if bmf1_old~= bmfoc1u iduser ocsf57 ocsh57u ocsh57u2 bmf1_old bmfoc1u 100. 1100 47 440 650 440 650 231. 10017 87 840 578 840 578 1070. 52013 49 192 530 192 530 1107. 52050 19 190 257 190 257 1370. 62017 99 997 78 999 78 1520. 65012 32 650 802 650 802 1665. 74002 12 120 540 120 540 1908. 81057 33 437 508 437 508 2852. 133036 61 768 508 768 508 3146. 140001 99 997 120 999 120 3365. 151036 87 127 440 127 440 3411. 151082 18 160 189 160 189 3448. 151119 23 440 598 440 598 3492. 153007 79 620 747 620 747 3519. 153034 49 447 620 447 620 3736. 159080 99 437 790 437 790 3833. 160051 44 390 490 390 490 4313. 180020 37 410 150 410 150 5159. 217001 18 335 220 335 220 5322. 226005 44 71 600 71 600 5329. 226012 99 410 790 410 790 5489. 231017 15 997 160 150 160 5778. 236029 33 192 266 192 266 5810. 236061 18 997 100 180 100 6064. 245012 14 172 184 172 184 6078. 245026 22 219 330 219 330 6124. 245072 21 151 210 151 210 6512. 262004 58 220 329 220 329 7439. 304004 99 150 190 150 190 7811. 323096 18 210 330 210 330 7859. 327001 14 840 620 840 620 9187. 380003 14 160 172 160 172 9260. 383002 44 997 140 440 140 9283. 385008 44 508 619 508 619 9319. 388003 99 63 360 63 360 9466. 390035 99 192 419 192 419 9767. 417002 14 200 160 200 160 10232. 432044 37 266 340 266 340 C. BMFOC2U/bmf2_old When we compare the previous and updated BMFOC2U variables we find that 7 cases are different---these changes all correspond to situations when OCSF57 (tax data) are missing and the OCSH57U2 variable is different than the OCSH57U variable. . compare bmfoc2u bmf2_old ---------- difference ---------- count minimum average maximum ----------------------------------------------------------------------- bmfoc2ubmf2_old 5 40 259.4 380 ---------- jointly defined 10317 -921 -.0487545 380 ---------- total 10317 . list iduser ocsf57 ocsh57u ocsh57u2 bmf2_old bmfoc2u if bmf2_old ~= bmfoc2u iduser ocsf57 ocsh57u ocsh57u2 bmf2_old bmfoc2u 1370. 62017 99 997 78 999 78 3146. 140001 99 997 120 999 120 3736. 159080 99 437 790 437 790 5329. 226012 99 410 790 410 790 7439. 304004 99 150 190 150 190 9319. 388003 99 63 360 63 360 9466. 390035 99 192 419 192 419 D. BMFOC3U/bmf3_old As with BMFOC1U, there were 38 cases that received an updated BMFOC3U. . compare bmfoc3u bmf3_old --------- difference ---------- count minimum average maximum ----------------------------------------------------------------------- bmfoc3ubmf3_old 28 5 106.6429 380 ---------- jointly defined 10317 -921 .0404187 380 ---------- total 10317 . list iduser ocsf57 ocsh57u ocsh57u2 bmf3_old bmfoc3u if bmf3_old ~= bmfoc3u iduser ocsf57 ocsh57u ocsh57u2 bmf3_old bmfoc3u 100. 1100 47 440 650 455 560 231. 10017 87 840 578 855 724 1070. 52013 49 192 530 341 510 1107. 52050 19 190 257 190 224 1370. 62017 99 997 78 999 78 1520. 65012 32 650 802 485 561 1665. 74002 12 120 540 120 330 1908. 81057 33 437 508 384 419 2852. 133036 61 768 508 689 559 3146. 140001 99 997 120 999 120 3365. 151036 87 127 440 499 655 3411. 151082 18 160 189 170 185 3448. 151119 23 440 598 335 414 3492. 153007 79 620 747 705 769 3519. 153034 49 447 620 469 555 3736. 159080 99 437 790 437 790 3833. 160051 44 390 490 415 465 4313. 180020 37 410 150 390 260 5159. 217001 18 335 220 258 200 5322. 226005 44 71 600 256 520 5329. 226012 99 410 790 410 790 5489. 231017 15 997 160 150 155 5778. 236029 33 192 266 261 298 5810. 236061 18 997 100 180 140 6064. 245012 14 172 184 156 162 6078. 245026 22 219 330 220 275 6124. 245072 21 151 210 181 210 6512. 262004 58 220 329 400 455 7439. 304004 99 150 190 150 190 7811. 323096 18 210 330 195 255 7859. 327001 14 840 620 490 380 9187. 380003 14 160 172 150 156 9260. 383002 44 997 140 440 290 9283. 385008 44 508 619 474 530 9319. 388003 99 63 360 63 360 9466. 390035 99 192 419 192 419 9767. 417002 14 200 160 170 150 10232. 432044 37 266 340 318 355