EpiData Analysis

Versión: 19 de Enero de 2006

Funcionalidades a incluir o mejorar en versiones futuras

• Odds Ratios y RR en tablas con ceros en alguna de las celdas.
• La orden Correlate genera un mensaje "erro de punto flotante" cuando la correlación no puede ser calculada.
• El contenido de una cadena de texto debería ser convetido a MAYúSCULAS en algunas condiciones para trabajar adecuadamente. por ejemplo: count if upper(v) = "TEST"
• Un nuevo principio reemplazando el "setting format" se desarrollará
• Debe implementarse un Tests de homogeneidad (interacción) en el análisis estratificado de tablas 2x2
• Las órdenes Means y Kwallis no permiten el uso de variables de texto como variable de agrupación
• Los porcentajes en los gráficos de tarta no son siempre correctos.

último "build"

Versión 1.1.2 build 62

• Se ha invertido el principio para evitar que el programa pueda ejecutarse dos veces:
  Ahora: el archivo preventdouble.ea se isntala en todas las versiones sobre winXP+
     Los usuarios pueden borrar este archivo si desean ejecutar varias veces simultáneamente el programa
  Antes: el archivo rundouble.ini debía ser creado en todas las versiones

Anteriores a la última

Version 1.1.1 at build 62

• Las ayudas se muestran en una ventana independiente
  • Pulse F1 para ver el archivo de ayuda en una ventana independiente
  • Sistema de ayuda específico para las órdenes (para algunas puede no estar implementado):
    escriba "command" en la línea de órdenes y pulse F1
    Si la orden para la que está buscando ayuda no tiene un fichero específico se abrirá el archivo de ayuda general
  • Muestra un archivo de ayuda especifico en una ventana: help xxx
• Se ha modificado la estructura del fichero de resultados
  • Fichero de resultados activado al incio del programa EAoutput.htm
  • Saveoutput - lo mismo que logopen
  • CloseOutput - lo mismo que logclose
  • "Set stylesheet external=on[off]"
    cuando está en OFF se incluye una copia de la hoja de estilo en el archivo de resultados.
    cuando está ON se incluye una llamada (enlace) a la hoja de estilo
• El usuario puede controlar si desea permitir que el Analysis pueda ser ejecutado mas de una vez
• Comandos modificados
  • Selección tempral: El "if" debe colocarse al final de la orden
    excepción: select and count "if" must follow select/count
• Nuevas órdenes
  • aggregate (Forma corta: agg) - crea datos agregados (datos colapsados)
  • stattables (Froma corta:stattab) - Tablas de N x M
  • label variables (Etiqueta la con un "text" )
  • labeldata "text" (Etiqueta el archivo de datos)
• órdenes mejoradas
  • Graphs
    • SPC charts: Test1 modificado Run Charts
    • SPC charts: Se permiten valores missing en la variable "count"
    • SPC graphs - Se muestran los test en una tabla
    • Graphs: se añade la opción de texto del eje Y: /Ytext=
    • Graphs: Se añade la opción de texto del eje X: /Xtext= (por defecto se usa la etiqueta de la variable X)
    • Por defecto se coloran las graficas de barras: cada barra un color
    • "Set graph colour" definee el color de las barras del gráfico (valor por defecto: 123456)
    • "Set graph filename show" Add name of graph file below the graph - default = off
    • "Set graph filename folder" Add complete folder for graph file to html output - default = off
  • Variable label addition to tables, graphs etc. controlled with "set var label" and "set var name"
  • ERASEPNG - new option added: /ALL (will include all png files, without only graph*.png are included)
  • Frequency tables
    • Variable label added
    • Cumulative percentage
    • Options D0 D1 (zero or one decimal on percentage)
    • NC - no cumulative percentage
  • F8 now activates file indicated in "Set start page"
  • Link to introduction pdf file added to help menu
  • Right mouse click on variable (F3 window) shows all variable definitions
  • "Results" sufficient for "var results"
  • "results clear" sufficient for "var temp clear"
• Modifications to set
  • "Set window font size" defines size of "F3/F2/F7" windows on right side of screen
  • "Set editor font size" defines size of font in editor
  • "Set Command History" changed to "Set History Command add" (add pgm commands to history)
  • "set HISTORY COMMAND PGM" default is now OFF -
    on: add all commands in a pgm to history
  • "set RECODE INTERVAL TEXT" the string inserted with "recode to", default "-"
  • "set Generate type" changed to "Var generate type" (Default type for variable generation)
