- EpiData-list - University of Manitoba Mailing Lists

Excel data upload into EpiData
by epidata-list＠lists.umanitoba.ca 12 Aug '11

12 Aug '11

Jens & Jamie, Thank you for suggestions time to time on Epidata programming that I am working on. We are replacing existing disease database (specific disease) that is in Access plateform with Epidata. The access database was not stable over the years, so lost a chunk of data few times. Hope Epidata is the solution. I completed most programming including several calculated fields, some are very complex assiging risk factors. The data is in MS Excel. It has ~ 2000 data with ~ 100 variables. All the data fields in both (Epiadta QES and Excel) systems are identical except IDNUM is extra in Epidata. I am looking the best way to migrate excel data into the blank epidata. May be I should convert excel to .REC file first, then import, or may be .TXT is better. I have tested with small dataset by cerating .REC file first then import. It did work. Any suggestion would be appriciated. Thanks Bijay On Fri, Aug 12, 2011 at 11:01 AM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > 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: Export EpiData to Excel - is there a solution/an > alternative? (epidata-list(a)lists.umanitoba.ca) > 2. relational files on epodata analysis > (epidata-list(a)lists.umanitoba.ca) > 3. Re: relational files on epodata analysis > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 11 Aug 2011 19:03:19 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Export EpiData to Excel - is there a > solution/an alternative? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <23065_1313082200_ZZh0y4eF~ > 8kfp.00_4E440B57.4040905(a)uni-bielefeld.de> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hey everybody, > > thank your so much for your efforts and the enormous help! I need some > time to consider your proposals and the next steps now :-) > > My boss has done a lot of work with Excel and she is just worried 1. > that we have to adapt to a new system and 2. that we can't combine the > data from the Open Office sheets with already existing Excel sheets. > > Thanks again and greetings, > Nina > > > > Am 11.08.2011 17:45, schrieb epidata-list(a)lists.umanitoba.ca: > > I suppose the starting point really is to answer the question, "What do I > want to do with the data in Excel?" > > > > ? look at it in a spreadsheet view? - EpiData Analysis can do this > (Browse) > > ? do some simple calculations on some fields? - EpiData Analysis can do > this > > ? do some really complicated calculations on some fields? - just export > some key identifying fields and the fields you need into Excel and merge the > results back into your EpiData file > > ? do some special analysis that is only available in Excel? - same idea, > but I can't think of any that would use very many fields > > ? create a database that will support mail-merge ? - you won't need many > fields for this > > > > If your boss has a fixation on an old version of Excel, then you are > limited to exporting 256 fields (columns). Excel 2010 or newer can handle > over 16,000 columns > > > > Jamie > > > >> thank you very much! I tried to suggest that to my boss but she is not > convinced yet. Are there any other possibilities available? > > > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > -- > Nina-Claire Himpe > Wiss. Mit. von Prof. Dr. Ulrike Davy > Lehrstuhl für öffentliches Recht, deutsches und > internationales Sozialrecht, Rechtsvergleichung > Fakultät für Rechtswissenschaft > Universität Bielefeld > Postfach 10 01 33 > 33 501 Bielefeld > > UHG T7-109 > Tel.: 0521 - 106 2508 > > > ------------------------------ > > Message: 2 > Date: Thu, 11 Aug 2011 13:59:24 -0500 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] relational files on epodata analysis > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <6c3a19b721250cea381f09c055a1d1f1.squirrel(a)webmail.uady.mx> > Content-Type: text/plain;charset=iso-8859-1 > > I woul like to request a simple exaple to relate 2 files and create a new > one using epidata analysis. > Thank you in advance > > Jose Farfan > > > ----------------------------------------- > "Universidad Autónoma de Yucatán" > http://www.uady.mx/ > > > > ------------------------------ > > Message: 3 > Date: Thu, 11 Aug 2011 16:50:49 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] relational files on epodata analysis > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP24D73CD429C739981CD0C1FD220(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > This is quite simple. Please read the help for the MERGE command in > Analysis. > Here is a simple example in a zip file. >

1 1

relational files on epodata analysis
by epidata-list＠lists.umanitoba.ca 12 Aug '11

12 Aug '11

I woul like to request a simple exaple to relate 2 files and create a new one using epidata analysis. Thank you in advance Jose Farfan ----------------------------------------- "Universidad Autónoma de Yucatán" http://www.uady.mx/

1 2

Export EpiData to Excel - is there a solution/an alternative?
by epidata-list＠lists.umanitoba.ca 11 Aug '11

