Epi Info™ 7 Training Software for Public Health

1. Epi Info™ 7 TrainingSoftware for Public Health Jose J. Aponte Public Health Advisor Course Title: Using Epi Info™ 7 Using Classic Analysis for Data Management March 27 2012 Office of Surveillance, Epidemiology, and Laboratory Services Epidemiology and Analysis Program Office

2. Module 6 Outline • Analysis PowerPoint Slide Presentation • Instructor demonstration – Classic Analysis Basics • Students practice • End of Lesson Questions

3. Introduction to Classic Analysis • Classic Analysis is a program for manipulating, managing, and analyzing data. • Classic Analysis acts as a statistical toolbox providing many ways to transform data and perform statistical analysis. • Data can be selected, sorted, listed, or manipulated with a series of commands, functions, and operators.

4. Introduction to Classic Analysis • Classic Analysis reads data files created in Form Designer and other types of databases such as MS Access, MS Excel, SQL Server and ASCII. • Graphs can also be produced from Classic Analysis to present graphic representations of data.

5. Command Tree Output Program Editor The Classic Analysis Workspace

6. Using the READ command • In order to analyze data, you must Read or Import a project into the Classic Analysis module. • The Read command allows you to select a project or data table on which to run your statistics. • The Read/Import command will be used every time you open the Classic Analysis module in order to begin work.

7. READ dialog

8. Using the READ command • From the READ dialog box, you will select an Epi Info 7 project containing data for analyses. • For other data sources, you will select the actual file desired. • Recent Data Sources allows rapid access of data files loaded on previous sessions of Analysis.

9. Using the READ command • Database Type – Select data format for the data to be read, for example MS Excel 97-2003. • For Epi Info 7 projects, you can select Forms and Tables • Data Source – File Location (i.e. C:\Temp) • When you click Ok, the READ command will be saved in the Program Editor and it will run the command at the same time. • Save Only - allows you to save the command to the Program Editor only and does not run the READ command.

10. Using the LIST command • The output generated from a LIST command can be generated in two different formats; GRIDTABLE and HTML. • Select GRID (default) for GRIDTABLE format. • Select PRINTABLE/EXPORTABLE for HTML format.

11. Using the LIST command • The LIST command creates a line listing of the current dataset. • Select specific variables from the Variables drop-down to narrow the list. • Select variables to exclude from listing LIST * GRIDTABLE LIST LastNameFirstName DOB AgeGRIDTABLE LIST * EXCEPT CaseIdCellPhonePatientAddressGRIDTABLE

12. Using the SORT command • The SORT command allows you to specify the sequence in which records will appear. • If more than one variable is selected, records are sorted in order by the first variable. • You must use the LIST command to see the results. • Records remain sorted until you close Classic Analysis, Read in a new dataset, or Cancel Sort SORT DOB Sex SORT

13. Using SELECT command • Allows specifying criteria for sub setting data. • Once you make a selection, it affects all the analyses that follows. • Selections accumulate. SELECTDOB>12/31/1984 SELECTDOB>12/31/1984SELECTSex=“M-Male“ Select Criteria: (DOB > 12/31/1994 ) AND (Sex = “M-Male”)

14. Using SELECT command • Selections are active until you Cancel Select, close Analysis, or Read in a new project. SELECT

15. Questions? The findings and conclusions in this report are those of the authors and do not necessarily represent the official position of the Centers for Disease Control and Prevention. Office of Surveillance, Epidemiology, and Laboratory Services Epidemiology and Analysis Program Office