1 / 61

Epidemiologic Field Investigations using Epi Info:

Learning Objectives. By the end of this session, you should be able to:Create new Epi Info data tables using the WRITE commandUse the READ, WRITE and MERGE commands to combine Epi Info data tablesUse the RELATE command to combine related Epi Info data tablesUse the Visualize Data program to rena

jaimie
Download Presentation

Epidemiologic Field Investigations using Epi Info:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Epidemiologic Field Investigations using Epi Info:

    2. Learning Objectives By the end of this session, you should be able to: Create new Epi Info data tables using the WRITE command Use the READ, WRITE and MERGE commands to combine Epi Info data tables Use the RELATE command to combine related Epi Info data tables Use the Visualize Data program to rename and delete data tables

    3. WRITE Command The WRITE command is used to create new Epi Info data tables. The command sends records to an output table or file that you specify. One can specify which fields to include and specify the order of them. Reasons: To save temporary fields as part of a data table To isolate a subset of records To exclude selected variables To export data to another format (already seen)

    5. Change Project

    8. Change Data Format

    9. Change Data Source

    14. LIST the Data

    15. WRITE Data to a Table

    16. WRITE Specifications

    17. Append versus Replace If you are creating a new Data Table, select the Replace option. If the table already exists, select either the Append or Replace radio button.

    18. Command for WRITE

    19. READ in the New Data Table

    20. LIST the Data

    21. SELECT County=“Alameda”

    22. Analysis Output

    23. WRITE Selected Records to Table

    24. WRITE Command Syntax

    25. READ in the New Data Table

    26. Analysis Output

    27. MERGE Command MERGE command can be used to merge data into a second table to update matching records. MERGE command can also be used to append records from one table to another.

    28. MERGE/UPDATE/APPEND Example

    29. Combining Data Tables One can combine data files with the same file structure. One Data Table will be added to the bottom of the other Data Table.

    30. Data Table A

    31. Data Table B

    32. READ in Data Table A

    34. WRITE Data Table A to a Combined Table

    35. READ in Data Table B

    37. WRITE Data Table B to a Combined Table

    38. Data Table C

    39. Relating Data Tables Two Data Tables can be related to one another, provided that you know the relation. One field from one table relates to a separate field from the other table.

    40. Data Table D

    41. Data Table E

    42. READ in Data Table D

    44. RELATE Data Table D to Data Table E

    45. Build Key: Current Table

    46. Build Key: Related Table

    47. Relating Two Tables on Ptid

    48. RELATE Dialog Box

    49. Result of RELATE

    50. Data Table F

    51. WRITE Result to Data Table F

    52. Starting Visualize Data from Menu

    53. Open Epi Info Project

    54. Open MS Access Database

    55. Database Features

    56. Right-Click to Rename Data Tables

    57. View Data Table A

    58. SQL Query

    59. SQL Queries to JOIN Tables

    60. Query Result

    61. Summary of Topics Create new Epi Info data tables using the WRITE command Use the READ, WRITE and MERGE commands to combine Epi Info data tables Use the RELATE command to combine related Epi Info data tables Use the Visualize Data program to manipulate data

More Related