Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculating a new variable based on panel variable values and groups

    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

  • #2
    Far from being simple, the calculation

    viral load suppressed/viral load done

    is unclear to me and perhaps to anyone else who hasn't worked with this kind of data.

    Thanks for your data example, but every observation here has Adult VLD. So, how would you work given some observations for Adult VLS?

    Comment


    • #3
      Apologies as a I had sorted on the 'dataelement' variable before generating this snapshort. A more complete sample provided below.

      For clarification, I would like to generate a proportion that is calculated as the [var: results] values within the [var: dataelement] : Adult VLS/Adult VLD. Perhaps it is more clear to describe it as:
      (results for Adult VLS/results for Adult VLD) for each 'facility' and 'period'?

      Let me know if this clarifies?

      I am hoping to do this in the long (panel) format but could also reformat to a wide format if that is the best solution.

      Thanks-Patrick


      input float idnum str13 period int results_ str25 province str51 metrodis str47 subdistrict str62 facility str9 dataelement
      3789 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
      10589 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
      1 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
      10589 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
      1 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
      3789 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
      7577 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
      7577 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
      1 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
      10589 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
      7577 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
      3789 "1jultosep2016" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
      7577 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
      10589 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
      3789 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
      1 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
      10590 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
      3790 "1jultosep2016" 15 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
      3790 "4jantomar2017" 22 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
      10590 "2octtodec2016" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
      7578 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
      2 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
      7578 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
      2 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
      3790 "2octtodec2016" 13 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
      10590 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
      10590 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
      3790 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
      7578 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
      7578 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
      2 "2octtodec2016" 14 "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 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
      3791 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
      10591 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
      10591 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
      7579 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
      3 "1jultosep2016" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
      3791 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
      10591 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
      3791 "2octtodec2016" 22 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
      3791 "3aprtojun2017" 7 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
      7579 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child 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 "2octtodec2016" 24 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
      10591 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
      7579 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
      7579 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
      10592 "1jultosep2016" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
      10592 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
      7580 "3aprtojun2017" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
      3792 "1jultosep2016" 25 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
      3792 "4jantomar2017" 12 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
      7580 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
      3792 "2octtodec2016" 12 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
      10592 "3aprtojun2017" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
      3792 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
      4 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
      10592 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
      4 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
      7580 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
      7580 "1jultosep2016" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
      4 "1jultosep2016" 27 "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 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
      3793 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
      5 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
      10593 "4jantomar2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
      10593 "3aprtojun2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
      5 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
      10593 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
      3793 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
      7581 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
      10593 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
      7581 "4jantomar2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
      7581 "3aprtojun2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
      3793 "4jantomar2017" 6 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
      5 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
      7581 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
      3793 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
      10594 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
      3794 "4jantomar2017" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
      7582 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
      3794 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
      10594 "2octtodec2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
      7582 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
      10594 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
      6 "1jultosep2016" 6 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
      7582 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
      3794 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
      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"
      6 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
      7582 "2octtodec2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
      10594 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
      3794 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
      7583 "4jantomar2017" . "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLD"
      7583 "2octtodec2016" . "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLD"
      3795 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLS"
      10595 "1jultosep2016" 0 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLS"
      end
      [/CODE]

      Comment


      • #4
        That is a more helpful data example but I am not much nearer knowing what you want to calculate.

        Format is an overloaded word in computing (file format, display format, data format). I tend to follow Clyde Schechter's practice of talking about data layout. So wide layout in the sense that the four categories of dataelement are used to define four variables of results does seem a good idea if you want ratios such as Adult VLS/Adult VLD.

        But I still have no idea of how those are to be summarised by facility and period. The results here may well be nonsense but conversely if you can't adapt the code here to what you want I think further clarification is essential.

        Note the need for both CODE delimiters and my use of a more orthodox Stata quarterly date.

        Code:
        clear 
        
        input float idnum str13 period int results_ str25 province str51 metrodis str47 subdistrict str62 facility str9 dataelement
        3789 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
        10589 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
        1 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
        10589 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
        1 "2octtodec2016" 18 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
        3789 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
        7577 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
        7577 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
        1 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
        10589 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
        7577 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
        3789 "1jultosep2016" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
        7577 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLD"
        10589 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Child VLS"
        3789 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLS"
        1 "3aprtojun2017" 10 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Sundays River Valley Local Municipality" "ec Addo Clinic" "Adult VLD"
        10590 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
        3790 "1jultosep2016" 15 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
        3790 "4jantomar2017" 22 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
        10590 "2octtodec2016" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
        7578 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
        2 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
        7578 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
        2 "1jultosep2016" 19 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLD"
        3790 "2octtodec2016" 13 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
        10590 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
        10590 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLS"
        3790 "3aprtojun2017" 9 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Adult VLS"
        7578 "3aprtojun2017" 0 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
        7578 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Amathole District Municipality" "ec Raymond Mhlaba Local Municipality" "ec Adelaide Gateway Clinic" "Child VLD"
        2 "2octtodec2016" 14 "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 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
        3791 "4jantomar2017" 17 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
        10591 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
        10591 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
        7579 "3aprtojun2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
        3 "1jultosep2016" 16 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
        3791 "1jultosep2016" 13 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
        10591 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
        3791 "2octtodec2016" 22 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
        3791 "3aprtojun2017" 7 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLS"
        7579 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child 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 "2octtodec2016" 24 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Adult VLD"
        10591 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLS"
        7579 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
        7579 "4jantomar2017" 2 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Blue Crane Route Local Municipality" "ec Aeroville Clinic" "Child VLD"
        10592 "1jultosep2016" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
        10592 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
        7580 "3aprtojun2017" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
        3792 "1jultosep2016" 25 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
        3792 "4jantomar2017" 12 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
        7580 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
        3792 "2octtodec2016" 12 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
        10592 "3aprtojun2017" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
        3792 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLS"
        4 "2octtodec2016" 14 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
        10592 "2octtodec2016" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLS"
        4 "3aprtojun2017" 18 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Adult VLD"
        7580 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
        7580 "1jultosep2016" . "ec Eastern Cape Province" "ec Alfred Nzo District Municipality" "ec Matatiele Local Municipality" "ec Afsondering Clinic" "Child VLD"
        4 "1jultosep2016" 27 "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 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
        3793 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
        5 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
        10593 "4jantomar2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
        10593 "3aprtojun2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
        5 "3aprtojun2017" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
        10593 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
        3793 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
        7581 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
        10593 "2octtodec2016" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLS"
        7581 "4jantomar2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
        7581 "3aprtojun2017" . "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
        3793 "4jantomar2017" 6 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
        5 "4jantomar2017" 8 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLD"
        7581 "1jultosep2016" 1 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Child VLD"
        3793 "2octtodec2016" 2 "ec Eastern Cape Province" "ec Chris Hani District Municipality" "ec Emalahleni Local Municipality" "ec Agnes Rest Clinic" "Adult VLS"
        10594 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
        3794 "4jantomar2017" 11 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
        7582 "4jantomar2017" 1 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
        3794 "1jultosep2016" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
        10594 "2octtodec2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
        7582 "3aprtojun2017" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
        10594 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
        6 "1jultosep2016" 6 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
        7582 "1jultosep2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
        3794 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
        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"
        6 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLD"
        7582 "2octtodec2016" . "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLD"
        10594 "4jantomar2017" 0 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Child VLS"
        3794 "3aprtojun2017" 5 "ec Eastern Cape Province" "ec Sarah Baartman District Municipality" "ec Ndlambe Local Municipality" "ec Alexandria Clinic" "Adult VLS"
        7583 "4jantomar2017" . "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLD"
        7583 "2octtodec2016" . "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLD"
        3795 "2octtodec2016" 15 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Adult VLS"
        10595 "1jultosep2016" 0 "ec Eastern Cape Province" "ec Nelson Mandela Bay Municipality" "ec Nelson Mandela C Health sub-District" "ec Algoa Park Clinic" "Child VLS"
        end
        
        label def which 1 "Child VLS" 2 "Child VLD" 3 "Adult VLS" 4 "Adult VLD"
        encode dataelement, gen(which) label(which)
        reshape wide results_, j(which) i(idnum period)
        
        forval j = 1/4 { 
            egen results_`j'_total = total(results_`j'), by(period facility) 
        } 
        
        gen wanted = results_3_total/results_4_total 
        
        gen qdate = yq(2016, 2) + real(substr(period,1,1))
        format qdate %tq 
        
        tabdisp facility qdate, c(wanted) 
        
        -------------------------------------------------------------------
                                   |                 qdate                 
                          facility |   2016q3    2016q4    2017q1    2017q2
        ---------------------------+---------------------------------------
                    ec Addo Clinic | .8461539  .8333333         1         1
        ec Adelaide Gateway Clinic | .7894737  .9285714         1  .7333333
               ec Aeroville Clinic |    .8125  .9166667      .875         1
             ec Afsondering Clinic | .9259259  .8571429         1  .8571429
              ec Agnes Rest Clinic |        1         1         1       .75
              ec Alexandria Clinic | .8333333         1         1         1
              ec Algoa Park Clinic |                                       
        -------------------------------------------------------------------

        Comment

        Working...
        X