C:\Examples\Examples\exRelate\Goals.htm

Epi Info


Current View:Related.MDB:viewChildren
Record Count:7(Deleted records excluded) Date:3/3/2010 7:06:56 PM

LIST *



Child Name Child Birthdate Child HIV Positive at 18 Months? UniqueKey RecStatus FKey
Tom 11-11-2000 No 1 1 1
Mary 11-11-2002 No 2 1 1
Ralph 01-01-2004 Yes 3 1 1
Rene 11-11-2001 No 4 1 2
Leila 01-01-2004 No 5 1 4
Jose 01-01-2003 No 6 1 5
Matilda 01-01-2004 No 7 1 5




Current View:Related.MDB:viewChildren
Relate:viewMOTHER
Record Count:7(Deleted records excluded) Date:3/3/2010 7:06:56 PM

LIST *




Line Child Name Child Birthdate Child HIV Positive at 18 Months? Mother Record Number Mother Birthdate UniqueKey
1 Tom 11-11-2000 No 1 11-11-1980 1
2 Mary 11-11-2002 No 1 11-11-1980 2
3 Ralph 01-01-2004 Yes 1 11-11-1980 3
4 Rene 11-11-2001 No 2 11-11-1982 4
5 Leila 01-01-2004 No 44 11-11-1990 5
6 Jose 01-01-2003 No 555 11-11-1985 6
7 Matilda 01-01-2004 No 555 11-11-1985 7



Line RecStatus FKey UniqueKey RecStatus
1 1 1 1 1
2 1 1 1 1
3 1 1 1 1
4 1 2 2 1
5 1 4 4 1
6 1 5 5 1
7 1 5 5 1


LIST *




Line Child Name Child Birthdate Child HIV Positive at 18 Months? Mother Record Number Mother Birthdate UniqueKey
1 Tom 11-11-2000 No 1 11-11-1980 1
2 Mary 11-11-2002 No 1 11-11-1980 2
3 Ralph 01-01-2004 Yes 1 11-11-1980 3
4 Rene 11-11-2001 No 2 11-11-1982 4
5 Leila 01-01-2004 No 44 11-11-1990 5
6 Jose 01-01-2003 No 555 11-11-1985 6
7 Matilda 01-01-2004 No 555 11-11-1985 7



Line RecStatus FKey UniqueKey RecStatus MOTHERAGE
1 1 1 1 1 20
2 1 1 1 1 22
3 1 1 1 1 23
4 1 2 2 1 19
5 1 4 4 1 13
6 1 5 5 1 17
7 1 5 5 1 18




Current View:NewRelated.MDB:MotherChildAge
Record Count:7  Date:3/3/2010 7:06:56 PM

LIST *




Line ChildName ChildBirthdate ChildHivPositive MotherRecord MotherBirthdate FKey
1 Tom 11/11/2000 No 1 11/11/1980 1
2 Mary 11/11/2002 No 1 11/11/1980 1
3 Ralph 1/1/2004 Yes 1 11/11/1980 1
4 Rene 11/11/2001 No 2 11/11/1982 2
5 Leila 1/1/2004 No 44 11/11/1990 4
6 Jose 1/1/2003 No 555 11/11/1985 5
7 Matilda 1/1/2004 No 555 11/11/1985 5



Line RecStatus MOTHER_RecStatus UniqueKey MOTHERAGE
1 Yes Yes 1 20
2 Yes Yes 1 22
3 Yes Yes 1 23
4 Yes Yes 2 19
5 Yes Yes 4 13
6 Yes Yes 5 17
7 Yes Yes 5 18




Current View:Related.MDB:viewMOTHER
Relate:viewLabTests
Record Count:9(Deleted records excluded) Date:3/3/2010 7:06:57 PM

LIST *




Line Mother Record Number Mother Birthdate Lab Test Date Lab HIV Antibody Present? UniqueKey RecStatus
1 1 11-11-1980 11-11-2000 No 1 1
2 1 11-11-1980 11-11-2002 No 1 1
3 1 11-11-1980 11-11-2003 No 1 1
4 1 11-11-1980 01-01-2004 Yes 1 1
5 2 11-11-1982 11-11-2001 No 2 1
6 3 11-11-1979 11-11-2001 No 3 1
7 44 11-11-1990 01-01-2004 Yes 4 1
8 555 11-11-1985 01-01-2003 Yes 5 1
9 555 11-11-1985 02-02-2004 Yes 5 1



Line UniqueKey RecStatus FKey
1 1 1 1
2 2 1 1
3 3 1 1
4 4 1 1
5 5 1 2
6 6 1 3
7 7 1 4
8 8 1 5
9 9 1 5




Current View:Related.MDB:viewMOTHER
Relate:viewLabTests
Select:LabHivAntibody = (+)
Record Count:4(Deleted records excluded) Date:3/3/2010 7:06:57 PM

SUMMARIZE FirstHIVPosDate :: Min(LabTestDate) TO FirstHIVPosDate STRATAVAR=MotherRecord





Output table created: C:\Examples\Examples\exRelate\Related.MDB:FirstHIVPosDate

Current View:Related.MDB:viewMOTHER
Record Count:6(Deleted records excluded) Date:3/3/2010 7:06:57 PM

LIST *



Mother Record Number Mother Birthdate UniqueKey RecStatus
1 11-11-1980 1 1
2 11-11-1982 2 1
3 11-11-1979 3 1
44 11-11-1990 4 1
555 11-11-1985 5 1
- - 6 1




Current View:Related.MDB:viewMOTHER
Relate:FirstHIVPosDate
Record Count:6(Deleted records excluded) Date:3/3/2010 7:06:57 PM

LIST *



Mother Record Number Mother Birthdate MotherRecord FirstHIVPosDate UniqueKey RecStatus
1 11-11-1980 1 1/1/2004 1 1
2 11-11-1982 - - 2 1
3 11-11-1979 - - 3 1
44 11-11-1990 44 1/1/2004 4 1
555 11-11-1985 555 1/1/2003 5 1
- - - - 6 1




Current View:NewRelated.MDB:MotherPosDate
Relate:MotherChildAge
Select:ChildBirthdate >= FirstHIVPosDate
Record Count:24  Date:3/3/2010 7:06:58 PM

FREQ ChildHivPositive



ChildHivPositive Frequency Percent Cum Percent  
Yes625.0%25.0%
No1875.0%100.0%
Total24100.0%100.0%