I would appreciate it if those working with outbreaks could reply about how they enter and display "ongoing" duration of illness. I have been given an Excel sheet to analyse in Epidata. For this outbreak people were asked the date and time when they became unwell and the date and time when they felt better. There is a calculated field in the spreadsheet that calculates duration in days (date better - date unwell), but for some people this is empty because "ongoing" has been entered as text in the "date better" field. I want to modify the Excel sheet so I include those people with 'ongoing' illness in an epidemic curve.
I thought I could enter a date sometime in the future instead of 'ongoing' This would mean the duration days would not be blank, but a number of days well beyond the maximum value for those whose illness is finished. What do others do?
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 **
Hello!Can you attached the file for me to figure out the problem for you.
Regards
Mensah
On Mon, Dec 1, 2008 at 6:04 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. Export to SPSS requires 2 stage procedure
> (epidata-list(a)lists.umanitoba.ca)
> 2. Dealing with 'Ongoing' duration in epicurves
> (epidata-list(a)lists.umanitoba.ca)
>
>
> ---------- Forwarded message ----------
> From: epidata-list(a)lists.umanitoba.ca
> To: epidata-list(a)lists.umanitoba.ca
> Date: Sun, 30 Nov 2008 21:46:21 +0200
> Subject: [EpiData-list] Export to SPSS requires 2 stage procedure
> Hello users and developers,
>
> I am using Epidata Entry 3.1 27 Jan 2008 on Windows XP Pro SP3. I have date
> entered in .REC files. When I perform the export function using the drop
> down menus, it does so fine, but the .SPS and .TXT files created are all
> blank. If I try re-exporting (with Epidata Entry still open), and error
> message pops up: "...data still in use..." or something like that. A
> successful data export to SPSS is only possible if I complete quite Epidata
> Entry and and start a new instance to perform the export procedure once
> again.
>
> Could somone please verify this for me, and if so please explain what is
> going on. It is quite frustrating that to have to do export in 2 stages.
>
> Thanks,
> Shuaib
>
>
>
> ---------- Forwarded message ----------
> From: epidata-list(a)lists.umanitoba.ca
> To: <epidata-list(a)lists.umanitoba.ca>
> Date: Mon, 01 Dec 2008 11:18:23 +1300
> Subject: [EpiData-list] Dealing with 'Ongoing' duration in epicurves
> I would appreciate it if those working with outbreaks could reply about how
> they enter and display "ongoing" duration of illness. I have been given an
> Excel sheet to analyse in Epidata. For this outbreak people were asked the
> date and time when they became unwell and the date and time when they felt
> better. There is a calculated field in the spreadsheet that calculates
> duration in days (date better - date unwell), but for some people this is
> empty because "ongoing" has been entered as text in the "date better" field.
> I want to modify the Excel sheet so I include those people with 'ongoing'
> illness in an epidemic curve.
>
> I thought I could enter a date sometime in the future instead of 'ongoing'
> This would mean the duration days would not be blank, but a number of days
> well beyond the maximum value for those whose illness is finished. What do
> others do?
>
> 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 **
>
>
>
> ________________________________________
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
--
SEDZRO KOJO MENSAH
P.O.Box AS 387
Ashaiman -Tema
Ghana
House : +233-22-300789
MOBILE : +233-244-458788
--------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.