- EpiData-list - University of Manitoba Mailing Lists

Re: [EpiData-list] Graphing results of outcome analysis showing CIs
by epidata-list＠lists.umanitoba.ca 05 Oct '09

05 Oct '09

Thanks Jamie I tried this and it worked well. It was quite easy to copy the Attack rate table into Excel. I just highlighted the data in the htm file and pasted it into a black worksheet. Then I 1. used data/text to columns to separate out the confidence interval colum into two columns (low and high) 2. Used edit replace to take out the brackets 4. Change the order of the columns to LowCI HighCI RR 3. Selected the data to make a chart 4. Chose stock chart 5. I also chose the option to include the data table within the chart The graph does not look as good as CIplot but does look pretty good. many thanks Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 >>> <epidata-list(a)lists.umanitoba.ca> 6/10/2009 2:28 a.m. >>> Hi Christine, CIPLOT is showing proportions, not RR. I think you will have to create your own chart in another package. You can import the attack rate table into excel and with a bit of manipulation, get the columns in the right order for a "stock chart" - stock chart uses the order Close, High, Low, where Close will be RR, High will be UCL and Low will be LCL. However, you will have to do some formatting to do to get the chart looking as good as CIPLOT. Jamie Hockin Christine wrote > Does anyone have a tip for the best and easiest way to graph the results of the attack rate table for an outbreak analysis including confidence intervals? I have run the outbreak analysis and generated the attack rate table > (TAB CASE 1 OYSTERS PRAWNS CHICKEN etc OA/ex), This is great. BUT... > > Now I have been asked to show all the exposures with relative risks higher than 2 and CIs that don't include 1 (of which there are about 10) on a single graph. The graph must show relative risk, lower confidence interval and higher confidence interval for each exposure. I have looked at the CI graph in Epidata Analysis but > a) I only want the total and the CIPLOT graph shows Yes and No as well as total > b) I want to show more than one exposure on the same graph and I don't think I can do this with the CI. > -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 0

Graphing results of outcome analysis showing CIs
by epidata-list＠lists.umanitoba.ca 05 Oct '09

05 Oct '09

Hi Does anyone have a tip for the best and easiest way to graph the results of the attack rate table for an outbreak analysis including confidence intervals? I have run the outbreak analysis and generated the attack rate table (TAB CASE 1 OYSTERS PRAWNS CHICKEN etc OA/ex), This is great. BUT... Now I have been asked to show all the exposures with relative risks higher than 2 and CIs that don't include 1 (of which there are about 10) on a single graph. The graph must show relative risk, lower confidence interval and higher confidence interval for each exposure. I have looked at the CI graph in Epidata Analysis but a) I only want the total and the CIPLOT graph shows Yes and No as well as total b) I want to show more than one exposure on the same graph and I don't think I can do this with the CI. Any help much appreciated. thanks Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 2

New data format for testing and comments - tests needed
by epidata-list＠lists.umanitoba.ca 02 Oct '09

02 Oct '09

An exiting phase of development is now ready for general comments and testing. In june/july of this year the first cross platform experiments were available published on the testing page http://www.epidata.dk/testing.php Crossplatform function must solve aspects such as: - many different local character sets - different standards for physical file formats - the user should not do anything special when sending or receiving files created on another operating system On top of this another issue is coming up soon - the development of a dedicated data entry module also allowing for GCP (Good Clinical Practice) rules of transaction logging. Therefore we have now experimented with development and specification of a file format which contains as well the data as the metadata needed for understanding the data. By doing so we are moving towards a new structure: a. Datafile containing datadefinition and data. (parts of current rec and chk file). Suggested extension: recxml b. Dataentry definition file containing control during entry (e.g. relate, range, mustenter etc). Suggested extension: chkxml - part b not developed yet The proposed new data format is described here: http://www.epidata.org/dokuwiki/doku.php/documentation:datafileformat_xml Just now users are encouraged to test the following: 1. Can the test application read your files ? 2. Can the test application write your files ? 3. In particular test - when possible - whether the data files can be read on another operating system. E.g. saved by a Linux or Mac and then read on a windows pc. Get the test application from: http://www.epidata.dk/testing.php And report to the epidata-list of failures and success. Data formats supported are: REC, RECXML, ODF, DBF, XLS A table of what can be imported and exported is shown here: http://www.epidata.org/dokuwiki/doku.php/documentation:importexport Operating systems supported are: Mac (OS X), Linux (32+64bit), Windows. Mac PowerPC expected soon. After a few weeks of comments on the format a new test application will be created. Which will collect some time estimates of reading and writing data with subsequent reporting to a central database. This method should allow for future user tests of core modules with documentation available on the central website. Regards Jens Lauritsen EpiData Association

1 0

V2.2.1 of EpiData Analysis uploaded
by epidata-list＠lists.umanitoba.ca 01 Oct '09

01 Oct '09

v2.2.1 (Build 171) of EpiData Analysis has been uploaded. The only changes are: Fixing mismatch of subfoot and estimates information on SPC charts. Extending information for RunCharts - telling the number of measurements and points omitted on median. regards Jens Lauritsen EpiData Association

