/* Dear Dr. Hanley, Thank you for your very nice note. I have attached a spreadsheet with the numerators and denominators from the JAMA article on folic acid fortification. I am very pleased that you plan to use this as an example for your course in the fall. Please let me know if there is anything in the spreadsheet that requires further explanation or clarification. Sincerely, Margaret Honein National Center on Birth Defects and Developmental Disabilities, CDC */ /* Data below were extracted by JH from this spreadsheet errors in dates of conception for last 4 mo. of 1997 corrected oct 23, 2002. */ DATA sasuser.fa_bd; INPUT latecare /* 1 if 3rd trimester only or no prenatal care */ /* 0 if 1st or 2nd trimester care */ /* . if information not available */ conc_mo conc_yr /* estimated month and year of conception */ /* (adjusted for 38w gest) */ birth_mo birth_yr /* month and year of birth */ sb_no /* number of cases of spina bifida */ ane_no /* number of cases of anencephaly */ n_births /* number of live births */ /* Data from US birth certificates, */ /* National Center for Vital Statistics, CDC */ /* EXCLUDES RESIDENTS OF CT, MD, NM, NY, AND OK */ ; conc_tm = (conc_yr - 1900) + round( (conc_mo-0.5)/12 , 0.01); conc_tq = (conc_yr - 1900) + int( (conc_mo+2)/3)/4 - 0.125 ; /* quarter */ conc_ts = 89 + round(1/12,0.01) + 0.5*int( ((conc_yr - 1989)*12 + conc_mo + 1)/6) ; /* 'semester' */ sb_rate = round( 100000 * (sb_no / n_births), 0.01); /* S.B. rate per 100 000 */ ane_rate = round( 100000 * (ane_no / n_births), 0.01); /* Anenc. rate per 100 000 */ LINES; 0 05 1989 01 1990 78 47 271155 0 06 1989 02 1990 69 35 253448 0 07 1989 03 1990 67 43 284637 0 08 1989 04 1990 61 36 272802 0 09 1989 05 1990 77 58 289157 0 10 1989 06 1990 67 50 283107 0 11 1989 07 1990 70 54 299677 0 12 1989 08 1990 79 52 305133 0 01 1990 09 1990 61 40 293680 0 02 1990 10 1990 75 39 288283 0 03 1990 11 1990 59 42 271190 0 04 1990 12 1990 60 41 274602 0 05 1990 01 1991 65 53 272591 0 06 1990 02 1991 56 42 252042 0 07 1990 03 1991 70 54 279858 0 08 1990 04 1991 60 60 273533 0 09 1990 05 1991 67 57 288567 0 10 1990 06 1991 69 44 272552 0 11 1990 07 1991 65 32 297614 0 12 1990 08 1991 69 55 301139 0 01 1991 09 1991 64 37 292140 0 02 1991 10 1991 79 40 285739 0 03 1991 11 1991 63 42 264685 0 04 1991 12 1991 61 38 278828 0 05 1991 01 1992 45 33 272775 0 06 1991 02 1992 48 30 257483 0 07 1991 03 1992 61 27 277970 0 08 1991 04 1992 49 21 273290 0 09 1991 05 1992 63 37 282762 0 10 1991 06 1992 55 27 279413 0 11 1991 07 1992 59 37 295933 0 12 1991 08 1992 61 40 287923 0 01 1992 09 1992 59 29 287657 0 02 1992 10 1992 61 31 283664 0 03 1992 11 1992 73 34 265678 0 04 1992 12 1992 67 29 278643 0 05 1992 01 1993 68 39 265457 0 06 1992 02 1993 55 30 250363 0 07 1992 03 1993 65 32 282076 0 08 1992 04 1993 62 33 269726 0 09 1992 05 1993 64 31 276950 0 10 1992 06 1993 73 40 277283 0 11 1992 07 1993 67 47 291575 0 12 1992 08 1993 75 39 290979 0 01 1993 09 1993 67 35 289089 0 02 1993 10 1993 63 22 275855 0 03 1993 11 1993 74 29 262561 0 04 1993 12 1993 58 27 274578 0 05 1993 01 1994 73 16 265180 0 06 1993 02 1994 74 19 248531 0 07 1993 03 1994 60 31 280967 0 08 1993 04 1994 73 22 262969 0 09 1993 05 1994 61 34 273586 0 10 1993 06 1994 72 36 273638 0 11 1993 07 1994 58 24 286938 0 12 1993 08 1994 74 31 293087 0 01 1994 09 1994 69 26 282374 0 02 1994 10 1994 68 32 273873 0 03 1994 11 1994 55 18 265942 0 04 1994 12 1994 70 37 271268 0 05 1994 01 1995 74 25 261562 0 06 1994 02 1995 69 34 244816 0 07 1994 03 1995 58 26 272470 0 08 1994 04 1995 75 31 256834 0 09 1994 05 1995 71 30 277757 0 10 1994 06 1995 78 34 273835 0 11 1994 07 1995 63 29 282806 0 12 1994 08 1995 93 30 292368 0 01 1995 09 1995 81 27 282971 0 02 1995 10 1995 63 36 274971 0 03 1995 11 1995 86 25 258489 0 04 1995 12 1995 65 19 262031 0 05 1995 01 1996 58 36 260793 0 06 1995 02 1996 59 26 250494 0 07 1995 03 1996 64 39 267967 0 08 1995 04 1996 65 22 259721 0 09 1995 05 1996 90 31 271349 0 10 1995 06 1996 73 28 265122 0 11 1995 07 1996 71 25 288305 0 12 1995 08 1996 72 33 289499 0 01 1996 09 1996 67 34 281555 0 02 1996 10 1996 67 33 280407 0 03 1996 11 1996 72 29 258369 0 04 1996 12 1996 71 32 269217 0 05 1996 01 1997 89 41 264067 0 06 1996 02 1997 62 27 242953 0 07 1996 03 1997 67 27 267562 0 08 1996 04 1997 57 21 262236 0 09 1996 05 1997 64 28 275824 0 10 1996 06 1997 77 39 269430 0 11 1996 07 1997 73 36 290201 0 12 1996 08 1997 73 23 284759 0 01 1997 09 1997 62 24 280279 0 02 1997 10 1997 77 37 275497 0 03 1997 11 1997 45 29 256593 0 04 1997 12 1997 51 39 275159 0 05 1997 01 1998 59 16 266054 0 06 1997 02 1998 55 16 248740 0 07 1997 03 1998 72 24 274083 0 08 1997 04 1998 55 34 265966 0 09 1997 05 1998 66 34 275273 0 10 1997 06 1998 63 24 273140 0 11 1997 07 1998 55 32 291529 0 12 1997 08 1998 71 21 288327 0 01 1998 09 1998 65 29 287227 0 02 1998 10 1998 50 29 278490 0 03 1998 11 1998 39 15 261532 0 04 1998 12 1998 65 24 278944 1 05 1989 01 1990 5 7 18599 1 06 1989 02 1990 3 5 17148 1 07 1989 03 1990 6 9 18866 1 08 1989 04 1990 4 4 17831 1 09 1989 05 1990 4 9 17545 1 10 1989 06 1990 9 3 17018 1 11 1989 07 1990 4 2 18087 1 12 1989 08 1990 9 7 18134 1 01 1990 09 1990 9 7 17565 1 02 1990 10 1990 4 4 17827 1 03 1990 11 1990 4 1 17299 1 04 1990 12 1990 3 5 17263 1 05 1990 01 1991 3 7 17894 1 06 1990 02 1991 5 8 15922 1 07 1990 03 1991 3 8 17707 1 08 1990 04 1991 6 4 16663 1 09 1990 05 1991 3 5 16964 1 10 1990 06 1991 2 3 16041 1 11 1990 07 1991 3 4 16867 1 12 1990 08 1991 7 4 17052 1 01 1991 09 1991 7 6 16822 1 02 1991 10 1991 5 4 16838 1 03 1991 11 1991 4 4 16004 1 04 1991 12 1991 10 4 16690 1 05 1991 01 1992 6 3 16247 1 06 1991 02 1992 2 3 15488 1 07 1991 03 1992 8 7 15941 1 08 1991 04 1992 10 5 15127 1 09 1991 05 1992 4 1 14634 1 10 1991 06 1992 2 6 14229 1 11 1991 07 1992 6 1 14855 1 12 1991 08 1992 3 1 14682 1 01 1992 09 1992 5 5 14214 1 02 1992 10 1992 8 4 14597 1 03 1992 11 1992 9 3 13903 1 04 1992 12 1992 6 2 14454 1 05 1992 01 1993 2 0 14452 1 06 1992 02 1993 10 3 13256 1 07 1992 03 1993 5 5 14510 1 08 1992 04 1993 7 2 13584 1 09 1992 05 1993 4 8 13551 1 10 1992 06 1993 5 1 13359 1 11 1992 07 1993 5 4 14019 1 12 1992 08 1993 3 4 14024 1 01 1993 09 1993 7 4 13746 1 02 1993 10 1993 7 2 13247 1 03 1993 11 1993 1 5 12629 1 04 1993 12 1993 3 5 13045 1 05 1993 01 1994 6 2 12828 1 06 1993 02 1994 5 5 12215 1 07 1993 03 1994 5 4 13212 1 08 1993 04 1994 4 2 12090 1 09 1993 05 1994 3 1 12076 1 10 1993 06 1994 1 2 11521 1 11 1993 07 1994 7 4 12101 1 12 1993 08 1994 3 3 12377 1 01 1994 09 1994 7 1 11845 1 02 1994 10 1994 1 1 12128 1 03 1994 11 1994 6 0 11613 1 04 1994 12 1994 4 1 12147 1 05 1994 01 1995 5 3 12199 1 06 1994 02 1995 3 1 11253 1 07 1994 03 1995 3 1 12408 1 08 1994 04 1995 4 3 11101 1 09 1994 05 1995 3 4 11636 1 10 1994 06 1995 6 8 11314 1 11 1994 07 1995 2 4 12118 1 12 1994 08 1995 4 1 12066 1 01 1995 09 1995 7 6 12038 1 02 1995 10 1995 4 3 12234 1 03 1995 11 1995 2 1 11549 1 04 1995 12 1995 4 1 11541 1 05 1995 01 1996 5 2 11612 1 06 1995 02 1996 3 1 10978 1 07 1995 03 1996 3 2 11603 1 08 1995 04 1996 5 3 10920 1 09 1995 05 1996 1 4 10692 1 10 1995 06 1996 2 4 10205 1 11 1995 07 1996 5 6 10864 1 12 1995 08 1996 7 0 11018 1 01 1996 09 1996 4 4 10913 1 02 1996 10 1996 3 1 11314 1 03 1996 11 1996 5 1 10331 1 04 1996 12 1996 3 0 10944 1 05 1996 01 1997 4 8 11050 1 06 1996 02 1997 4 3 10382 1 07 1996 03 1997 3 3 11537 1 08 1996 04 1997 4 1 10724 1 09 1996 05 1997 2 6 10870 1 10 1996 06 1997 3 0 10546 1 11 1996 07 1997 2 3 11025 1 12 1996 08 1997 1 3 10767 1 01 1997 09 1997 6 2 10571 1 02 1997 10 1997 5 3 10928 1 03 1997 11 1997 4 1 10690 1 04 1997 12 1997 5 5 11155 1 05 1997 01 1998 3 1 11211 1 06 1997 02 1998 6 0 10762 1 07 1997 03 1998 6 3 11890 1 08 1997 04 1998 2 5 10933 1 09 1997 05 1998 0 1 10579 1 10 1997 06 1998 7 1 10237 1 11 1997 07 1998 4 2 11126 1 12 1997 08 1998 7 1 10925 1 01 1998 09 1998 1 4 10983 1 02 1998 10 1998 2 3 10612 1 03 1998 11 1998 4 1 10501 1 04 1998 12 1998 1 3 10968 . 05 1989 01 1990 2 5 4523 . 06 1989 02 1990 3 1 4244 . 07 1989 03 1990 0 1 4324 . 08 1989 04 1990 1 2 4249 . 09 1989 05 1990 1 2 4479 . 10 1989 06 1990 2 1 4613 . 11 1989 07 1990 1 1 5284 . 12 1989 08 1990 1 2 5116 . 01 1990 09 1990 2 1 4716 . 02 1990 10 1990 4 0 4633 . 03 1990 11 1990 3 1 4318 . 04 1990 12 1990 0 3 4665 . 05 1990 01 1991 0 0 4324 . 06 1990 02 1991 2 1 3868 . 07 1990 03 1991 1 0 4440 . 08 1990 04 1991 1 3 4269 . 09 1990 05 1991 1 0 4609 . 10 1990 06 1991 1 2 4524 . 11 1990 07 1991 1 2 4754 . 12 1990 08 1991 5 1 4947 . 01 1991 09 1991 1 1 4621 . 02 1991 10 1991 1 1 4555 . 03 1991 11 1991 5 3 4358 . 04 1991 12 1991 4 2 4908 . 05 1991 01 1992 0 3 4551 . 06 1991 02 1992 4 5 4370 . 07 1991 03 1992 1 4 4434 . 08 1991 04 1992 1 3 4381 . 09 1991 05 1992 2 4 4826 . 10 1991 06 1992 2 0 4665 . 11 1991 07 1992 0 2 4912 . 12 1991 08 1992 1 1 4543 . 01 1992 09 1992 4 2 4664 . 02 1992 10 1992 2 2 4483 . 03 1992 11 1992 2 0 4345 . 04 1992 12 1992 0 1 4524 . 05 1992 01 1993 4 2 4334 . 06 1992 02 1993 1 2 3945 . 07 1992 03 1993 0 2 4229 . 08 1992 04 1993 0 2 4139 . 09 1992 05 1993 2 1 4368 . 10 1992 06 1993 2 1 4374 . 11 1992 07 1993 5 0 4640 . 12 1992 08 1993 1 2 4430 . 01 1993 09 1993 2 0 4387 . 02 1993 10 1993 2 0 4253 . 03 1993 11 1993 3 0 4237 . 04 1993 12 1993 1 1 4815 . 05 1993 01 1994 0 1 4603 . 06 1993 02 1994 4 1 4410 . 07 1993 03 1994 1 1 4509 . 08 1993 04 1994 1 2 4179 . 09 1993 05 1994 1 1 4461 . 10 1993 06 1994 1 4 4531 . 11 1993 07 1994 1 1 4951 . 12 1993 08 1994 2 2 4959 . 01 1994 09 1994 2 2 4830 . 02 1994 10 1994 1 1 5139 . 03 1994 11 1994 3 2 5092 . 04 1994 12 1994 2 1 5285 . 05 1994 01 1995 3 1 4771 . 06 1994 02 1995 4 1 4171 . 07 1994 03 1995 2 1 4541 . 08 1994 04 1995 2 0 4487 . 09 1994 05 1995 1 1 4835 . 10 1994 06 1995 2 2 4837 . 11 1994 07 1995 3 2 5146 . 12 1994 08 1995 5 1 5252 . 01 1995 09 1995 3 1 4742 . 02 1995 10 1995 1 1 4443 . 03 1995 11 1995 2 2 4583 . 04 1995 12 1995 3 1 4723 . 05 1995 01 1996 1 1 5149 . 06 1995 02 1996 1 0 4817 . 07 1995 03 1996 1 2 5211 . 08 1995 04 1996 1 1 4942 . 09 1995 05 1996 3 2 5300 . 10 1995 06 1996 0 2 5227 . 11 1995 07 1996 2 0 5741 . 12 1995 08 1996 2 2 5936 . 01 1996 09 1996 2 0 5192 . 02 1996 10 1996 3 0 5460 . 03 1996 11 1996 1 1 5258 . 04 1996 12 1996 1 1 5683 . 05 1996 01 1997 1 1 5289 . 06 1996 02 1997 1 0 4635 . 07 1996 03 1997 2 2 5007 . 08 1996 04 1997 0 4 4840 . 09 1996 05 1997 1 1 4942 . 10 1996 06 1997 2 1 4835 . 11 1996 07 1997 1 2 5238 . 12 1996 08 1997 0 1 5100 . 01 1997 09 1997 0 1 4918 . 02 1997 10 1997 1 0 5014 . 03 1997 11 1997 2 0 4831 . 04 1997 12 1997 0 2 5738 . 05 1997 01 1998 1 0 5590 . 06 1997 02 1998 1 1 4969 . 07 1997 03 1998 2 0 5646 . 08 1997 04 1998 3 0 5550 . 09 1997 05 1998 5 2 5953 . 10 1997 06 1998 1 2 5634 . 11 1997 07 1998 2 2 6329 . 12 1997 08 1998 2 0 6409 . 01 1998 09 1998 1 1 6136 . 02 1998 10 1998 1 1 5958 . 03 1998 11 1998 0 0 5973 . 04 1998 12 1998 3 5 6596 ; run;