[EpiData-list] Condensing several Y/N results into one table

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Fri Oct 10 06:07:45 CDT 2014

Dear list,

I try to condense the frequency of several yes/no variables into one table:

In a patient file I register 12 specific procedures, where each patient get
a variable number of "yes" i.e.

  N %
Y 126 27.8
. 328 72.2
Total 454 100.0

Pain relief
  N %
Y 113 24.9
. 341 75.1
Total 454 100.0


I want to transform the result into:

Treatment summary
                                          N     %
Intravenous antibiotics 126 27.8
Pain relief                         113 24.9
Total 454 100.0

In the old Epi Info v6 this was relatively simple via the REPORT command,
where a template .RPT file could pick specific values from tablecells
across several variables.

I can copy and paste values from individual tables into a spreadsheet, but
it would obviosly be more user-friendly to a routine user to be able to
present the result in EpiData.directly.

Any suggestions?

Best regards,
Vegard Hogli
CMO, Skien, Norway

More information about the EpiData-list mailing list