11 Aug '11

Dear member of the team, dear all, I am having the following problem and would be very grateful if there was a solution (or alternative) to it: The data I want to export to Excel consists of approximately 960 lines in Epidata formats (= 960 colums in .xls). As I understand EpiData (and as the test with the used data showed) it is impossible to export more than 256 lines to Excel (version 2003) because of the Excel 2003 column limit . Is there any way to export the 960 lines to Excel? Or is there another alternative I should consider? Thank you very much in advance! Greetings, Nina-Claire Himpe

1 6

follow up: big data sets
by epidata-list＠lists.umanitoba.ca 05 Aug '11

05 Aug '11

I tried the new Entryclient with two large data sets. Set 1: 500 integer fields, 500 records, uncompressed size: 1.1 MB as .epx 45K as .epz - load the file: 150 seconds - jump from record 1 to last record: 1 or 2 seconds - * to get empty record: 5 seconds - save file: 3 second - load in Analysis (running under Wine, so a bit slower than on an equally powered PC): 5 seconds - freq v500: immediate - no difference with .epz file Set 2: 20 integer fields, 10,560 records, uncompressed size: 1.1 MB - load the file: immediate - jump to end or new record: immediate - load in Analysis: 7 seconds - freq v1: immediate I expect the typical "large" data set would be somewhere between these two. Most large data sets I have used are like Set 2 and have been extracts of national databases. I might use the Entryclient on these, but unlikely. I've seen others using data like Set 1, but never really understood why they used such large data sets as most data items were unused and interesting only in a clinical review of individual subjects. (technical note: time to execute a Javascript loadxml() <500 msec) Jamie

1 2

File size and program freezing
by epidata-list＠lists.umanitoba.ca 02 Aug '11

02 Aug '11

Hello, I was hoping to get an idea for the size of files people are working with in the new EpiData Manager. I am currently trying to work out issues when I try to open a .epx file. The file is quite large at 60,000 Kb. I don't know if the problem is with Manager being able to handle a file of this size, or if the file contains some sort of corruption. The file is quite important, so any feedback or assistance would be most appreciated. Cheers, Jonathan Edwin -------------------------------------------------------------------------------------------------------- Jonathan Edwin Outbreak Management Division Public Health Agency of Canada jonathan.edwin(a)phac-aspc.gc.ca

1 1

Adding sections or fields inEpiData Manager(length/height of dataform)
by epidata-list＠lists.umanitoba.ca 02 Aug '11

02 Aug '11

My understanding of a section is for the logical grouping of a set of questions (such as personal details, which one may wish to password protect, for instance). Such a section may consist of many questions. If that is the case, then it seems reasonable to me that a section could thus take the whole page. Such a section could be just one of many (which may be any size, smaller or bigger), so that indeed one doesn't just have one section. Regards, Neville ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 1

Adding sections or fields in EpiData Manager(length/height of dataform)
by epidata-list＠lists.umanitoba.ca 02 Aug '11

02 Aug '11

Thanks to Jonathan and Jens for their postings. The approach that Jens suggests works for headings and fields as long a section isn't already full-screen. The approach that Jonathan suggests for sections works for the first such section to be created (i.e. the one that extends the height of the dataform). After that (i.e. after having a section which has extended the height so that it is full screen) it doesn't seem possible to add further sections. In such a situation, even pressing shift+5, for instance, puts the heading within that (now full-screen) section, rather than extending the form. I look forward to Jens and his team handling this situation. Regards, Neville ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 1

Adding sections or fields in EpiData Manager
by epidata-list＠lists.umanitoba.ca 02 Aug '11

02 Aug '11

When creating a form in the Manager, such a form will, generally, contain many fields and possibly more than one section. It is not clear to me how one adds sections and/or fields upon reaching the bottom of the screen (which seems to occur at a height of about 610 as measured from the top) as there is no vertical scroll bar to move a blank page into focus into which such fields or sections can be added. If this can't be done, then surely this limits how many sections and fields can be created. The sample file, for instance, spreads over two pages, so how were the later sections added after the first few were created? Apologies if a stupid question ... All thoughts on this would be most appreciated. Neville ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 2

How to Delete Records Based on a Variable
by epidata-list＠lists.umanitoba.ca 25 Jul '11

25 Jul '11

