+EpiData Software - Examples

Instructive examples for inspiration to EpiData users

Order of files according to categories. Download counts since June 16th 2004 in [  ]. Publications from the examples are shown here

Basic Example - first
The "first example" files (QES/REC/CHK) used as example in EpiTour and Short overview documents.
View
15.Mar 2006
(3 Kb) [34262]
Download
16.Jun 2004
(1 Kb) [19806]

Relate example - Clinical Study with four forms
Working example of the structure for a Clinical study with a start, then by relating on id entering data into basic person information, sideeffects, status information and pre-study level.
Instruction
12.Nov 2007
(1 Kb) [17068]
Download
23.Dec 2008
(10 Kb) [16173]

Relate example - Household, Person, Visit
Working example of Household - Person - Visits based on Epi Info example file.
View
16.Jun 2004
(33 Kb) [17169]
Download
16.Jun 2004
(29 Kb) [14496]

Relate example - hospital infections - 3 examples
Patients in one file and infection related information in other files. Five related files and codes for fields in two separate files used with comment legal recfile. The systems can be used for routine reporting to the Dutch National Nosocomial Infection Surveillance System Prezies Description of how to enter data for the Surgical Site Infection system (POWI)
All files are in dutch, but principle and structure is clear without understanding the text

Provided by Louk Meertens, Netherlands.

Powi
15.Mar 2005
(1 Mb) [13118]
Hartop
16.Jun 2004
(86 Kb) [11760]

Sepsis
15.Mar 2005
(1.3 Mb) [12154]

Relate example - Multilevel, Village, Family, Person - Nutritional survey of region in Burkina Faso
Comprehensive example with several hierarchical levels of respondents. Also includes codes via comment legal command. When testing this system make sure you FILL OUT ALL RELATE FIELDS, Otherwise relate system does not function.
Provided by: Yves Martin-Prevel, Epidémiologiste (Institut de Recherche pour le Développement) Burkina Faso.
Publications from the study here

View
16.Jun 2004
(604 b) [14838]
Download
16.Jun 2004
(80 Kb) [13663]

Relate example - locking relate field
A template example where the field used for the relate is locked once a value has been entered. Provided by Louk Meertens, Netherlands.
Download
16.Jun 2004
(2 Kb) [12938]

Multiple Response - entry
An example of how to build a data entry file when you have 6 (7) possible responses and you wish to be able to enter any of them in an efficient way. Provided by Charity Jenkins, Australia.
View
21.Feb 2007
(13 Kb) [13291]
Download
21.Feb 2007
(2 Kb) [10978]

Read variables in file B during entry in file A
The example shows how to copy information from a "lookup" file B into a file A during entry. Three examples copying one, two and three variables by different principles are applied.
Download
02.May 2006
(9 Kb) [11324]

Use Radiobutton Variables (Boolean fields) during entry in file A
The example shows how to simulate (use) a Boolean type field during entry. The trick to doing this is to create Yes/No fields that cannot be entered using the tab or cursor keys. They can, however, be entered using the mouse. In this example, clicking in one of these fields will toggle the value of the field between "Y" and missing. Provided by J Hockin, Canada.
Download
08.Sep 2009
(2 Kb) [8502]

Comment Legal - combine with free values
An example of how to combine legal values, e.g. Denmark, France, Cameroun and then be allowed to enter Schwitzerland in the same field.
Download
16.Jun 2004
(1 Kb) [11525]

Comment legal recfile - Birds and tick names
An example of using the type comment for a Birds and tick names example. It includes three files one is the main file (ticks.rec), a file with scientific names of more of 100 bird species (aves.letter.rec) and another with scientific names of a few tick species (tick.letter.rec). Main file is: Ticks.rec
Provided by Jose Arturo (Saludos desde Mexico).
Download
16.Jun 2004
(8 Kb) [11625]

Comment legal recfile - Bacteria list
An example of getting a text from "comment legal" into a string field by looking up the numerical code in a different REC file. And to get the numerical code into a numerical field based on lookup of text (bacteria name).
Provided by by David Raveh, Israel.
Download
16.Jun 2004
(25 Kb) [11600]

Repeat with clear on change
Shows how to enter data for school and class levels, where school and class are repeated from previous record, but cleared when there is a change (based on a question "same school")
Download
21.Nov 2008
(924 b) [8484]

Calculation - percent
Percent calculation with decimal points after entry of two integers.
Download
16.Jun 2004
(952 b) [11817]

Age - Today
Calculate age in years today based on entry of date of birth
Download
16.Jun 2004
(599 b) [12384]

Age at day of visit
Calculate age in years, months and days based on entry of date of birth and date of a visit
Download
27.Jul 2007
(1 Kb) [9602]

Calculation - Week number
Calculate week based on entry of a date (works for years 1999-2004)
Download
16.Jun 2004
(811 b) [10943]

Calculator - confidence limits
Calculate confidence limits for a proportion with EpiData. See also javascript version
Provided by Kevin Sullivan, Univ. Emory. USA
View
16.Jun 2004
(24 Kb) [10483]
Download
16.Jun 2004
(3 Kb) [10922]
User Defined Functions in EpiData
Define "user defined functions" in chk files. Programmed by S.Mahmud. Two examples:
  • Gumm algoritm (By L.Hvidberg, J.Mortensen & A Skytthe. Institute of Public Health, Epidemiology University of Southern Denmark, Denmark)
  • Extended Soundex and Metaphone function (By S.Mahmud. Univ. of Mcguill, Montreaul, Canada)
General Description
27.Nov 2004
(13 Kb) [43336]
Source Code & examples
27.Nov 2004
(111 Kb) [43679]

Calculation and validation - cpr number check (in Danish)
(Danish: Fil til modulus 11 kontrol). Modulus 11 test of the danish personal registration number. Based on cross-sum of date of birth and a unique ID key a test must egual 0. Otherwise the key is wrong. Can be used to make a key file for unique ID's and cpr number.
Provided by Henrik Břggild, Denmark - explanation provided in english.
Value label error fixed (nov. 5th 2002)
View
16.Jun 2004
(25 Kb) [12658]
Download
16.Jun 2004
(14 Kb) [10957]

Explanation - MOD command
Extended explanation on using the MOD command
View
15.Mar 2006
(2 Kb) [14734]

What is a ZIP-file?

Submit more examples

To add examples here send a copy of REC/CHK and QES files to info@epidata.dk
REC files can be without records. Just seeing the REC/CHK files without data from others can be very instructive.
Address and e-mail of provider contained in the zip files, only names and country here (antispam e-mail measure).

How to work with Example files in EpiData ?

  1. Download the ZIP-file containing the example to a temporary directory/folder (e.g. c:\windows\temp).
  2. Extract the files in the ZIP-file using an unzip/extractor program.
  3. Start EpIData and open the example file

ZIP files A ZIP-file is an archive containing one or more single files. Zip files take up less space and are therefore faster to send via internet. They are compressed in size. You must extract the single files in a ZIP-file archive using an extract-program, e.g. tools menu in EpiData