1 0

Re: EpiData-list Digest, Vol 71, Issue 6
by epidata-list＠lists.umanitoba.ca 24 Sep '09

24 Sep '09

The best way is to create a new variable from the old var Then pursue with the analysis. Alternatively, you should work on the original file .rec then .che before moving on the analytical part. Best wishes Tieble 2009/9/24 <epidata-list-request(a)lists.umanitoba.ca> > Send EpiData-list mailing list submissions to > epidata-list(a)lists.umanitoba.ca > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > or, via email, send a message with subject or body 'help' to > epidata-list-request(a)lists.umanitoba.ca > > You can reach the person managing the list at > epidata-list-owner(a)lists.umanitoba.ca > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of EpiData-list digest..." > > > EpiData-list mailing list > ___________________________________ > > Today's Topics: > > 1. losing checks after inserting new variables and saving data > in Epidata Analysis (epidata-list(a)lists.umanitoba.ca) > 2. Re: losing checks after inserting new variables and saving > data in Epidata Analysis (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 24 Sep 2009 12:30:28 +0530 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] losing checks after inserting new variables > and saving data in Epidata Analysis > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <367f37ad0909240000u631a3637i4dec713b968ce095(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I am losing all my checks in the rec file after I insert new variables > using > Epidata Analysis and saving the file using command savedata. Please advise > how to retail my file structure as well as checks after I insert some new > variables using Epidata Analysis. > > -- > Ajay Kumar Reddy > > > ------------------------------ > > Message: 2 > Date: Thu, 24 Sep 2009 07:34:09 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] losing checks after inserting new > variables and saving data in Epidata Analysis > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4ABB5931.2000905(a)sympatico.ca> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > I have not had that problem using the current release. You can check the > version of Analysis under the help menu. When you SAVEDATA, Analysis > does create the corresponding .chk along with any new label values you > created for the new variables. You should be saving to a different file > name. > > What you can do if you continue to have this problem is to manually copy > the .chk for the original file to a new .chk that matches the file > created with SAVEDATA. > > I am losing all my checks in the rec file after I insert new variables > using > > Epidata Analysis and saving the file using command savedata. Please > advise > > how to retail my file structure as well as checks after I insert some new > > variables using Epidata Analysis. > > > > > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 71, Issue 6 > ******************************************* >

1 0

losing checks after inserting new variables and saving data in Epidata Analysis
by epidata-list＠lists.umanitoba.ca 24 Sep '09

24 Sep '09

I am losing all my checks in the rec file after I insert new variables using Epidata Analysis and saving the file using command savedata. Please advise how to retail my file structure as well as checks after I insert some new variables using Epidata Analysis. -- Ajay Kumar Reddy

1 1

Automatic fill in
by epidata-list＠lists.umanitoba.ca 15 Sep '09

15 Sep '09

I was wondering if anybody have an easy description of how to autofill variables after an if statement Per Kjaer

1 1

RE: EpiData-list Digest, Vol 71, Issue 1
by epidata-list＠lists.umanitoba.ca 12 Sep '09

12 Sep '09

Hello, Two questions : - Is "P50 lifetable" validity in progress ? - In scatter graph, is a linear regression line planned ? Congratulations for all the progress with last versions; Bernard BRANGER, Nantes, France -- J’utilise la version gratuite de SPAMfighter pour utilisateurs privés. Jusqu’à présent SPAMfighter a bloqué 922 courriels spam. Nous avons en ce moment 6 millions d’utilisateurs de par le monde entier. Les utlisateurs payants n’ont pas ce message. Vous pouvez télécharger la version gratuite: http://www.spamfighter.com/lfr

1 0

New Core Module uploaded.
by epidata-list＠lists.umanitoba.ca 09 Sep '09

09 Sep '09

Dear EpiData users. I have posted a new version of the Core Module for testing on the EpiData website: http://epidata.dk/testing.php With the latest version it is now possible to import and export Open Office spreadsheets (Open Document Standard) although with limited support for exporting dates. Please see the wiki for information on what formats are supported: http://www.epidata.org/dokuwiki/doku.php/documentation:importexport Additionally it is also possible to export to Excel spreadsheet. Importing is yet no possible. With kind regards, Torsten Bonde Christiansen. Software Developer, Epidata.

1 2

possible strategy discussion meeting in Baltimore (sept. 12th.-18th)
by epidata-list＠lists.umanitoba.ca 02 Sep '09

02 Sep '09

Dear all During the current development phase some strategic decisions need to be taken. E.g. on data file format, data formats to support for import/export. How to handle support issues etc. What types of analysis should be supported and developed etc. I would like users to arrange locally such strategic meetings and let us know on the list of the viewpoints. If anyone in the Baltimore region in USA have interest in a strategic discussion meeting during the time from Sept. 13th. to Sept. 18th. let me know (off list). I could arrange such a meeting in late afternoons or early evening on campus at Johns Hopkins University, where I will attend a course on quality assurance . Another option is in New York on Sept. 11th. Regards Jens Lauritsen in case of interest email directly to: info at epidata.dk (disregard the return message I will contact you directly).

1 0