Hello, I would like to add an alternative way of deleting records in Epidata entry if you just want to delete certain number of records. When you move to the record you want to delete in the database, there is a “X” sign in red at the left bottom of the screen beside the area showing the number of records, navigation buttons and the button for new record entry “*” . If the red “X” button is hit, “DEL” will show up right beside. Save the record. Apply this “DEL” to the records you would like to delete in the database. Next step is to PACK the data file. To do this, close the data entry form and go to ‘ Tools > Pack data file ‘ and select the data file which contains the records you would like to delete. This will delete the records marked as “DEL” permanently. At the same time, filename.old.rec will be created if you would like to undo the deleting. Marking the records “DEL” does not permanently delete the records until you PACK the data file. Hope this help. Zaw Myanmar On Sat, Jul 23, 2011 at 11:30 PM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > 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. How to Delete Records Based on a Variable > (epidata-list(a)lists.umanitoba.ca) > 2. Re: How to Delete Records Based on a Variable > (epidata-list(a)lists.umanitoba.ca) > 3. Re: How to Delete Records Based on a Variable > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 22 Jul 2011 18:49:20 -0500 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] How to Delete Records Based on a Variable > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <679902537E215D43805DEA9BE833090E06C213D5(a)NORCEX1.norc.org> > Content-Type: text/plain; charset="us-ascii" > > Hello, > > > > I am trying to delete a subset of records in my dataset based on the > value of one of the variables (hhid) in either EpiData Entry or > Analysis. I am guessing it is easy, but I cannot figure it out. Can > someone please advise? > > > > Thanks, > > Sam > > > > > > ------------------------------ > > Message: 2 > Date: Fri, 22 Jul 2011 21:20:08 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] How to Delete Records Based on a Variable > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP18F9651A4055C04D6E8A53FD310(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > It's quite easy > > In Analysis: > > select hhid <> [value for delete] > savedata newfile > > You can then copy your old file as a backup and rename "newfile.rec" if you > want. > > In EpiData Entry: > > -export data to EpiData > Choose your current data (.rec) > Make sure all variables are checked > Check off "Use record filter" > In the Filter box: hhid <> [value for delete] > > You can put a more complex logical expression in the filter. > Your new data are in filename.new.rec > > Jamie > > On 2011-07-22, Sam wrote: > > > I am trying to delete a subset of records in my dataset based on the > > value of one of the variables (hhid) in either EpiData Entry or > > Analysis. I am guessing it is easy, but I cannot figure it out. Can > > someone please advise? > > > > ------------------------------ > > Message: 3 > Date: Fri, 22 Jul 2011 21:22:17 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] How to Delete Records Based on a Variable > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <0bf801cc48d6$f2ee5c62$ae9510ac(a)norc.org> > Content-Type: text/plain; charset="utf-8" > > Perfect, thank you! > > "epidata-list(a)lists.umanitoba.ca" <epidata-list(a)lists.umanitoba.ca> wrote: > > It's quite easy > > In Analysis: > > select hhid <> [value for delete] > savedata newfile > > You can then copy your old file as a backup and rename "newfile.rec" if you > want. > > In EpiData Entry: > > -export data to EpiData > Choose your current data (.rec) > Make sure all variables are checked > Check off "Use record filter" > In the Filter box: hhid <> [value for delete] > > You can put a more complex logical expression in the filter. > Your new data are in filename.new.rec > > Jamie > > On 2011-07-22, Sam wrote: > > > I am trying to delete a subset of records in my dataset based on the > > value of one of the variables (hhid) in either EpiData Entry or > > Analysis. I am guessing it is easy, but I cannot figure it out. Can > > someone please advise? > > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 93, Issue 13 > ******************************************** >

1 0

Re: [EpiData-list] How to Delete Records Based on a Variable
by epidata-list＠lists.umanitoba.ca 22 Jul '11

22 Jul '11

Perfect, thank you! "epidata-list(a)lists.umanitoba.ca" <epidata-list(a)lists.umanitoba.ca> wrote: It's quite easy In Analysis: select hhid <> [value for delete] savedata newfile You can then copy your old file as a backup and rename "newfile.rec" if you want. In EpiData Entry: -export data to EpiData Choose your current data (.rec) Make sure all variables are checked Check off "Use record filter" In the Filter box: hhid <> [value for delete] You can put a more complex logical expression in the filter. Your new data are in filename.new.rec Jamie On 2011-07-22, Sam wrote: > I am trying to delete a subset of records in my dataset based on the > value of one of the variables (hhid) in either EpiData Entry or > Analysis. I am guessing it is easy, but I cannot figure it out. Can > someone please advise? _______________________________________________ EpiData-list mailing list EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list

1 0