- EpiData-list - University of Manitoba Mailing Lists

Opening html files in excel and using not equal to blank with date fields
by epidata-list＠lists.umanitoba.ca 15 Sep '08

15 Sep '08

One comment and one query Use of brackets in AR% column I just wondered if it was necessary to use brackets in the AR% tables in attack rate tables. The reason I ask is that when I open an Epidata output (html file) using Excel the AR% columns show as negative numbers - I suppose because Excel thinks the brackets indicate a negative number. Not equal to blank in date fields I am having trouble wtih an if then statement where I want to do something if a date field is not blank. I know that Epidata will accept (.) for blank dates as it accepts If vomdate =(.) and diadate = (.) then onsetdate = (.) But it does not accept If vomdate =(.) and diadate <> (.) then onsetdate = diadate Could someone please suggest a better code for "not blank" with a date field? 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 1

Another question about SPC
by epidata-list＠lists.umanitoba.ca 11 Sep '08

11 Sep '08

I am trying to use EpiData to display information about Healthcare Associated Infections, such as MRSA and C difficile. I was wondering if SPC charts can be used to show actual and cases against targets. Please see an example attached of what I am trying to achieve. This has been done in excel (I think!) Thanks, Shakeel ----------------------------------------- ************************************************************************** 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 0

EPIC bug report - fails on Stata7 option.
by epidata-list＠lists.umanitoba.ca 11 Sep '08

11 Sep '08

EPIC.exe has a bug. It failes with a pointer error Access Violation when trying to use the export to "Stata7" option. It does leave a small Stata .dta file which has a size of 717 bytes. Stata hangs on trying to open this small file. Specifying the Stata, Stata5 and Stata6 options works fine. I've tried the command in various formats (lower/uppercase etc), on local hard drive, network drive etc. Windows XP. Any chances of a quick fix? This is a problem for me because Stata6 only has 8-character variable names, whereas Stata7 doesn't have this limitation. With EpiC, my Stata data cleaning process could work automatically from the most recent data entry version. Would a 200 Euro donation to the Epidata association help fix this problem at some point in time? HERE IS AN ERROR LOG: ==================== C:\tmp>EpiC.exe export stata7 file1.rec file1.dta EpiC - the EpiData command application version 3.1 10. Jan. 2006 (C) Copyright 2002-2006 - EpiData Association, http://www.epidata.dk Programmed by M.Bruus. Design: JM.Lauritsen & M.Bruus 0 % doneException EAccessViolation in module EpiC.exe at 00001C3C. Access violation at address 00401C3C in module 'EpiC.exe'. Write of address 0000 0004. ==================== Yours, Jan Brogger

1 0

SPC Charts
by epidata-list＠lists.umanitoba.ca 10 Sep '08

10 Sep '08

Hello, Is it possible to create SPC Charts in Epidata Analysis- if so, what is the procedure? Thanks Shakeel ----------------------------------------- ************************************************************************** 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

Two questions
by epidata-list＠lists.umanitoba.ca 09 Sep '08

09 Sep '08

Hello, 1- In Analysis, the width of variable codes is 20 characters with "freq" or "tables". Is it possible to increase this width ? I have variable codes> 20 characters. 2- In related file ("daughter file"), I need, for a calculation, of a variable in "father file". How to proceed ? Thank you. Bernard BRANGER, Nantes, France

1 2

Help needed
by epidata-list＠lists.umanitoba.ca 08 Sep '08

08 Sep '08

I am new to epi-data analysis. I set up a test file called test.csv to practice. However, I am getting the following message. Any advice would be appreciated: Access is denied Operation aborted Separators: (tab: 0)(semicolon: 0)(comma: 0)(space: 0) Lines: 1 Cannot define number of variables .. check data file - cannot open.. Operation aborted Operation aborted Separators: (tab: 0)(semicolon: 0)(comma: 0)(space: 0) Lines: 1 Cannot define number of variables .. check data file - cannot open.. Operation aborted Operation aborted ----------------------------------------- ************************************************************************** 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

Re:EpiData-list Digest, Vol 59, Issue 4
by epidata-list＠lists.umanitoba.ca 06 Sep '08

06 Sep '08

