Correspondence between

Great Bob. That is helpful. Yan do you have few minutes to meet with me? We can decide how to approach this.

Patti, i don’t have much further to add at this point, beyond what | showed you yesterday fooking at actual specimen dates and DOBs—i.e., f think the “Just Dates” file shows that my age calculations are correct. Not knowing SAS, | don’t know how to adjust the cade to adjust the SAS date calculations, but | think that’s what needs to be done. lll be happy to heip, if there is anything | can do. We do seem to be calculating the same number of individuals (differed by 1), and we're pulling zip code fram the same field, so f think it boils down to how the age is calculated. Bob xxxEND_PAGE:dhhs02_b0443_1788_1797_02 001790

HI Bob, Following up with you. Have you had a chance to look at the data? Yan is here today and can assist with exploring if the difference between the two datasets is due to how age Is calculate Please let us know. Thanks! Patti

Bob, fran the data for 2014 and | believe that the differences are due to rounding, though | haven’t quantified them yet. 'm copying Yan because she may have a way to lock at this quicker, faster and easier than us manually reviewing records. Yan, Bob and | analyzed 2014 by zipcode for the state and got different numbers. We have been asked to find out why. The Just Dates excei file is from Bab- where he looked at individual level data to try to figure out if the difference could be due to the way we are categorizing age. (You could create SAS dataset, which may make it easier to analyze. ©) Documenting the SAS code is my attempt to quantify each step by age group. Lead 2014 by zip is my analysis with SAS 2014 zips is Bob’s analysis Bob has 143,123 for 2014 and | have 141,355 for children fess than 6 years. Yan, can you compare Bob's Just dates to the 2014 analytic file we created in SAS. Also | see results that have missing for sample type so we are including them —| thought this might be a difference tao. isuspect it has te do with INTCK —do you know haw it handles rounding? Thanks, Patti xxxEND_PAGE:dhhs03_b0758_2644_2650_1 002645

xxxEND_PAGE:dhhs02_b0443_1788_1797_03 001791 My apologies. Yan is attending a training taday and isn’t in the office. Please let me know if ican assist you with this today. Thanks, Patti

Bob, tran the data for 2014 and | believe that the differences are due ta rounding, though | haven’t quantified them yet. ’'m copying Yan because she may have a way to look at this quicker, faster and easier than us manually reviewing records. Yan, Bob and | analyzed 2014 by zipcode for the state and got cifferent numbers. We have been asked to find out why. The Just Dates excel file is fram Bab- where he looked at individual level data to try to figure cut if the difference could be due to the way we are categorizing age. (You could create SAS dataset, which may make it easier to analyze. ©) Documenting the SAS cede is my atternpt to quantify each step by age group. Lead 2014 by zip is my analysis with SAS 2014 zips is Bob’s analysis Bob has 143,123 for 2014 and | have 141,355 for children less than 6 years. Yan, can you compare Bob's Just dates to the 2014 analytic file we created in SAS. Also I see results that have missing for sample type so we are including them ~—i thought this might be a difference too. i suspect it has to do with INTCK —do you know how it handles rounding? xxxEND_PAGE:dhhs02_b0443_1788_1797_04 001792 Thanks, Patti

OK, on my way. Piease see attached.

i don’t have meetings until this afternoon.

Patti, ’'ve been looking at ages and dates--if you have 5 minutes er so in the next half hour, please fet me know—!li stop by. Bob xxxEND_PAGE:dhhs03_b0758_2644_2650_2 002646