• Bugs fixed:
  • Copy and Paste from output window to editor or command prompt was not working
  • Various small formatting or parsing bugs (e.g. copyfile with spaces in filenames)
  • error with parsing of if command - which could replace data
  • Means group error with one observation in a group

Version 1.0 at build 43

• Added or modified
  • Release number removed - only version and build shown from now on
  • Possible to run Exe file without any other file (Graphs will not work)
• Bugs fixed:
  • Define in CHK files are accepted
  • Conditions for test 2 in SPC charts adapted
  • Empty lines at top of text type logfiles removed
  • TAB in pasted lines into editor changed to spaces

Version 1.0 release 0 build 40

• Added or modified
  • Refined style sheets for output
  • Reference to observations must be in []
  • Observation (record number) can be referenced with _n. E.g. age[_n -1]
  • Introduction document added to installation
  • Error given if group variable in means or kwallis is of type string
• Bugs fixed:
  • Certain if statements not parsed correctly
  • Append with records marked for deletion.

Version 0.9 release 6 build 39

• Added or modified
  • Refined style sheets for output
• Bugs fixed:
  • Marginal percentages with etab command.
  • Append with records marked for deletion.
  • Headers for "first word" rec files could be wrong in some instances

Version 0.9 release 6 build 38

• Added or modified
  • Tables will have collapsed borders
  • Chi² are ALL uncorrected values now (except for MH summary)
• Bugs fixed:
  • Chi² values for very large numbers could be wrong
  • Append with records marked for deletion.

Version 0.9 release 5 build 37

• Added or modified
  • Documentation revised and clarified (output definition)
  • Added to help menu: Edit setup file (epidatastat.ini)

Version 0.9 release 5 build 36

• Added or modified
  • A "select font" on first startup to guide the user for efficient setup of screen
  • Improved documentation of output formation
  • Table command can show categories defined as missing
  • New option controls if more than one instance of the programme can run
  • Aspects of handling missing value further implemented.
  • Parsing of strings changed to exclude trailing blanks: e.g "Lion " is the same as "Lion", but not the same as " Lion".
  • sorting of tables corrected
  • Tests of homogeneity (interaction) in summary stratified 2x2 tables removed until final stable solution is found
• Bugs fixed:
  • "Pointer error" in tables or describe fixed
  • Error in table estimates for 2x2 tables
  • Recnumber now returns number within current select
  • set listrec was not working

Version 0.9 release 5 build 28-35

Not available for public testing. Different strategies to solve bugs were tested.

Version 0.9 release 5 build 27

(This is a minor release.)

• Added or modified
  • Version now also reads a comment from http://www.epidata.dk
• Bugs fixed:
  • Emin in Tables also checked marginal totals

Version 0.9 release 5 build 26

• Added or modified
  • This is a major release. Release number introduced again. Builds will indicate smaller changes
  • Reading of data files and chk files final (see note on recnumber definition above)
  • Two table commands are now working: Tables (for general tabulation) and Etables (Epidemiology tables)
  • Several Output class definitions in one line allowed (separate with ,)
  • Improved command history window (F7)
  • Notice: Graphs showing as ! in output window is not a bug, but due to shift in folder from where graph file is.
  • comparing a string variable to a constant will remove trailing blanks, e.g. "test of" = "test of "
• Bug removal:
  • Table command - thorough testing of correctness of estimates and inverting tables.
  • Table stratified - estimates for subtables fixed. Command changed to etab
    Faulty calculation of summarised RR and OR, plus tests of interaction - fixed
  • Processor dependent parsing of count and if (serious bug, difficult to catch and solve)
  • Boolean variables corrected (Y N and . read correctly)

Version 0.9 build 23-25

• Internal builds to find solutions for serious bugs on some PC's

Version 0.9 build 22