Hi, Peter Thanks for your help. We are using Java as the primary language in the project. It seems that you also try to do a job like that. We will contribute the Java code to the community if possible :) 2008-09-06，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: Where can I get the file format's specification for both > .qes and .rec files? (epidata-list(a)lists.umanitoba.ca) > 2. Help needed (epidata-list(a)lists.umanitoba.ca) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Thu, 04 Sep 2008 15:09:12 -0400 >From: epidata-list(a)lists.umanitoba.ca >Subject: Re: [EpiData-list] Where can I get the file format's > specification for both .qes and .rec files? >To: epidata-list(a)lists.umanitoba.ca >Message-ID: <48C03258.5050708(a)ix.netcom.com> >Content-Type: text/plain; charset=x-gbk > >The .REC files are described in the pdf document Data File Structure: >http://www.epidata.dk/php/downloadc.php?file=epidata_datafile.pdf > >What language do you plan to use to re-organize all of this? > >Peter Geddes >geddes(a)ix.netcom.com > >epidata-list(a)lists.umanitoba.ca wrote: >> Hi, >> >> I am working on a goverment project in which we have to handle about 3000 EPIData files. Different fields exist in different files and the same field's names are not extract matched among files such as age0 and ageForFirstTime. >> >> Obviously, it takes too much human resources to merge those files and we want to develop a program to do the job. And we have to know the file format for both .qes and .rec files. >> >> Does anyone knows where we can get the specification for those files? >> >> >> >> _______________________________________________ >> EpiData-list mailing list >> EpiData-list(a)lists.umanitoba.ca >> http://lists.umanitoba.ca/mailman/listinfo/epidata-list >> >> >> > > >------------------------------ > >Message: 2 >Date: Fri, 5 Sep 2008 14:07:55 +0100 >From: epidata-list(a)lists.umanitoba.ca >Subject: [EpiData-list] Help needed >To: >Message-ID: > >Content-Type: text/plain; charset="us-ascii" > >I am new to epi-data analysis. I set up a test file called test.csv to >practice. However, I am getting the following message. Any advice would >be appreciated: > > > >Access is denied > >Operation aborted > >Separators: (tab: 0)(semicolon: 0)(comma: 0)(space: 0) Lines: 1 > >Cannot define number of variables > >.. check data file - cannot open.. > >Operation aborted > >Operation aborted > >Separators: (tab: 0)(semicolon: 0)(comma: 0)(space: 0) Lines: 1 > >Cannot define number of variables > >.. check data file - cannot open.. > >Operation aborted > >Operation aborted > > > > > >----------------------------------------- >************************************************************************** >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 >************************************************************************** > >------------------------------ > >________________________________________ >EpiData-list(a)lists.umanitoba.ca >http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > >End of EpiData-list Digest, Vol 59, Issue 4 >*******************************************

1 0

Where can I get the file format's specification for both .qes and .rec files?
by epidata-list＠lists.umanitoba.ca 04 Sep '08

04 Sep '08

Hi, I am working on a goverment project in which we have to handle about 3000 EPIData files. Different fields exist in different files and the same field's names are not extract matched among files such as age0 and ageForFirstTime. Obviously, it takes too much human resources to merge those files and we want to develop a program to do the job. And we have to know the file format for both .qes and .rec files. Does anyone knows where we can get the specification for those files?

1 1

Mailing List
by epidata-list＠lists.umanitoba.ca 04 Sep '08

04 Sep '08

Sir, Please include my email in the mailing list Olaniyan, M.A madeolaniyan(a)gmail.com

1 0

"run error" in analysis test build 145/46 fixed
by epidata-list＠lists.umanitoba.ca 03 Sep '08

03 Sep '08

The error mentioned on the list of "graph dialog and "run" has been fixed. For this reason a new build 147 is now on the test site. Usually we will not put out this many builds, but since the dialogs are a crucial part of the testing I decided to do so. Regarding the other comment : "2. Correlation coefficient “r” information needs some face lift. Can the coefficient of determination, r2 that is the measure of meaningfulness of “r “ is provided?" I can only agree. The whole linear regression and correlation part will be rewritten, but I do not expect this to happen before early 2009. Some issues in relation to translation are being worked upon. V2.1 will not be released in general before these are settled. Kind regards Jens Lauritsen

1 0