Dear users,
As I attempted to copy structure on an existing file in the dialogue box "Copy file structure" the options check box for "copy *c*heck file" is not accessible. What could be the problem?
Omala
On 13 June 2013 20:00, epidata-list-request@lists.umanitoba.ca wrote:
Send EpiData-list mailing list submissions to epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@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:
- Bug on import in Manager (public release 1.4.1.0) (epidata-list@lists.umanitoba.ca)
- How to count the number of missing values in an observation/record/row (epidata-list@lists.umanitoba.ca)
- Re: How to count the number of missing values in an observation/record/row (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Thu, 13 Jun 2013 08:05:33 GMT From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Bug on import in Manager (public release 1.4.1.0) To: epidata-list@lists.umanitoba.ca Message-ID: 1371110733382.14178.2158@webmail02 Content-Type: text/plain; charset=UTF-8
We have found a bug in the most recent public release version of EpiData Manager 1.4.1.0.
With the bug import of epx and other files into a project with "renaming" of value label sets gives an error. This will be fixed and a new version uploaded within short time. (days)
This is only relevant for the situation where you add files depending on naming of value label sets.
If other bugs have been identified please report, such that we can fix these as well.
regards
Jens Lauritsen EpiData Association
Message: 2 Date: Thu, 13 Jun 2013 14:39:48 +0700 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] How to count the number of missing values in an observation/record/row To: epidata-list@lists.umanitoba.ca Message-ID: < CAPLSYrXc_P9+LsC0wDO0Yvm1WCAfpYuLhOP+5c1O-JkfNSNtKA@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Dear sirs/madams,
My name is Anh. I am a student from Vietnam. I would like to calculate the number of missing values/entered values in a record.
I had a look at Epidata manual but I could not find any relevant instructions. Could you please help me with this problem?
Thank you so much,
Anh Dang
........................................................
Details of my problem:
My checklist contains 5 variables. Each variable is given a score (0,1,2), but in some records, a few variables are left blank because they are not relevant. The final score is calculated by dividing the sum of score of each variable (don't take the missing into account) by the 'total number of entered variables'. id var1 var2 var3 var4 var5 1 2 1 1 0 final score = (2+1+1+0)/4 ( I use the command 'ignoremissing' to get the sum) 2 2 2 2 1 1 final score = (2+2+2+1+1)/5 3 1 1 final score=(1+1)/2
Message: 3 Date: Thu, 13 Jun 2013 08:44:26 -0400 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] How to count the number of missing values in an observation/record/row To: epidata-list@lists.umanitoba.ca Message-ID: BLU0-SMTP795C0548F993B63377ADD1FD870@phx.gbl Content-Type: text/plain; charset="us-ascii"
I assume you are doing this in Analysis. The solution is similar for a .chk file, but the syntax is different. It is also a bit tricky doing this in a .chk file because values can be changed after the calculation is done if you are not careful.
- c is count of non-missing variables
- s is sum of non-missing variables
- score is final score (average of non-missing variables)
gen c=0 gen s=0 if var1 <> . then c=c+1 if var1 <> . then s=s+var1 if var2 <> . then c=c+1 if var2 <> . then s=s+var2 if var3 <> . then c=c+1 if var3 <> . then s=s+var3 if var4 <> . then c=c+1 if var4 <> . then s=s+var4 if var5 <> . then c=c+1 if var5 <> . then s=s+var5 gen score = s/c
if you do not have any defined missing values, you can also calculate c this way:
c = 5-mv(var1)-mv(var2)-mv(var3)-mv(var4)-mv(var5)
and you can also calculate s this way:
s=iif(var1<>. , var1,0)+iif(var2<>. , var2,0)+iif(var3<>. , var3,0)+iif(var4<>. , var4,0)+iif(var5<>. , var5,0)
Check the help for these functions to see how they work: mv() and iif()
Jamie
On 2013-06-13, at 3:39 AM, epidata-list@lists.umanitoba.ca wrote:
Details of my problem:
My checklist contains 5 variables. Each variable is given a score
(0,1,2),
but in some records, a few variables are left blank because they are not relevant. The final score is calculated by dividing the sum of score of each variable (don't take the missing into account) by the 'total number
of
entered variables'. id var1 var2 var3 var4 var5 1 2 1 1 0 final score = (2+1+1+0)/4 ( I use the command 'ignoremissing' to get the sum) 2 2 2 2 1 1 final score = (2+2+2+1+1)/5 3 1 1 final
score=(1+1)/2
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 116, Issue 3