• Added or modified
  • Reading of data files and chk files final (see note on recnumber definition above)
  • Output adapted to W3c (www.w3c.org) standards, see pdf file in "docs" subfolder.
  • Simplification of control of what is shown (commands, info, results): set show definitions
    Note some inconsistencies are still there
  • set parameter for table design added
  • Reading of files with encrypted fields (prompt for password or add /key)
  • Major commands can be used with first three letters
  • Reading of missingvalue definitions
  • Output changed to tables (improves speed)
  • Several interface adaptations
  • Added command history window (F7)
  • Much improved examples on opening pages
  • Improved reporting on append
• Bug removal:
  • Crash when selecting block in output fixed.

Version 0.9 build 21

• Added or modified
  • Added row column total percent with special formatting of each
  • Enhanced find function
  • Command Prompt can be invisible (but exists)
  • Faster output for variable and directory lists
  • Max cases for Correlate and Regression increased to 5000
  • command CORRELATE correctly rejects when number of observations > 5000
  • Various other refinements of interface

Version 0.9 build 20

• Added or modified
  • set parameter for save pgm file changed to "Set history name="
  • Illegal national characters in field names replaced on reading
  • Improved feedback with append files (when structure is different)
• Bug removal:
  • Option Quiet in describe reversed /q=show lacking: hide output.

Version 0.9 build 19

• Added or modified
  • set parameters unified (NOTE MANY CHANGES)
  • note that to invert 2x2 tables use "set table epi=on"
  • output and selection of estimates from tables command
• Bug removal and modification:
  • table command labels and inversion incorrect in b18 (fixed)

Version 0.9 build 18

• New
  • search in output window and help files
  • APPEND command: add data from other files of same structure
  • option /quiet or /q added to means and describe
  • Reading data can be stopped by ESC
  • PgUp and PgDn moves output up and down.
  • Several options to control table output (rr or percents)
  • Tables with 2x2 data are inverted if OR or RR requested
• Added or modified
  • headers corrected when writing data files
  • testing routines finetuned (try "runtest validate")
  • Internal representation of float variables finalised
  • Negative values in recode possible
  • Assert and Assert error internal variables not reset after means,describe and count
  • Deleted Record Status obeyed when reading data (set readdeleted=off|on)
• Bug removal and modification:
  • Blank output screen after cls fixed

Version 0.9 build 17

For few hours a prebuild 17 could not show graphs

