>
>
> >sort ID PERIOD POFFSET
>gen MARK=1
>if (ID = ID[-1]) and (PERIOD=PERIOD[-1]) then MARK = 0
This is a great approach. I just want to add something. According to my
understanding, this would make MARK=1 for the records with the smallest
number of one set of ID and PERIOD. But it does not necessarily mean that
the record with MARK=1 would be closest the expected date.
In this example,
> Each period I select (M3, M6, M12...) I give an allowance of + &- 10
days.
> (e.g. for M3=90 days from the day of enrollment, I select between day 80
> and day 100). This is because patients did not always respect their
> appointment dates.
for some reasons, if the patient came at 81 and 93 days, PERIOD would be -9
and 3 respectively and the record with PERIOD=-9 would be selected (MARK=1)
which is not desirable. To avoid this situation, we just need to neutralize
the minus sign of POFFSET by doing this before sorting ID PERIOD POFFSET.
So, I would suggest the following command:
if POFFSET<0 then POFFSET= -1*POFFSET[_n]
sort ID PERIOD POFFSET
gen MARK=1
if (ID = ID[-1]) and (PERIOD=PERIOD[-1]) then MARK = 0
Best wishes,
Zaw
> Message: 5
> Date: Mon, 27 Aug 2012 08:23:24 -0400
> From: epidata-list(a)lists.umanitoba.ca
> Subject: Re: [EpiData-list] Epidata analysis
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID: <BLU0-SMTP250E7B96809BAD9A83BDABFDA20(a)phx.gbl>
> Content-Type: text/plain; charset="windows-1252"
>
> The approach to this would be:
>
> - create the new variable that identifies period (I'm not sure why you use
> more than one) (PERIOD)
> - create a new variable that equals the number of days between expected
> and actual visit (POFFSET)
> - SORT the data on patient ID, PERIOD and POFFSET
> - create a new variable to mark the first record you find for a given
> patient and period (MARK)
> You do the last two steps like this:
>
> sort ID PERIOD POFFSET
> gen MARK=1
> if (ID = ID[-1]) and (PERIOD=PERIOD[-1]) then MARK = 0
>
> MARK will set to zero for the second visit for any patient in a period
> (because ID and PERIOD will be the same as previous)
>
> Jamie
>
> On 2012-08-27, at 3:11 AM, epidata-list(a)lists.umanitoba.ca wrote:
>
> > I have a “.rec” Epidata data set with patients with chronic diseases
> > (Diabetes and Hypertension). I would like to undertake some analysis to
> > determine what is happening on the patients at different periods of
> follow
> > up. (Month 3, 6, 12........)
> >
> > i.e. Glucose levels, BP, BMI.......
> >
> >
> >
> > Each period I select (M3, M6, M12...) I give an allowance of + &- 10
> days.
> > (e.g. for M3=90 days from the day of enrollment, I select between day 80
> > and day 100). This is because patients did not always respect their
> > appointment dates.
> >
> >
> >
> > In the period selected (between day 80 -100) some patients for several
> > reasons were seen more than once. I would like to select only one visit
> > date in case of moth 3 follow up that is closest to the 90th day from
> date
> > of enrollment .(e.g. a patient had a visit on the 80th day and 95th day,
> I
> > want to select the 95th day visit which is closest to day 90).....
> >
> >
> >
> > How do I do this with Epidata analysis?
> >
> >
> >
> > NB: My variables are “enrolment date” and “visit date”
> >
> >
> >
> > Kwal
> > _______________________________________________
> > 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 106, Issue 17
> *********************************************
>
I have a “.rec” Epidata data set with patients with chronic diseases
(Diabetes and Hypertension). I would like to undertake some analysis to
determine what is happening on the patients at different periods of follow
up. (Month 3, 6, 12........)
i.e. Glucose levels, BP, BMI.......
Each period I select (M3, M6, M12...) I give an allowance of + &- 10 days.
(e.g. for M3=90 days from the day of enrollment, I select between day 80
and day 100). This is because patients did not always respect their
appointment dates.
In the period selected (between day 80 -100) some patients for several
reasons were seen more than once. I would like to select only one visit
date in case of moth 3 follow up that is closest to the 90th day from date
of enrollment .(e.g. a patient had a visit on the 80th day and 95th day, I
want to select the 95th day visit which is closest to day 90).....
How do I do this with Epidata analysis?
NB: My variables are “enrolment date” and “visit date”
Kwal
Now it is clear that the converting (aka Import, "Add data
structure...") of REC-files into the new epx-format doesn't work
100%tly.
Plausibility checks are not importet. This is one of the BUGs I can see.
Maybe there get more lost in the conversion.
Is there a bug-tracking system where I can add and monitore it?
Where can I see the development time table?
I really need to update my project to the new format. Of course I need a
complete converting routine for it. I won't do any work again that was
done before in the old version.
I really need an older version of EpiData to do some tests.
How can I get
"Epidata version 3.1 - build 22feb2005"
?
I've never used it. But I converted old rec-files to epx-format. Now
there is now plausibility check or default values while entering data
with EntryClient. I am not sure if it causes in the conversion or if it
is "normal" because the old rec-files behave the same way.
I need to test it.
thanks jamie
On Fri, Aug 24, 2012 at 7:00 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. Entering qualitative data (epidata-list(a)lists.umanitoba.ca)
> 2. Selecting multiple options (epidata-list(a)lists.umanitoba.ca)
> 3. Entering comments (epidata-list(a)lists.umanitoba.ca)
> 4. Re: Selecting multiple options (epidata-list(a)lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 24 Aug 2012 09:12:45 +0300
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Entering qualitative data
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID:
> <CAMDO718Mq6dregorkEVsiMin8Y2HdWLq5ry=
> 7py8nHRveZsh0Q(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> How can i enter data like subject responses
> for example
>
> 41.When is measles vaccine supposed to be given?
>
> the answer is a sentance
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 24 Aug 2012 09:09:28 +0300
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Selecting multiple options
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID:
> <CAMDO719-BagngiaPiXwcdjXELWJzmKMer7eVaxAtrMizV=
> 5wpg(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear all,
> How do i make it possible for multiple options in the questionaire to be
> picked instead of only one.
> For example.
>
> 3.Since This time Yesterday Has the child recieved any of the
> following?(Tick all that Apply)
>
> ÿ 1 = Vitamin,Mineral supplementation orMedicine
>
> ÿ 2 = Plain water
>
> ÿ 3 = Sweetened, flavoured water or fruit juice or tea or infusion
>
> * *
>
> ÿ 4 = Oral rehydration solution (ORS).
>
> * *
>
> ÿ 5 = Tinned, powdered or fresh milk or infant formula.
>
> ÿ 6 = Solid or semi-solid (mushy) food
>
> * *
>
> ÿ 7 = Any other liquids (specify):
>
> * *
>
> * *
> How do i set it that all chosen options are entered.
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 24 Aug 2012 10:26:00 +0300
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Entering comments
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID:
> <CAMDO71-kxz9PmWn=
> QLC2AkQ9+5wUzVKKLtXeMQThzQOWX2WWkQ(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear all,
> Please advise on how to enter comments
> for example
>
> 10 If Yes,Who:
>
> ÿ 1=Husband
>
>
>
> ÿ 2=Mother
>
>
>
> ÿ 3=Mother-in-law
>
>
>
> ÿ 4=Family Member: Other
>
>
>
> ÿ 5=Physician or Other Health Practioner
>
>
>
> ÿ6=Community Health Worker
>
>
>
> ÿ7=Traditional Healer
>
>
>
> ÿ8=Relative or Neighbour
>
>
>
> ÿ9=Radio Programme
>
>
>
> ÿ10=Other (specify):
>
>
>
>
>
>
>
>
>
> How in the qes do i allow room for comments on 4. and 10.
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 24 Aug 2012 08:48:57 -0400
> From: epidata-list(a)lists.umanitoba.ca
> Subject: Re: [EpiData-list] Selecting multiple options
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID: <BLU0-SMTP55BA1CF8BA34AB3B7892B3FDBD0(a)phx.gbl>
> Content-Type: text/plain; charset="us-ascii"
>
> This and two other questions are probably from the same person. It is
> really important to say whether you are working with classic EpiData
> (Entry) or the new EpiData (EpiDataManager and EpiDataEntryClient)
>
> For either version, however, you can use a series of fields to record
> answers to question like the one you have
>
> > 3.Since This time Yesterday Has the child recieved any of the
> > following?(Tick all that Apply)
>
> Each of the responses has its own field definition. You can use a Boolean
> (Yes/No) for each, or code them any way you want as a single digit or
> character.
>
> The other two questions have the same answer - use a text field.
>
> PLEASE, look at the many examples posted on the web site (epidata.dk) to
> understand how to use EpiData. There is also a good, short overview
> document there.
>
> Jamie
>
> On 2012-08-24, at 2:09 AM, epidata-list(a)lists.umanitoba.ca wrote:
>
> > How do i make it possible for multiple options in the questionaire to be
> > picked instead of only one.
> > For example.
>
>
>
> ------------------------------
>
> ________________________________________
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 106, Issue 14
> *********************************************
>
Dear all,
How do i make it possible for multiple options in the questionaire to be
picked instead of only one.
For example.
3.Since This time Yesterday Has the child recieved any of the
following?(Tick all that Apply)
ÿ 1 = Vitamin,Mineral supplementation orMedicine
ÿ 2 = Plain water
ÿ 3 = Sweetened, flavoured water or fruit juice or tea or infusion
* *
ÿ 4 = Oral rehydration solution (ORS).
* *
ÿ 5 = Tinned, powdered or fresh milk or infant formula.
ÿ 6 = Solid or semi-solid (mushy) food
* *
ÿ 7 = Any other liquids (specify):
* *
* *
How do i set it that all chosen options are entered.
Dear all,
Please advise on how to enter comments
for example
10 If Yes,Who:
ÿ 1=Husband
ÿ 2=Mother
ÿ 3=Mother-in-law
ÿ 4=Family Member: Other
ÿ 5=Physician or Other Health Practioner
ÿ6=Community Health Worker
ÿ7=Traditional Healer
ÿ8=Relative or Neighbour
ÿ9=Radio Programme
ÿ10=Other (specify):
How in the qes do i allow room for comments on 4. and 10.
I have 7 old REC-files. I imported them to the new data format with "add structure".
I saw that I can append all sheets together to one big sheet. But I don't want it.
Is there a way to create one project (epx-file) with 7 separate sub-sheets in it?