EpiInfoEpiInfo274-25(010)63173960(010)63173345Email@263.netEpiInfoPage2of200Page3of200Page4of200Page5of200Page6of200Page7of200Page8of200Page9of200EpiEpiInfoEpiInfo20002002EpiInfoCDCCDC2004411CDCEpiInfo20023.2.2EpiData3.0EpiDataEpiInfoDOSEpiDataEpiInfoEpiInfo()E-mailwangjs@chinacdc.net.cnEpiInfoüEpiInfo2002üEpiInfo2002ACESS*.MDBMDBüEXCELsheet1sheet2sheet3a.EpiInfo200211b.2Page11of2002c.3exampleEpiInfo2002EpiInfo20023d.example4EpiInfoPage12of200familyfamilyexample4a.5615b.6c.Page13of200d.6Title1Label/TitleTitle2Label/TitleIDNumberSizeNumber1NameTextGenderNumberEduOpitionEmailEmailTextAddressViewdate//1ü7üüüa.Page14of2007a.1PageüEpiInfo2002a.b._____________E-mail________________________________________________________________________________________________Page15of200Title3Label/TitleBirthdayDateYYYY-MM-DDAgeNumber##,MarriageTextSidTextSmokeYes/NoDrinkYes/Noc.üEpiInfo2002a.b.88Page16of2009üüa.61010b.11Page17of20011c.d.a.b.üüüEPI2000üEPI2002ü12Page18of20012üa.b.ü1313Page19of200ü14ü14(ASSIGN)a.b.viewdate…c.Assign15d.AGEe.EpiInfo2002YearsPage20of20015AssignüYearsAge=Years(birthday,viewdate)f.ü1871001900üEpiInfo2002SUBSTRINGSubstring(Variable/,Pos1,Char#)üVariablePos1Char#Substring(“EpiInfo”,5,4)EpiInfo54Infoa.71019002000b.1019002000Page21of200DIALOGc.IFsubstring(Sid,7,4)1900ORsubstring(Sid,7,4)2000THENDIALOGTITLETEXT=GOTOSidENDPage22of200---45a..MDBb.16.MDB16a.EPI2002EPI200217Page23of20017b.1818c.d.e.Page24of200üüa.1919b.19EPI20026c.2020Page25of200,-EpiInfo20022Examplea.b.smokinforelate2121a.21yes22Page26of20022b.YESsmokesmoke=YesSmoke=Yesc.d.2323a.b.AltShiftCtrlAltShiftCtrlc.Page27of20023a.Ctrlb.:SmokeqNumberCentered,Bold,18YearsNumber##buweiTextJieyanNumber0-1reasonoptionsüüüüüüPage28of200üüüEpiInfoüSmokinfoSmokinfoüUniquekeyFkeyüUniqueKeyFkeyüRecgridFkeyüUniquekeyFkeyüUniquekey12...Page29of200--,2152517227224524Page30of20024EpiInfoEpiInfoEpiInfoDIALOGDialog14Dialog2525DialogPage31of200Dialog025Epi20022626Dialog12130230111302301413023011Epi200227*.../...Page32of200-4528üEpiInfoüüEpiInfo2002ReadRead29EPIEpiEpiInfo2002Page33of200Epi2002Sample.mdbOswegoViewOswego287529ListList3030EPI200231EPIwebPage34of200*31Sort32List32SelectSelect33Page35of20033ListWriteSelect6060ReadSelectEXCELACCESSEpiInfo2002EpiInfo2002EXCELEXCELEpiInfo2002Write34Page36of20034AccessEpi2002ExcelEpi6Page37of20030%70%10030%70%1550155112353536EpiInfoEpiInfoPage38of20036373738EpiInfo*.MDBMDBPage39of2003839EpiInfo4039Page40of2004041EpiInfo4241Page41of200UnmatchedRecords434243Page42of200EpiInfo2002define,recode,assign,merge,write:-writeMerge::45:qReadqRelateqIfThenRefugee.mdbEpiInfo2002Refugee.MDBFAMIDNUMBOHEntryMiami,NewYork,Chicago,LosAngelesEntryCaliforniaCaliforniaCANewYork“NY”FamilyTBLabsAssmntPatientPage43of200Refugee.mdbviewFamilya.AnalyzeDataRefugee.mdbRead(Import)viewFamilyentrya.FrequenciesEntryNEXTPROCEDUREENTRYFrequencyPercentCumPercentAL20.4%0.4%CA10.2%0.6%CALIFORNIA6713.1%13.7%CHICAGO5310.4%24.0%FL10.2%24.2%IL91.8%26.0%LA10.2%26.2%LOSANGELES61.2%27.3%MIAMI10.2%27.5%NEWYORK24848.4%76.0%NY12324.0%100.0%Total512100.0%100.0%EntryüEntryALCAILFLNYCHMIüRecodea.Defineb.NewEntrystandardPage44of200üNewEntryEntryNewEntryc.Recoded.FromEntryToNewEntryüEntryNewEntryEntrye.EntryNewEntryüEntryf.EntryNewEntryOKRecode(NewEntryFrequency)assignPage45of200üNewEntryAssignNewEntryEntrya.Assignb.AssignVariableEntryAvailableVariableNewEntryOKüNewEntryEntryEntryWriteüDefineRecodenewentryüWrite(Export)a.Write(Export)b.OutputModeReplaceFileNameRefugee.MDBDataTableEntryfixedRefugee.MDBEntryfixedPage46of200c.Read(Import)EntryfixedSHOWAlld.ListMergingthechangesüViewFamilyEntryfixeda.EntryfixedViewFamilyViewFamilyb.MergeEntryfixedPage47of200c.BuildKeyCurrenttablesRelatedtablesFamidnumOKPage48of200d.MergeAppendUpdateUpdateOKEntrye.ReadviewFamilyEntryExercise.MDBwlp1,wlp2ID152BMI3IDPage49of200Page50of2003Means,tFrequencies,Tables,MatchTables2MatchIF-THENRECODE,ASSIGN,IF-THEN,EpiInfo20023:-HEADERS,ROUTEOUTTYPE-.PGMs::1üEpiInfo2002HTML(HTM)out.htmoutCloseoutReadCloseout1üRouteoutüResultsLibraryResultsLibrarya.ReadviewsmokePage51of200b.OutputRouteOutOutputFilenameSmokingReportc.ReplaceanyexistingfileOKCloseoutSmokingReport.htmResultsLibraryResultsLibraryPage52of200RouteOutüHeader()a.HeaderTitleLineTitleFontColor,FontSizeOK().5.10Headerb.Header0Teal1SmokingReport2SexandSmoking,7,3SmokingTable,4,Page53of2004AnalysisofData3,5SmokingSex,3,Frequenciesa.FrequenciesFrequencyofOKb.StratifybyOKc.Weight123450Page54of200üHeader12040160501101603smoke,cancer,f,FrequenciesPage55of200OK,=0FrequencyPercentCumPercent011068.8%68.8%15031.3%100.0%Total160100.0%100.0%95%ConfLimits061.0%75.8%124.2%39.0%,=1FrequencyPercentCumPercent04025.0%25.0%112075.0%100.0%Total160100.0%100.0%95%ConfLimits018.5%32.4%167.6%81.5%75.0%31.3%95%Page56of200Meansa.MeansMeansofOKb.c.Weight240groupsexF9.8121MeansPage57of200OKDESCRIPTIVESTATISTICSFOREACHVALUEOFCROSSTABVARIABLEObsTotalMeanVarianceStdDevA1201178.71009.82262.87051.6943