• Added or modified
  • Internal representation of float variable enhanced
  • Table output adapted (Odds Ratio's)
• Bug removal and modification:
  • Creation of boolean fields fixed
  • Negative values in result variables fixed for mean

Version 0.9 build 16

• Added or modified
  • update shows which values are changed with if statements.
  • if started with a pgm file, that file will be executed.
  • internal representation of float variable changed from double to extended
  • Testsystem improved (e.g. try startnist.pgm)
• Bug removal and modification:
  • String variables of length 1 are saved correctly
  • negative values in result variables fixed
  • lre() function corrected for negative values
  • Calculation of 10,25,75 and 90 percentiles corrected
  • recode function corrected to include limits btw. groups
  • Various interface problems
• Documentation
  • Adapted Commands.htm and Howto.htm file.

Version 0.9 build 15

• Added or modified
  • Graph button on workprocess toolbar working again (bug introduced in build 14).
  • Number on button 4 removed (lacked removal in build 14)

Version 0.9 build 14

• Added or modified
  • Warning on Chi value imprecision for N>950 in kwallis
  • Adapted work process toolbar and menus
  • bar graphs now show value labels at bottom
  • runtest command gives table of results
  • set allstats changed to allstatistics
• Bug removal and modification:
  • Parsing of strings "a "+"b"="a b"
  • Variable On parsing several variables to freq or describe "a no data" error could should up if one variable was all missing.
  • Variable lists extended (e.g. freq a-d)
  • Confidence intervals: mean+/- 1.96*sqrt(Variance/N) (was not always correct)
  • Median corrected.
• Documentation
  • Adapted Commands.htm and Howto.htm file.

Version 0.9 build 13

• Added
  • set: set Viewer Font Charset= (to accomodate Chinese characters)
  • User configurable window placements (saved in epidatascreen.ini)
  • New command: eraseallpng /NOCONFIRM (will erase all graph????????????.png files)
  • Graph font size specification: set graphfontsize= (default pitch 10)
• Bug removal and modification:
  • Access violation when creating graphs
  • On parsing several variables to freq or describe "a no data" error could should up if one variable was all missing.
  • Browser now shows only selected records
  • Various smaller bugs or adaptations
• Documentation
  • Adapted Commands.htm and Howto.htm file.

Version 0.9 build 12

• Added: /append and /close parameters for logfiles
• Bug removal:
  • Incorrect autosaving of pgm files (did not read parameter)
• Documentation
  • Adapted Commands.htm file.

Version 0.9 build 11

• Added set: set labelshow= on/off/both (shows valuelabels, values or both in tables)
• "How to.." and "commands" added to help menu
• Adaptation:
  • Added variable names and labels in tables
• Bug removal:
  • Incorrect values with describe for median and percentiles
  • Frequency tables incorrect with several variables
  • Incorrect return of select prompting: select age < (?what age?)
  • access violation if trying to define variables and no data file open
  • defining dates are now dates e.g.: define d
• Documentation
  • Adapted Commands.htm file.

Version 0.9 build 10

• Added close option to read, e.g. read "testdata\bromar.rec" /close
• Adaptation:
  • 45 degree x labels on SPC graphs as default
  • Tickmarks on all graphs except with /NOXTICK /NOYTICK
  • A pre build 10 existed for a few hours without these two:
    1 Replacing datafile with savedata controlled by set replacedatafile
    2 Replacing graph file controlled by set graphreplacefile
• Bug removal:
  • Regress now activated by workprocess toolbar. (was desribe)
  • Naming of autosaved graph files changed (could contain :)
  • Minor interface bugs - e.g. adding of double click to F2 window
  • Main Menu file submenu now acts with close
• Documentation
  • Adapted Commands.htm file. Introduced howto.htm with suggestions.

Version 0.9 build 9

• Fixed bug which showed Field Type wrong in F3 window for byte (string 1) variables
• Fixed bug when using byte variables in describe command
• Adapted info.htm opening file

Versión 0.9 build 8

• Se finaliza el diálogo de la orden Graph (aunque quedan aspectos del control de ejes sin fijar)
• Nuevos cambios en lectura de datos - reconocimiento de formatos - en archivos delimitados
• Se soluciona un problema con valores issing en las distribuciones de frecuencia
• Adaptation - information - to users when reading errors in data
• Adapted info.htm opening file

Version 0.9 build 7

• Graph dialog introduced
• Changes of reading - recognicing formats - in delimited data files

Situación entre versión 0.9 build 1 a build 6

• Se reestructura completamente el rpograma para hacerlo mas inteligible y separar la interface de las órdenes.
• Se inicia el desarrollo de gráficos de control de procesos en colaboración con Gruk Norway
• Se termina la definción de la interface - menú para principiantes y línea de órdenes para usuarios avanzados.
• Comienzo de las pruebas

Situación en versión 0.9.0

• Desafortunadamente Salah Mahmud debe dejar de participar en eld esarrollo debido a otros compromisos en Otoño de 2003. Lo realizado por Salah Mahmud hasta este momento constituye una parte clave en e desarrollo del proyecto. Por eso se hace referencia específica a esta parte de forma separada. Salah también contribuyó a a partes de la documentación.

Primeros desarrollos

Versiones anteriores a la 0.9

• Nuevas órdenes
  • Orden Loop, permite ejecutar un a orden o bloque de ordenes repetidamente
  • Orden View, permite mostrar un archivo HTML en la ventana de resultados.

• Nuevas funciones/variables de sistema
  • Sysdir: Variable de sistema, devuelve el path a la carpeta que contiene EpiData Analysis (EpiDataStat.exe
  • El nuevo editor de programas es ahora funcional
  • Mejoras en la ventana de resultados, se permite copiar HTML al portapapeles y moverse entre diferentes documentos abiertos como si fuese un Navegador de Internet

• Mejoras en la dinámica de los órdenes

• Lectura y escritura de datos
  • Epianalysis puede leer todos los tipos de datos introducidos en la versión 2.2 de Epidata Entry (los campos encriptados se ignoran)

• Optimización
  • La lectura de archivos REC es ahora algo más rápida
  • La tabulación de variables de texto con un solo caracter(por ejemplo sexo=[M,F]) es tna rápida como la tabulación de variables booleanas o numéricas