Hi
I have recently upgraded to version 2.2.171 of epidata analysis. I mainly use Epidata analysis to analyse disease outbreaks and with this new version I am finding it more difficult to ask for the attack rate table that is such a useful tool. Perhaps I am getting confused because I have not used epidata analysis for a while, but I thought that in earlier versions, it was possible to select an attack rate table (with relative risk, CI and pvalue for all exposures of interest) using options from the analysis menu. This time I had to search around the help menu and try and find the code.
The code I used was tables SICK VARIABLE 1 VARIABLE 2 etc /CT/oa.
Is there some way I can ask for this table through the menus?
The reason I am asking is that I want to show other people in our unit how to use epidata to create an attack rate table and I think they will find it easier to go through a menu.
thanks very much
Christine
istinfo/epidata ( 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..."
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 **
______________________________________________________________________________
This email has been scrubbed for your protection by SMX.
For more information visit http://smx.co.nz
______________________________________________________________________________
This is a brief status of developments - (rather technical in content)
It is reassuring to see, that the interest in testing is rather large
(Approximate download counts for latest version: Linux 50 , Mac 75 and
Windows 300). Few comments have been given on the list, but I take that
as a positive indication - I hope I am right, otherwise please notify on
the list.
The short story is:
We are definitely moving forward - the basic way of working in graphic
mode with data definition is more or less in place. But we must spend
time on implementing related data structures and finding a final data
structure. Therefore the first EpiData Entry Client based on the new
principles will not come out until some time from now.
The longer story is:
During the most recent decade use of standardised data formats in public
sectors and research has become an increasingly important issue. The
idea of this is that data should be usable in any application and system
based on published verifiable standards (XML based). XML is one of the
structured information formats for machine readable information
published by the W3C organisation - and is very complex - other ones
from W3C are css and html. The published standards for XML based data
documentation and storage of data as such are unfortunately plenty, a
few of these are DDI (see DDI-alliance.org), CDISC ODM (see cdisc.org),
SDMX (see sdmx.org). It seems as medicine, national statistics and the
social sciences each have developed their own. The only common
denominator seems to be in relation to overall descriptions such as
"title", "contributor", abstract etc. These terms are well known from
citations and are based on a metadata set called Dublin Core Metadata
(see http://dublincore.org/specifications/).
For implementation of a XML based file format in the EpiData Software it
would seem obvious to NOT develop a new one, but instead use one or more
of the mentioned ones. Therefore there have been discussions with data
documentation specialists at the Danish Data Archives (see
http://samfund.dda.dk/default-en.asp).
Following these discussions and after studying several published
standards it has been decided that the EpiData Software XML format will
conform to the overall principles of the mentioned standards, but also
that we must work with a restricted set of these.
The nature of the EpiData project is to be focused on simplicity and we
must stick to this principle. Otherwise we would be lost in months of
generalisation, of no interest to the general user and also completely
unrealistic within the economical and personal resources available.
The time frame for the next phases are uncertain, but I will give
orientation on this list as improvements are made and obstacles removed.
Most likely there will be a meeting in the second week of March in Paris
for detailed discussions on some of these issues. More information on
that later.
regards
Jens Lauritsen
EpiData Association
Hello YC,
Though i appreciate the solution YMP is giving you, i think you can also
think of using the repeat command, since it is more easy play around with.
With that you can be able to enter a field once and the next recode the
field comes with the previous entry as a default which just needs your
confirmation.
All the best
Edson BN
On Tue, Feb 16, 2010 at 10:00 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: Copy and Paste an Entry? (epidata-list(a)lists.umanitoba.ca)
> 2. Re: Copy and Paste an Entry? (epidata-list(a)lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 15 Feb 2010 18:51:52 +0100
> From: epidata-list(a)lists.umanitoba.ca
> Subject: RE: [EpiData-list] Copy and Paste an Entry?
> To: <epidata-list(a)lists.umanitoba.ca>
> Message-ID: <00bf01caae67$8ee97710$acbc6530$@martin-prevel@ird.fr>
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> I think the best way to get round this problem is to have a relational data
> base with two files:
> (i) the "Master" file with patient's information
> (ii) the related file with daily information
>
> There are several examples of such related data entry and how it works on
> the Epidata website
>
> Hope this helps
>
> YMP
>
>
> -----Message d'origine-----
> De : epidata-list-bounces(a)lists.umanitoba.ca [mailto:
> epidata-list-bounces(a)lists.umanitoba.ca] De la part de
> epidata-list(a)lists.umanitoba.ca
> Envoyé : lundi 15 février 2010 17:38
> À : epidata-list(a)lists.umanitoba.ca
> Objet : [EpiData-list] Copy and Paste an Entry?
>
>
> Hello. I was wondering if it is possible to copy and paste an entry? I am
> entering data for patients at a hospital by day, and each time I enter a
> new day's entry I have to re-type the patients' information. Is there a way
> to copy a previous entry for a patient and paste it on the new entry?
> Please help me as this adds a large amount of time to my work.
>
> Thank you,
> YC
> _______________________________________________
> EpiData-list mailing list
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 15 Feb 2010 13:22:33 -0500
> From: epidata-list(a)lists.umanitoba.ca
> Subject: Re: [EpiData-list] Copy and Paste an Entry?
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID: <BLU0-SMTP79433833F8433A3AF41361FD4A0(a)phx.gbl>
> Content-Type: text/plain; charset=us-ascii
>
> See the example titled "Relate example - Clinical Study with four forms" on
> the Examples page - click on the link on the main page at epidata.dk
> This is how to structure the related files.
> See the example titled "Relate example - Household, Person, Visit" to see
> how to copy information from one entry screen to another--you do this with
> GLOBAL variables.
>
> This is a very common set up for clinical records.
>
> Jamie Hockin
> Ottawa
>
> On 2010-02-15, at 11:40 AM, epidata-list(a)lists.umanitoba.ca wrote:
>
> >
> > Hello. I was wondering if it is possible to copy and paste an entry? I am
> > entering data for patients at a hospital by day, and each time I enter a
> > new day's entry I have to re-type the patients' information. Is there a
> way
> > to copy a previous entry for a patient and paste it on the new entry?
> > Please help me as this adds a large amount of time to my work.
> >
> > Thank you,
> > YC
> > _______________________________________________
> > 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 76, Issue 3
> *******************************************
>
--
Edson Byamukama
Po Box 12027 Kampala, Uganda
Office : +256 414251025
Mobile: +256 712202650
Hi there,
As I am not sure what information you have in your hands, I assume you could
add check before the data entry and chose the *repeat* option for the
required field information. Consequently, the information will remain until
you changed it.
Best wishes
Tieble
On 16 February 2010 18:00, <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: Copy and Paste an Entry? (epidata-list(a)lists.umanitoba.ca)
> 2. Re: Copy and Paste an Entry? (epidata-list(a)lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 15 Feb 2010 18:51:52 +0100
> From: epidata-list(a)lists.umanitoba.ca
> Subject: RE: [EpiData-list] Copy and Paste an Entry?
> To: <epidata-list(a)lists.umanitoba.ca>
> Message-ID: <00bf01caae67$8ee97710$acbc6530$@martin-prevel@ird.fr>
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> I think the best way to get round this problem is to have a relational data
> base with two files:
> (i) the "Master" file with patient's information
> (ii) the related file with daily information
>
> There are several examples of such related data entry and how it works on
> the Epidata website
>
> Hope this helps
>
> YMP
>
>
> -----Message d'origine-----
> De : epidata-list-bounces(a)lists.umanitoba.ca [mailto:
> epidata-list-bounces(a)lists.umanitoba.ca] De la part de
> epidata-list(a)lists.umanitoba.ca
> Envoyé : lundi 15 février 2010 17:38
> À : epidata-list(a)lists.umanitoba.ca
> Objet : [EpiData-list] Copy and Paste an Entry?
>
>
> Hello. I was wondering if it is possible to copy and paste an entry? I am
> entering data for patients at a hospital by day, and each time I enter a
> new day's entry I have to re-type the patients' information. Is there a way
> to copy a previous entry for a patient and paste it on the new entry?
> Please help me as this adds a large amount of time to my work.
>
> Thank you,
> YC
> _______________________________________________
> EpiData-list mailing list
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 15 Feb 2010 13:22:33 -0500
> From: epidata-list(a)lists.umanitoba.ca
> Subject: Re: [EpiData-list] Copy and Paste an Entry?
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID: <BLU0-SMTP79433833F8433A3AF41361FD4A0(a)phx.gbl>
> Content-Type: text/plain; charset=us-ascii
>
> See the example titled "Relate example - Clinical Study with four forms" on
> the Examples page - click on the link on the main page at epidata.dk
> This is how to structure the related files.
> See the example titled "Relate example - Household, Person, Visit" to see
> how to copy information from one entry screen to another--you do this with
> GLOBAL variables.
>
> This is a very common set up for clinical records.
>
> Jamie Hockin
> Ottawa
>
> On 2010-02-15, at 11:40 AM, epidata-list(a)lists.umanitoba.ca wrote:
>
> >
> > Hello. I was wondering if it is possible to copy and paste an entry? I am
> > entering data for patients at a hospital by day, and each time I enter a
> > new day's entry I have to re-type the patients' information. Is there a
> way
> > to copy a previous entry for a patient and paste it on the new entry?
> > Please help me as this adds a large amount of time to my work.
> >
> > Thank you,
> > YC
> > _______________________________________________
> > 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 76, Issue 3
> *******************************************
>
Hello. I was wondering if it is possible to copy and paste an entry? I am
entering data for patients at a hospital by day, and each time I enter a
new day's entry I have to re-type the patients' information. Is there a way
to copy a previous entry for a patient and paste it on the new entry?
Please help me as this adds a large amount of time to my work.
Thank you,
YC
Hello. I was wondering if it is possible to copy and paste an entry? I am
entering data for patients at a hospital by day, and each time I enter a
new day's entry I have to re-type the patients' information. Is there a way
to copy a previous entry for a patient and paste it on the new entry?
Please help me as this adds a large amount of time to my work.
Thank you,
YC
Hi
Just sharing my experience with the users here in calling Export command of Epic from check file in Epidata
The Dos command looks like this
c:\EpiC e excel d:\ves101\ves101.rec d:\ves101\VIV02081919_FARI.xls filter="fari1yes2n=1" DELETED REPLACE
However when I try the same in the check file, the filter did not get applied
My check file looks like this
sourcedir = "d:\ves101\"
INVES2 = COPY(INVESTIGAT,1,3)
mth2 = string(month(today))
d2 = string(day(today))
hr2 = string(hr)
mins3 = string(mins2)
recfile = sourcedir+"ves101.rec"
fariout = sourcedir+INVES2+mth2+d2+hr2+mins3+"_FARI.xls"
execute c:\epic.exe "e excel @recfile @fariout filter="fari1yes2n=1" DELETED REPLACE" wait
The EpiC.log file shows the following
Command: EpiC e excel d:\ves101\ves101.rec d:\ves101\VIV02081928_FARI.xls DELETED REPLACE
2/8/2010 7:29:15 PM
Exporting d:\ves101\ves101.rec to d:\ves101\VIV02081928_FARI.xls
Exports to: Excel
Records: All
Filter: None
Deleted records in inputfile are included in export
7 records with 18 fields exported
I can see that the " " around the Filter are creating the problem. Single quotes did not work
Command: EpiC e excel d:\ves101\ves101.rec d:\ves101\VIV02081952_FARI.xls filter='fari1yes2n=1' DELETED REPLACE
2/8/2010 7:52:25 PM
Exporting d:\ves101\ves101.rec to d:\ves101\VIV02081952_FARI.xls
Exports to: Excel
Records: All
Filter: 'fari1yes2n=1'
Deleted records in inputfile are included in export
0 records with 18 fields exported
Finally what did the trick was simply to remove the ""
execute c:\epic.exe "e excel @recfile @fariout filter=fari1yes2n=1 DELETED REPLACE" wait
EpiC Log shows:
Command: EpiC e excel d:\ves101\ves101.rec d:\ves101\VIV02081955_FARI.xls filter=fari1yes2n=1 DELETED REPLACE
2/8/2010 7:54:38 PM
Exporting d:\ves101\ves101.rec to d:\ves101\VIV02081955_FARI.xls
Exports to: Excel
Records: All
Filter: fari1yes2n=1
Deleted records in inputfile are included in export
5 records with 18 fields exported
I hope this information would be of use to some of the members. Am psoting it as searching through the archives did not yield much.
Another thing I noted was that the Zip files created by EpiC can not be opened by WinRAR or PkZIP on my machine though EPiC can extract the same just fine.
Thanks
,Dr. Vivek Gupta, MBBS, MD (Community Medicine)All India Institute of Medical Sciences
New Delhi.
Phone: (+91)9899410420
Alt. E-mail: drvivek(dot)gupta(at)gmail(dot)com