select command in EpiData Analysis 3.3.0.0 r617
Caution! This message was sent from outside the University of Manitoba.
Di 01 fév 2026 Bonsoir, I need to understand how to use the select command in EpiData Analysis 3.3.0.0 r617; I tried the following:
.select Sexe<>"Inconnu" do;
Selecting, please wait... (25951 of 26097 selected)
Then:
.freq Sexe;
Sexe ──────────────── N ──────────────── Féminin 11973 Inconnu 146 Masculin 13978 ──────────────── Total 26097 ────────────────
The selection doesn’t apply to the database, even if the previous message said so; it’s unfortunate because further analysis of the data should apply to the selected records. I didn’t find explanations about select in the help file (how to apply it and how to cancel it); do you have some answers about this? Cordialement, Réjean Réjean Dion, M.D. Médecin-conseil en santé publique (maladies infectieuses) Laboratoire de santé publique du Québec (LSPQ), Institut national de santé publique du Québec (INSPQ) 20045, chemin Sainte-Marie, Sainte-Anne-de-Bellevue (Québec) H9X 3R5 INSPQ Centre d'expertise et de référence en santé publique URL: http://www.inspq.qc.ca/ Professeur adjoint de clinique Département de médecine sociale et préventive (DMSP), École de santé publique de l’Université de Montréal (ESPUM) Membre actif Département de médecine préventive et de santé publique (DMPSP), Centre hospitalier de l’Université de Montréal (CHUM) Tél.: 514-457-2070 poste 2325 Fax: 514-457-6346 Courriel: rejean.dion@inspq.qc.ca
Caution! This message was sent from outside the University of Manitoba.
Bonjour mon ami,
If you are typing a command directly, then everything must be on one line:
select sexe<>”Inconnu” do freq sexe;
The command interpreter always adds a semicolon at the end of a line, so if you try to do this in two lines it becomes
select sexe<>”Inconnu” do;
Which does nothing after the select.
In a program, you can write this on two lines.
Here is the help for select, which should be in the next release. Jamie Select records
select (<condition>) do <command> select (<condition>) do begin <command block> end;
Select a subset of records for the subsequent command or command block. The selection only has effect for this commands or commands. Unlike in classic EpiData, the selection is not retained.
parameters
* condition can be any logical condition that compares individual data values * command may be any command that operates on data except for save * command block is a group of commands, each of which must end with a semicolon, as in any program
example
// get the epicurve for children under 18 select (age < 18) do epicurve onsetdate; // get mean age and a food-specific attack rate table for men only select (gender="M") do begin means age; ctable ill food1-food5 !ar; end;
On Feb 1, 2026, at 6:48 PM, EpiData support and user community epidata-list@lists.umanitoba.ca wrote:
I need to understand how to use the select command in EpiData Analysis 3.3.0.0 r617; I tried the following:
.select Sexe<>"Inconnu" do;
Selecting, please wait... (25951 of 26097 selected)
Then:
.freq Sexe;
Sexe ──────────────── N ──────────────── Féminin 11973 Inconnu 146 Masculin 13978 ──────────────── Total 26097 ────────────────
The selection doesn’t apply to the database, even if the previous message said so; it’s unfortunate because further analysis of the data should apply to the selected records. I didn’t find explanations about select in the help file (how to apply it and how to cancel it); do you have some answers about this? Cordialement, Réjean
participants (1)
-
EpiData support and user community