September 2008 - EpiData-list - University of Manitoba Mailing Lists

Alyshia Landry is out of the office.
by epidata-list＠lists.umanitoba.ca 30 Sep '08

30 Sep '08

I will be out of the office starting 09/27/2008 and will not return until 10/06/2008. If you require immediate assistance, please contact Celina Sousa at extension 5300. Thank-you, Alyshia

1 0

numerical to date chk?
by epidata-list＠lists.umanitoba.ca 30 Sep '08

30 Sep '08

Dear Epidata list, I am looking for a way to generate a date-variable from a numerical-variable. i.e. I will type in the Danish central person registration number (10 digits where the 6 first digits are the birthday ddmmyy) I would like to automatically create a date variable from this - to calculate ages at later dates. I have looked for a chk that would do it, but couldn't find any. Does anybody have a solution? (and sorry if this has been discussed before, I searched and couldn't find any relevant discussion threads) thanks in advance, Drude Molbo, data admin dept. of social medicine, KU DK

1 1

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