Hi--
With the data below, I would like to calculate a simple new variable within (bysort) each facility (var: facility) and time period (var: period) that is essentially the results (var: results_) for the viral load suppressed/viral load done ('Adult VLS'/'Adult VLD' (var: dataelement)).
I have set the file up in long format which makes this a bit more complex to me in the sense that I am creating this new variable with panel data rather than with unique variables.
Any help would be greatly appreciated.
Best-Patrick
input float idnum str13 period int results_ str25 province str51 metrodis str47 subdistrict str62 facility str9 dataelement
1 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
2 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "4jantomar2017" 30 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
3 "1jultosep2016" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "2octtodec2016" 24 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "3aprtojun2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
4 "1jultosep2016" 27 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "4jantomar2017" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
5 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
6 "1jultosep2016" 6 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "4jantomar2017" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
7 "1jultosep2016" 10 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "3aprtojun2017" 12 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "4jantomar2017" 16 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
8 "1jultosep2016" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
9 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "2octtodec2016" 10 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "4jantomar2017" 19 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
10 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "3aprtojun2017" 23 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "4jantomar2017" 26 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
11 "1jultosep2016" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "2octtodec2016" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
12 "1jultosep2016" 7 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "3aprtojun2017" 11 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "4jantomar2017" 10 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
13 "1jultosep2016" 15 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "2octtodec2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "3aprtojun2017" 11 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "4jantomar2017" 18 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
14 "1jultosep2016" 28 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "2octtodec2016" 41 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "3aprtojun2017" 54 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "4jantomar2017" 46 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
15 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "2octtodec2016" 36 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "3aprtojun2017" 19 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "4jantomar2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
16 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "2octtodec2016" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "4jantomar2017" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
17 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "4jantomar2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
18 "1jultosep2016" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "2octtodec2016" 12 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "3aprtojun2017" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "4jantomar2017" 20 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
19 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "2octtodec2016" 5 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "4jantomar2017" 5 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
20 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "2octtodec2016" 6 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "4jantomar2017" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
21 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "3aprtojun2017" 6 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
22 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
23 "1jultosep2016" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "2octtodec2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
24 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "3aprtojun2017" 12 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "4jantomar2017" 27 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
25 "1jultosep2016" 7 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "2octtodec2016" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
end
With the data below, I would like to calculate a simple new variable within (bysort) each facility (var: facility) and time period (var: period) that is essentially the results (var: results_) for the viral load suppressed/viral load done ('Adult VLS'/'Adult VLD' (var: dataelement)).
I have set the file up in long format which makes this a bit more complex to me in the sense that I am creating this new variable with panel data rather than with unique variables.
Any help would be greatly appreciated.
Best-Patrick
input float idnum str13 period int results_ str25 province str51 metrodis str47 subdistrict str62 facility str9 dataelement
1 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
1 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
2 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
2 "4jantomar2017" 30 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
3 "1jultosep2016" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "2octtodec2016" 24 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "3aprtojun2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
3 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
4 "1jultosep2016" 27 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
4 "4jantomar2017" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
5 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
5 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
6 "1jultosep2016" 6 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
6 "4jantomar2017" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
7 "1jultosep2016" 10 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "3aprtojun2017" 12 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
7 "4jantomar2017" 16 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLD"
8 "1jultosep2016" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
8 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Block H Clinic" "Adult VLD"
9 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "2octtodec2016" 10 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
9 "4jantomar2017" 19 "ec Eastern Cape Province" "ec Joe Gqabi District Municipality" "ec Walter Sisulu Local Municipality" "ec Aliwal North Hospital" "Adult VLD"
10 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "3aprtojun2017" 23 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
10 "4jantomar2017" 26 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Gateway Clinic" "Adult VLD"
11 "1jultosep2016" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "2octtodec2016" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
11 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Engcobo Local Municipality" "ec All Saints Hospital" "Adult VLD"
12 "1jultosep2016" 7 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "3aprtojun2017" 11 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
12 "4jantomar2017" 10 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Alphendale Clinic" "Adult VLD"
13 "1jultosep2016" 15 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "2octtodec2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "3aprtojun2017" 11 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
13 "4jantomar2017" 18 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Amahlathi Local Municipality" "ec Amabele Clinic" "Adult VLD"
14 "1jultosep2016" 28 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "2octtodec2016" 41 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "3aprtojun2017" 54 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
14 "4jantomar2017" 46 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amadiba Clinic" "Adult VLD"
15 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "2octtodec2016" 36 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "3aprtojun2017" 19 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
15 "4jantomar2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Mbizana Local Municipality" "ec Amantshangase Clinic" "Adult VLD"
16 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "2octtodec2016" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
16 "4jantomar2017" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Amathole Basin Clinic" "Adult VLD"
17 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
17 "4jantomar2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Kouga Local Municipality" "ec Andrieskraal Clinic" "Adult VLD"
18 "1jultosep2016" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "2octtodec2016" 12 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "3aprtojun2017" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
18 "4jantomar2017" 20 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Makana Local Municipality" "ec Anglo African Street Clinic" "Adult VLD"
19 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "2octtodec2016" 5 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
19 "4jantomar2017" 5 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Sakhisizwe Local Municipality" "ec Askeaton Clinic" "Adult VLD"
20 "1jultosep2016" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "2octtodec2016" 6 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
20 "4jantomar2017" 9 "ec Eastern Cape Province" "ec Buffalo City Metropolitan Municipality" "ec Buffalo City Health sub-District" "ec Aspiranza Clinic" "Adult VLD"
21 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "3aprtojun2017" 6 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
21 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Assina Mandla Clinic" "Adult VLD"
22 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
22 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Enoch Mgijima Local Municipality" "ec Bacclesfarm Clinic" "Adult VLD"
23 "1jultosep2016" 4 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "2octtodec2016" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
23 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Mbhashe Local Municipality" "ec Badi Clinic" "Adult VLD"
24 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "2octtodec2016" 17 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "3aprtojun2017" 12 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
24 "4jantomar2017" 27 "ec Eastern Cape Province" "ec Oliver Tambo District Municipality" "ec Ingquza Hill Local Municipality" "ec Bala Clinic" "Adult VLD"
25 "1jultosep2016" 7 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "2octtodec2016" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
25 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Balfour Clinic" "Adult VLD"
end
Comment