Correspondence among

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

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