Patricia Mckane

Manager at Michigan DHHS Maternal & Child Health Epidemiology Section / DHHS

Also known as Mckane, Patricia

112

Emails

Jul 2015–Dec 2015

Archive range

112 emails found.

Re: 2014 lead data

To
Unknown recipient
It sounds like they didn't use the numbers that Yan and | provided. | sent the 2014 files that we worked on to reconcile with Bob's last week. Glad that the data have been sent to the reporter. Did Junaid get access to the Lead Screening data? Sent from my iPhone

Flint Situation/ Medicaid Data

When: Wednesday, December 16, 2015 1:30 PM-2:30 PM (UTC-05:00) Eastern Time (US & Canada). Where: 877-873-8017; 7931338 Scheduling per Corinne Miller’s request. Corinne will dial in as the host. Those located in Capitol View Bldg. are welcome to join the call in her office. 877-873-8017 Passcode: 7931338 Dec 16" (Wed) 1-2PM Thank you! Jasnese Bowlery Executive Secretary te Corinne Miler Sureau of Disexse Control, Prevention and Epidemiology MMehigan Department of Health & Mumen Services 203 Townsend Straat Lansing, Michigan 42923 Phone: (S17) S55-8734 Faw: (S27) 335-8285 << OLE Object: Picture (Device Independent Bitmap) >> xxxEND_PAGE:dhhs03_b0475_1725_1726_2

RE: 2014 lead data

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

RE: 2014 lead data

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

RE: 2014 lead data

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

Lead report

Can | send Linda the lead report for 12/7? This is the update, not the zip. Thanks, Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemioiagy Section |Michigan Department of Health and Human Services| Lifecourse Epidemiology and Genomics Division [PQ Box 30195 / 201 Townsend St 4" Floor - Lansing, MI 48909 | Cell ‘ PPI H {Office 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 xxxEND_PAGE:dhhs02_b0611_2223_2224_1 002224 eenttofded in this CATH is expressly protibéted. if you are nett the intetnied recipient, phease eentdct the sender by reply e-rrril/ att! destroy any aid all copies of the orginal message. xxxEND_PAGE:dhhs02_b0611_2223_2224_2

2014 Lead

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

Showing 1-25 of 112

...