- EpiData-list - University of Manitoba Mailing Lists

Re: Rename fields
by epidata-list＠lists.umanitoba.ca 22 Oct '09

22 Oct '09

Ziad, First of all always backup your data before doing dangerous things such as renaming variables. That is simple. The first sugestion is to use EpiData entry tools menu... there is something like rename fields(my menus are in portuguese) ... this may help. Another solution is to export two splits of the dataset to stata, one containing the first the datebase but without the second datebase and a second dataset with only the unique identifier and the second datebase. Later, already with stata, you may rename the varibles and merge the two datasets side by side with the unique identifier. Best regards, Abraço forte e que a força esteja com você, Dr. Pedro Emmanuel A. A. do Brasil Instituto de Pesquisa Clínica Evandro Chagas Fundação Oswaldo Cruz Rio de Janeiro - Brasil 2009/10/22 <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. Re: EpiData-list Digest, Vol 72, Issue 7 > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 22 Oct 2009 08:15:08 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Re: EpiData-list Digest, Vol 72, Issue 7 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <897a5cf60910212315r4894a4b8t6cd37fa5668cbd6f(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi! > I have had 2 date related vaiables called "datebase1" and "datebase2" > in EpiData. When exported them into STATA, they are showing as > "datebase" and "datebase" and both variables contain the same value > now which is not correct. > > It might be due to the total number of characters for the variable > name, but my question is how can I fix it? > > > Best regards > ziad > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 72, Issue 8 > ******************************************* >

1 0

Re: EpiData-list Digest, Vol 72, Issue 7
by epidata-list＠lists.umanitoba.ca 22 Oct '09

22 Oct '09

Hi! I have had 2 date related vaiables called "datebase1" and "datebase2" in EpiData. When exported them into STATA, they are showing as "datebase" and "datebase" and both variables contain the same value now which is not correct. It might be due to the total number of characters for the variable name, but my question is how can I fix it? Best regards ziad

1 1

Re: [EpiData-list] Re: EpiData-list Digest, Vol 72, Issue 7
by epidata-list＠lists.umanitoba.ca 22 Oct '09

22 Oct '09

I guess, you have to go back to your REC file, go to Tools | Rename fields, and change each of the two fields to names with 8 or fewer characters. While it is nice that EpiData offers a maximum field length of 10, it might be wise (as example shows) not to exhaust the maximum if the data are to be analyzed in other software limiting the allowable length to 8. Hans epidata-list(a)lists.umanitoba.ca wrote: > Hi! > I have had 2 date related vaiables called "datebase1" and "datebase2" > in EpiData. When exported them into STATA, they are showing as > "datebase" and "datebase" and both variables contain the same value > now which is not correct. > > It might be due to the total number of characters for the variable > name, but my question is how can I fix it? > > > Best regards > ziad -- Hans L Rieder, MD, MPH Web: http://www.tbrieder.org

1 0

Re: Relational data
by epidata-list＠lists.umanitoba.ca 22 Oct '09

22 Oct '09

Dear Ziad, Perhaps it may be better to merge the files to produce one file of observations (all levels should be included). If you decide to go through this route, please remember that this can be done in EpiData Analysis using the MERGE command. Best wishes Tieble 2009/10/22 <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. Re: EpiData-list Digest, Vol 72, Issue 7 > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 22 Oct 2009 08:15:08 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Re: EpiData-list Digest, Vol 72, Issue 7 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <897a5cf60910212315r4894a4b8t6cd37fa5668cbd6f(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi! > I have had 2 date related vaiables called "datebase1" and "datebase2" > in EpiData. When exported them into STATA, they are showing as > "datebase" and "datebase" and both variables contain the same value > now which is not correct. > > It might be due to the total number of characters for the variable > name, but my question is how can I fix it? > > > Best regards > ziad > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 72, Issue 8 > ******************************************* >

1 0

Core test - clarification of &
by epidata-list＠lists.umanitoba.ca 18 Oct '09

18 Oct '09

Correction to last message: An ampersand (&) does translate to & when it appears in a .qes file / header of .rec, but it does not get translated when it appears in DATA, i.e. a text field that contains "A & B" -- Jamie Hockin

1 0

Core Test
by epidata-list＠lists.umanitoba.ca 18 Oct '09

18 Oct '09

The module is not correctly handling special characters in creating recxml files. Two examples I've found so far. 1. " translates to &qout; rather than " 2. & is not translated to & sample .qes lines are: a var # 1 = "some text" b var # Factor A & Factor B either of these causes failure on reading the recxml -- Jamie Hockin

1 0

Re: Backup data file
by epidata-list＠lists.umanitoba.ca 18 Oct '09

18 Oct '09

Thank you for your prompt reply, however the screen with backup option (i.e. with the destination) does not appear at all. The only message that I get from both menus document and export is "file not found". I have no problem performing the backup on other computers on which I installed the Epidata program. However for some reason the message "file not found" occurs only on the computers where I do not have permission to install the program. Is there any solution to this problem? Clearly I have tried to write a short program to backup, unfortunately that did not work too. Your help will be appreciated Kind regards Tieble 2009/10/16 <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. Backup data file (epidata-list(a)lists.umanitoba.ca) > 2. Re: Backup data file (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 15 Oct 2009 18:35:14 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Backup data file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <bf1bb7700910151035u36e2d874vf7d16b6d04fb56a(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I will appreciate it if anyone could provide me with some advice in > creating > a backup in Epidata. Every time, I try to use the menu to backup the > following message appears "File Not Found". > Clearly, I did not encounter any problem creating the backup file/data in > the EpiData programs installed on my PCs (laptop and desktop). But I am > having difficulty in backing up the rec. file created on a company's > computer. > > Kind regards > > Tieble > > > ------------------------------ > > Message: 2 > Date: Thu, 15 Oct 2009 18:52:27 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Backup data file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4AD7A7AB.6020705(a)sympatico.ca> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Check the Destination directory in the box that opens up with Backup. It > may point to a directory for which you do not have write access. > > I will appreciate it if anyone could provide me with some advice in > creating > > a backup in Epidata. Every time, I try to use the menu to backup the > > following message appears "File Not Found". > > Clearly, I did not encounter any problem creating the backup file/data in > > the EpiData programs installed on my PCs (laptop and desktop). But I am > > having difficulty in backing up the rec. file created on a company's > > computer. > > > > Kind regards > > > > Tieble > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 72, Issue 6 > ******************************************* >

1 0

Backup data file
by epidata-list＠lists.umanitoba.ca 15 Oct '09

15 Oct '09

I will appreciate it if anyone could provide me with some advice in creating a backup in Epidata. Every time, I try to use the menu to backup the following message appears "File Not Found". Clearly, I did not encounter any problem creating the backup file/data in the EpiData programs installed on my PCs (laptop and desktop). But I am having difficulty in backing up the rec. file created on a company's computer. Kind regards Tieble

1 1

EpiData software core module Version 0.2.1 build 99
by epidata-list＠lists.umanitoba.ca 12 Oct '09

12 Oct '09

To: EpiData software development team EpiData software core module Version 0.2.1 build 99: Exporting to EpiData REC file and reading exported file in EpiData Analysis 2.2.1.171: File: Num fields = 65 Num data fields = 65 Num records = 37635 1) All field labels are front-truncated 2) CHK file seems correct -- Hans L Rieder, MD, MPH Jetzikofenstr 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org

1 0

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