Hi Bob, Corinne and Sarah looked at our two tables and couldn’t find a discernable pattern. In some zips | have more and in others you have more. Yan and | documented the data steps and the numbers at each step, and also by age group. Raw data set from warehouse n= 179,374 156,069 have one test per year 23,305 duplicate tests (2-22 tests) 10,906 retained highest test per individual Total analytic set 156,069 + 10,906= 166,975 The attached word document contains the analysis by age group. xxxEND_PAGE:dhhs03_b0369_1354_1355_1 001355 | pulled from the warehouse yesterday and there were 179,374 records, which is the same number as | had two weeks ago. Do you have time this morning to look into this? | have a call at 10 am, and meetings all afternoon, so can meet with you sometime this morning. Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemisiegy Section | Michigan Department of Health andl Human Services| Lifecourse Epidemiology and Genomics Division [PO Box 30195 / 201 Townsend St 4" Floor - Lansing, MI 48909 | Cell Work Hours: M_F 7:30am —4:00 pm Michigan has.a public records law. Most written communications to or from state officials regarding state business are public records available to the public and media upon request. Your e-mail communications and any attachments to. them may be subject to public disclosure. This message, including any attachments is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure, or distribution of any confidential and/or privileged information contained in this e-mail is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. xxxEND_PAGE:dhhs03_b0369_1354_1355_2

We use INTCK function in SAS to calculate the age. | believe it calculates to days and we ask SAS for years. Sent from my iPhone

fused specimen date. Maybe a slight difference in the way we calculated age at test? | used this: (Specimen Date ~ Date of Birth}/365.25 and then incluced all children < 6.00 years of age.

Bob and Patti ~ Can you explain why Bob’s total for 2014 (143,123 ~ see attached) is bigger than Patti’s (141,355) . is this because bob uses report date and Patti used specimen date? xxxEND_PAGE:dhhs03_b0758_2644_2650_3 002647

Hi all, | deduplicated to year for the state. | have SAS output for 2010-2015 by agegroup and by Michigan, Genesee, and Flint. By quarter and then broke 2015 to 1/1 to 9/30 and 10/1 onward. | can share the SAS output with you, but I’m entering into excel, which will be easier to read. The hand entering is going slowly, so | may not have the excel tables ready by this afternoon. also want Yan to double check the code that | modified to create the yearly datasets. So rough numbers | can provide today, something more polished probably won't be available until Monday. Unless | work on it during the weekend. Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemiology Section | Michigan Department of Health ang Human Lifecourse Epidemiology and Genomics Division [PC Box 30195 / 251 Townsend St 4" Floar - Lansing, Mi 48909 | Cell i ffice ph: 517-335-9456 Fax 517-335-9790 | [email protected] ‘ Work Hours: M_F 7:30am— 4:00 pm Michigan has a public records law. Most written communications to or from state officials regarding state business are public records available to the public and media upon request. Your e-mail communications and any attachments to them may be subject to public disclosure. This message, including any attachments is intended solely for the use of the named recipient(s) and. may contain confidential and/or privileged information. Any unauthorized review, use, disclosure, or distribution of any confidential and/or privileged information contained in this e-mail is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. xxxEND_PAGE:dhhs02_b0385_1466_1468_2 001468 xxxEND_PAGE:dhhs02_b0385_1466_1468_3

Tharihs!

Sent from my iPhone Begin forwarded message:

1 xxxEND_PAGE:dhhs02_b0346_1292_1293_1 001293 Hi Bob, igot my access on Friday afternoon, before [left for the PRAMS National Meeting. [returned this Monday, so hope to extract the data for surveillance and hand off to Yan for the SAS coding. funderstand the need for providing Genesee CHD with the child-specific tile and that you will continue to do that. talso understand that | will provide you with the data for the diractor’s report, however, [think the format should inchide rates, not simply nurnbers and perhaps some context for time and place, while keening it simple. i just met with Yan today and honefully | think | found an hour this afternoon to extract data. Yan is off tomorrow but will be inon Thursday and Friday. We will keep you informed and will contact you with questions as we navigate the data. Pattl

Hi Marcy, fagree that it makes sense for Bob to provide the weekly Flint updates to department leadership given that Fintisa very active situation. | would at sore point Hike to see epi re-run the Poisson analysis for Flint with confirmed (venous only} cases. And yes we need to set up another meeting. Rashmi had asked me last week if f was going to do that and EF will. [believe we will need to meet periodically, particularly in light of the Free Press request related to Detroit and other high burden communities. Bob -- thanks for sharing the weekly update. Corinne

VH just add that it may make sense for Bob to compile a weekly update, but for Patti to run any analysis on the data file? Not sure - wa haven’t delved inta that territory yet... do we need to sat up another meeting/conversation?

Patti, xxxEND_PAGE:dhhs02_b0349_1297_1298_1 001298 Just checking to see if you have access yet to the Lead table in the Data Warehouse. We met the other day (on another subject) with the folks who manage the DSA, the application that controls access to the Warehouse. We asked them to check on your request for access, to find out where the hold-up is. Do you have access yet? If not, is there anything | can do to help in the meantime? Also, | want to let you know what I’ve been up to regarding lead data for Flint. At Eden Wells’ and Sue Moran’s request, I’ve provided to Genesee Co HD a child-specific file of children with BLLs >= 5 since April 2014, indicating each child’s most recent test and whether the child needs a confirmatory venous, a follow-up venous, or is not currently due for re- testing. I’ll update the file each Monday and send an updated copy to them. The purpose is to help guide the activities of GCHD’s nurses, as well as EBL investigators contracted by the Healthy Homes Section. I’ve also been asked by Angela Minicuci and Eden Wells to provide a weekly summary of new lead results. The latest example is attached. | don’t want to trespass in your territory, though, so if you are or will be doing something similar, please let me know and we'll work it out. Thanks, Bob Robert L. Scott Childhood Lead Poisoning Prevention Program Michigan Department of Health & Human Services (517) 335-8178 fax (517) 335-8509 xxxEND_PAGE:dhhs02_b0349_1297_1298_2

Okay, thanks, Bob. Hf incorporate the previous years and put the new results into a publisher document with some description of what’s going on in the chart. We'll find out ff this changes the results!

Cristin, toan safely say | don’t understand it without same explanation. However, late yesterday Nancy and | decided to take a look two years farther back to see how they fit with the recent years. Please see attached, which i just finished this marning. Sorry / didn’t have this for you yesterday before you did the analysis. Would this new information change the analysis? 2 xxxEND_PAGE:dhhs03_b0833_3004_3007_2 003006 Thariks, Bob

xxxEND_PAGE:dhhs02_b0237_0797_0885_16 000813 Okay, thanks, Bob. I'll incorporate the previous years and put the new results into a publisher document with some description of what's going on in the chart. We'll find out if this changes the results!