Using levelsof in scatterplot with multiple variables

[Michal Onah]

Hi Everyone

I am a beginner in Stata and would greatly appreciate any help.

I appended data from multiple datasets with similar variables and want to plot a graph for some variables over a few other. I also have a weight variable and a unique identifier for each variable contained in the dataset. All the variables are binary (0/1) except for the weight variable and unique identifier. The data is merged from 20 different sources representing 20 countries.

For one graph, I would like to plot oop_drugs oop_IP oop_OP over cata_nf_40 and cata_tot_10. For the other graph, I want to plot cata_nf_40 cata_tot_10 over hh_nexcap_quintile and hh_urban. I hope to have each indicator for all the countries in the dataset represented by an identifier (ID) which is string. For instance, for the ID variable, Uganda will be "UGA", Cambodia will be "KHM", etc. I also want to apply the population weights [popweight] and label the outputs.

Please how can I do this in Stata? Any ideas will be most appreciated!

I tried using the code below it doesnt execute. Ideally, I would also want to have this for cata_nf_40 and cata_tot_10

levelsof ID, local(levels)
    . foreach `l' of local levels {
    .        di "-> ID = `: label (ID) `l''"
    .       graph twoway (scatter oop_drugs oop_IP oop_OP cata_nf_40) if factor == `l'
    . }

Fnd below a sample of my dataset

* Example generated by -dataex-. To install: ssc install dataex
clear
input float popweight byte hh_nexpcap_quintile float(oop_drugs oop_OP oop_IP cata_nf_40 cata_tot_10 hh_urban) str3 ID
 8377 5 0 0 1 . 1 0 "UGA"
 8377 5 0 0 0 . 1 0 "UGA"
 8377 3 1 0 0 . 1 0 "UGA"
 9373 5 0 0 1 . 0 1 "UGA"
 3749 5 1 0 0 . 0 1 "UGA"
 1874 5 1 0 0 . 0 1 "UGA"
 7499 4 1 0 0 . 0 1 "UGA"
11248 5 1 0 0 . 0 1 "UGA"
11248 5 1 0 0 . 0 1 "UGA"
11248 4 1 0 0 . 0 1 "UGA"
 7499 5 0 0 1 . 0 1 "UGA"
11248 5 1 0 0 . 0 1 "UGA"
16873 5 0 1 0 . 0 1 "UGA"
16873 5 1 0 0 . 0 1 "UGA"
16873 5 0 0 1 . 0 1 "UGA"
 1874 5 0 1 0 . 0 1 "UGA"
 1874 5 1 0 0 . 0 1 "UGA"
 1874 5 0 0 1 . 0 1 "UGA"
 9373 5 1 0 0 . 0 1 "UGA"
 2499 4 0 0 1 . 0 1 "UGA"
 3124 5 1 0 0 . 0 1 "UGA"
 7499 5 1 0 0 . 1 1 "UGA"
11248 4 1 0 0 . 1 1 "UGA"
11248 4 0 0 1 . 1 1 "UGA"
 1874 5 1 0 0 . 1 1 "UGA"
 5624 5 0 1 0 . 1 1 "UGA"
 5624 5 1 0 0 . 1 1 "UGA"
11248 5 1 0 0 . 1 1 "UGA"
11248 5 0 0 1 . 1 1 "UGA"
 9373 4 1 0 0 . 0 1 "UGA"
11248 5 1 0 0 . 0 1 "UGA"
 4686 4 1 0 0 . 0 1 "UGA"
13123 5 1 0 0 . 0 1 "UGA"
 9373 5 1 0 0 . 0 1 "UGA"
 9373 5 0 0 1 . 0 1 "UGA"
 7499 5 1 0 0 . 0 1 "UGA"
 7499 5 0 0 1 . 0 1 "UGA"
20622 4 1 0 0 . 0 1 "UGA"
11248 4 1 0 0 . 0 1 "UGA"
11248 5 1 0 0 . 0 1 "UGA"
 3749 5 1 0 0 . 0 0 "UGA"
 7499 5 0 1 0 . 0 1 "UGA"
 7499 5 1 0 0 . 0 1 "UGA"
 7499 5 0 0 1 . 0 1 "UGA"
 7499 5 1 0 0 . 0 1 "UGA"
 1874 5 1 0 0 . 0 0 "UGA"
20622 5 0 1 0 . 0 1 "UGA"
20622 5 1 0 0 . 0 1 "UGA"
 2812 5 1 0 0 . 0 1 "UGA"
 7499 5 1 0 0 . 0 1 "UGA"
 2812 5 1 0 0 . 0 1 "UGA"
 5624 5 1 0 0 . 0 1 "UGA"
13123 4 0 1 0 . 0 1 "UGA"
13123 4 1 0 0 . 0 1 "UGA"
 3749 5 1 0 0 . 0 1 "UGA"
13123 5 1 0 0 . 1 1 "UGA"
13123 5 0 0 1 . 1 1 "UGA"
 5624 5 1 0 0 . 0 1 "UGA"
 9373 4 1 0 0 . 0 0 "UGA"
 9373 5 1 0 0 . 0 1 "UGA"
10206 4 1 0 0 . 0 0 "UGA"
25517 2 0 0 1 . 1 0 "UGA"
10206 5 1 0 0 . 0 0 "UGA"
 7655 3 1 0 0 . 0 0 "UGA"
 4252 4 1 0 0 . 1 0 "UGA"
10206 3 0 0 1 . 0 0 "UGA"
17861 4 0 0 1 . 0 0 "UGA"
15310 4 1 0 0 . 0 0 "UGA"
15310 4 0 0 0 . 0 0 "UGA"
10206 5 1 0 0 . 1 0 "UGA"
10206 5 0 0 0 . 1 0 "UGA"
15310 4 0 0 1 . 0 0 "UGA"
 8930 4 1 0 0 . 0 0 "UGA"
 1275 5 1 0 0 . 0 1 "UGA"
10206 3 1 0 0 . 1 0 "UGA"
 2551 3 1 0 0 . 1 0 "UGA"
 2551 3 0 0 1 . 0 0 "UGA"
15310 5 1 0 0 . 0 1 "UGA"
12758 3 0 0 1 . 0 1 "UGA"
15310 4 1 0 0 . 0 1 "UGA"
10206 4 1 0 0 . 0 0 "UGA"
17861 4 1 0 0 . 0 0 "UGA"
17861 4 0 0 1 . 0 0 "UGA"
10206 5 1 0 0 . 0 0 "UGA"
12758 4 0 0 1 . 0 0 "UGA"
11482 4 1 0 0 . 0 0 "UGA"
28068 5 0 0 1 . 0 0 "UGA"
15310 4 1 0 0 . 1 0 "UGA"
 7655 3 0 0 1 . 0 0 "UGA"
 1701 5 1 0 0 . 0 1 "UGA"
 7655 4 0 0 1 . 0 1 "UGA"
20413 1 1 0 0 . 0 0 "UGA"
 5103 4 1 0 0 . 0 0 "UGA"
 2551 4 0 0 1 . 1 0 "UGA"
 2551 4 0 0 0 . 1 0 "UGA"
 1275 5 1 0 0 . 0 0 "UGA"
 7655 5 1 0 0 . 0 1 "UGA"
30620 3 1 0 0 . 0 0 "UGA"
10206 5 0 0 1 . 0 1 "UGA"
10206 5 0 0 0 . 0 1 "UGA"
end
label values hh_nexpcap_quintile hh_nexpcap_quintile
label def hh_nexpcap_quintile 1 "poorest", modify
label def hh_nexpcap_quintile 2 "poorer", modify
label def hh_nexpcap_quintile 3 "middle", modify
label def hh_nexpcap_quintile 4 "richer", modify
label def hh_nexpcap_quintile 5 "richest", modify

Thanks again!

[Nick Cox]

 
  foreach l of local levels {

[Michal Onah]

foreach l of local levels {

Dear Nick

thanks for your response. I am not sure I understand the code you have suggested. Would it be possible for you to explain a bit more?

[Nick Cox]

Yes, it's possible, but it's better that you study the one line I wrote and compare it character by character with what you have in #1 and with the help for foreach.

[Michal Onah]

Yes, it's possible, but it's better that you study the one line I wrote and compare it character by character with what you have in #1 and with the help for foreach.

Dear Nick,

I have updated my dofile to make it cleaner and to correct some errors that I noticed

levelsof ID, local(country)
    . foreach l of local country {
    . graph twoway (scatter oop_drugs oop_IP oop_OP cata_nf_40) if ID == "`l'"
    . }

However, I still get an r(198) error alert "foreach command may not result from a macro expansion interactively or in do files". I dont know if this is because my ID variable is string

[Michal Onah]

Yes, it's possible, but it's better that you study the one line I wrote and compare it character by character with what you have in #1 and with the help for foreach.

Dear Nick,

I have been able to run the code but I am not generating an ideal graph. The graph comes out empty. I want to generate a graph that have figures for each country in the ID variable represented by their isocodes. And I also want to have a similar graph for cata_tot_10 in place of cata_nf_40 all in one graph.

Many thanks for your help

levelsof ID, local(country)
foreach l of local country {
    . graph twoway (scatter oop_drugs oop_IP oop_OP cata_nf_40) if ID == "`l'"
    . }

[Nick Cox]

Different problem now. It's difficult to play here because your data example in #1 is just UGAnda alone.

[Michal Onah]

Different problem now. It's difficult to play here because your data example in #1 is just UGAnda alone.

Dear NIck,

I have increased the number of values in the dataex below but it produced only two categories in the ID variable. Increasing the counts will make it cumbersome but doable

* Example generated by -dataex-. To install: ssc install dataex
clear
input float popweight byte hh_nexpcap_quintile float(cata_tot_10 cata_nf_40) str3 ID float(oop_drugs oop_OP oop_IP)
     8377 5 1 . "UGA" 0 0 1
     8377 5 1 . "UGA" 0 0 0
     8377 3 1 . "UGA" 1 0 0
     9373 5 0 . "UGA" 0 0 1
     3749 5 0 . "UGA" 1 0 0
     1874 5 0 . "UGA" 1 0 0
     7499 4 0 . "UGA" 1 0 0
    11248 5 0 . "UGA" 1 0 0
    11248 5 0 . "UGA" 1 0 0
    11248 4 0 . "UGA" 1 0 0
     7499 5 0 . "UGA" 0 0 1
    11248 5 0 . "UGA" 1 0 0
    16873 5 0 . "UGA" 0 1 0
    16873 5 0 . "UGA" 1 0 0
    16873 5 0 . "UGA" 0 0 1
     1874 5 0 . "UGA" 0 1 0
     1874 5 0 . "UGA" 1 0 0
     1874 5 0 . "UGA" 0 0 1
     9373 5 0 . "UGA" 1 0 0
     2499 4 0 . "UGA" 0 0 1
     3124 5 0 . "UGA" 1 0 0
     7499 5 1 . "UGA" 1 0 0
    11248 4 1 . "UGA" 1 0 0
    11248 4 1 . "UGA" 0 0 1
     1874 5 1 . "UGA" 1 0 0
     5624 5 1 . "UGA" 0 1 0
     5624 5 1 . "UGA" 1 0 0
    11248 5 1 . "UGA" 1 0 0
    11248 5 1 . "UGA" 0 0 1
     9373 4 0 . "UGA" 1 0 0
    11248 5 0 . "UGA" 1 0 0
     4686 4 0 . "UGA" 1 0 0
    13123 5 0 . "UGA" 1 0 0
     9373 5 0 . "UGA" 1 0 0
     9373 5 0 . "UGA" 0 0 1
     7499 5 0 . "UGA" 1 0 0
     7499 5 0 . "UGA" 0 0 1
    20622 4 0 . "UGA" 1 0 0
    11248 4 0 . "UGA" 1 0 0
    11248 5 0 . "UGA" 1 0 0
     3749 5 0 . "UGA" 1 0 0
     7499 5 0 . "UGA" 0 1 0
     7499 5 0 . "UGA" 1 0 0
     7499 5 0 . "UGA" 0 0 1
     7499 5 0 . "UGA" 1 0 0
     1874 5 0 . "UGA" 1 0 0
    20622 5 0 . "UGA" 0 1 0
    20622 5 0 . "UGA" 1 0 0
     2812 5 0 . "UGA" 1 0 0
     7499 5 0 . "UGA" 1 0 0
     2812 5 0 . "UGA" 1 0 0
     5624 5 0 . "UGA" 1 0 0
    13123 4 0 . "UGA" 0 1 0
    13123 4 0 . "UGA" 1 0 0
     3749 5 0 . "UGA" 1 0 0
    13123 5 1 . "UGA" 1 0 0
    13123 5 1 . "UGA" 0 0 1
     5624 5 0 . "UGA" 1 0 0
     9373 4 0 . "UGA" 1 0 0
     9373 5 0 . "UGA" 1 0 0
    10206 4 0 . "UGA" 1 0 0
    25517 2 1 . "UGA" 0 0 1
    10206 5 0 . "UGA" 1 0 0
     7655 3 0 . "UGA" 1 0 0
     4252 4 1 . "UGA" 1 0 0
    10206 3 0 . "UGA" 0 0 1
    17861 4 0 . "UGA" 0 0 1
    15310 4 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 0 0 0
    10206 5 1 . "UGA" 1 0 0
    10206 5 1 . "UGA" 0 0 0
    15310 4 0 . "UGA" 0 0 1
     8930 4 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 1 0 0
    10206 3 1 . "UGA" 1 0 0
     2551 3 1 . "UGA" 1 0 0
     2551 3 0 . "UGA" 0 0 1
    15310 5 0 . "UGA" 1 0 0
    12758 3 0 . "UGA" 0 0 1
    15310 4 0 . "UGA" 1 0 0
    10206 4 0 . "UGA" 1 0 0
    17861 4 0 . "UGA" 1 0 0
    17861 4 0 . "UGA" 0 0 1
    10206 5 0 . "UGA" 1 0 0
    12758 4 0 . "UGA" 0 0 1
    11482 4 0 . "UGA" 1 0 0
    28068 5 0 . "UGA" 0 0 1
    15310 4 1 . "UGA" 1 0 0
     7655 3 0 . "UGA" 0 0 1
     1701 5 0 . "UGA" 1 0 0
     7655 4 0 . "UGA" 0 0 1
    20413 1 0 . "UGA" 1 0 0
     5103 4 0 . "UGA" 1 0 0
     2551 4 1 . "UGA" 0 0 1
     2551 4 1 . "UGA" 0 0 0
     1275 5 0 . "UGA" 1 0 0
     7655 5 0 . "UGA" 1 0 0
    30620 3 0 . "UGA" 1 0 0
    10206 5 0 . "UGA" 0 0 1
    10206 5 0 . "UGA" 0 0 0
    15310 3 0 . "UGA" 1 0 0
    20413 2 0 . "UGA" 1 0 0
    12758 5 0 . "UGA" 0 1 0
    12758 5 0 . "UGA" 1 0 0
    17861 3 1 . "UGA" 1 0 0
    17861 3 1 . "UGA" 0 0 0
     1275 5 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 0 0 1
    10206 2 0 . "UGA" 0 0 1
    30620 3 1 . "UGA" 1 0 0
    30620 3 1 . "UGA" 0 0 1
    30620 3 1 . "UGA" 0 0 0
    10206 2 1 . "UGA" 1 0 0
    10206 2 1 . "UGA" 0 0 1
    16754 3 0 . "UGA" 0 0 1
     2094 5 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 1 0 0
     2094 5 0 . "UGA" 1 0 0
     2094 5 0 . "UGA" 0 0 1
    19547 4 0 . "UGA" 0 0 1
    13962 3 0 . "UGA" 1 0 0
    11169 4 0 . "UGA" 1 0 0
     5584 4 1 . "UGA" 1 0 0
    12566 1 0 . "UGA" 0 0 1
    11169 4 1 . "UGA" 1 0 0
    16754 2 0 . "UGA" 0 0 1
     5584 1 1 . "UGA" 0 0 1
    16754 2 0 . "UGA" 0 0 1
     2792 2 0 . "UGA" 0 0 0
     2792 5 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 1 0 0
     2792 5 1 . "UGA" 0 0 1
     5584 4 1 . "UGA" 1 0 0
    16754 5 0 . "UGA" 1 0 0
     9773 4 0 . "UGA" 0 0 0
    19547 1 1 . "UGA" 1 0 0
    19547 3 0 . "UGA" 1 0 0
    19547 3 0 . "UGA" 0 0 0
    27924 2 0 . "UGA" 1 0 0
    30717 3 0 . "UGA" 0 0 1
    19547 3 0 . "UGA" 0 0 1
    19547 5 0 . "UGA" 0 0 1
    13962 3 0 . "UGA" 0 0 1
     1396 4 1 . "UGA" 0 0 1
     1396 3 1 . "UGA" 0 0 1
     1396 4 1 . "UGA" 0 0 1
     2327 1 0 . "UGA" 0 0 1
     3723 2 1 . "UGA" 0 0 1
     9773 1 1 . "UGA" 1 0 0
     9773 1 1 . "UGA" 0 0 0
    13962 4 0 . "UGA" 1 0 0
    13962 3 0 . "UGA" 1 0 0
    13962 3 0 . "UGA" 0 0 0
    22339 1 1 . "UGA" 0 0 1
    22339 1 1 . "UGA" 0 0 0
    16754 4 0 . "UGA" 0 0 1
    11169 5 0 . "UGA" 1 0 0
    16754 2 0 . "UGA" 1 0 0
    19547 4 0 . "UGA" 0 0 1
    16754 3 0 . "UGA" 0 0 1
    16754 2 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 0 0 1
     5584 3 0 . "UGA" 0 0 0
    19547 5 0 . "UGA" 1 0 0
    19547 5 0 . "UGA" 0 0 0
    11169 1 0 . "UGA" 0 0 1
     2792 5 0 . "UGA" 0 0 1
    19547 3 0 . "UGA" 1 0 0
    16754 4 0 . "UGA" 0 0 1
    19547 2 0 . "UGA" 1 0 0
     2792 4 0 . "UGA" 1 0 0
      930 5 1 . "UGA" 1 0 0
      930 5 1 . "UGA" 0 0 1
     1861 5 1 . "UGA" 1 0 0
     1861 5 1 . "UGA" 0 0 1
     4188 5 0 . "UGA" 0 0 1
    25132 2 1 . "UGA" 1 0 0
    25132 2 1 . "UGA" 0 0 1
    13962 5 0 . "UGA" 1 0 0
    11169 4 0 . "UGA" 1 0 0
    11169 4 0 . "UGA" 0 0 0
     2792 5 0 . "UGA" 0 0 1
     8377 3 0 . "UGA" 1 0 0
     6981 4 0 . "UGA" 0 0 1
     4188 4 0 . "UGA" 0 0 1
    16754 4 0 . "UGA" 1 0 0
     4654 2 0 . "UGA" 1 0 0
     8377 3 0 . "UGA" 0 0 1
     5584 2 0 . "UGA" 1 0 0
    11169 5 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 0 0 0
    16754 4 0 . "UGA" 1 0 0
    16754 4 0 . "UGA" 0 0 1
    33509 1 0 . "UGA" 0 0 1
     8377 4 0 . "UGA" 1 0 0
     8377 2 0 . "UGA" 0 0 1
     7655 5 0 . "UGA" 1 0 0
     7655 5 1 . "UGA" 0 0 1
    20413 5 1 . "UGA" 0 0 1
     7655 5 0 . "UGA" 1 0 0
    12758 5 0 . "UGA" 0 0 1
    15310 5 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 0 0 0
    22965 5 0 . "UGA" 1 0 0
    12758 4 0 . "UGA" 1 0 0
    15310 4 1 . "UGA" 0 0 1
     7655 4 1 . "UGA" 1 0 0
     1701 5 0 . "UGA" 1 0 0
     6379 5 0 . "UGA" 0 0 1
    12758 5 0 . "UGA" 1 0 0
    12758 5 0 . "UGA" 0 0 0
    17861 1 1 . "UGA" 1 0 0
    17861 4 0 . "UGA" 1 0 0
    15310 3 1 . "UGA" 0 0 1
    10206 3 1 . "UGA" 0 1 0
    10206 3 1 . "UGA" 1 0 0
    10206 5 1 . "UGA" 1 0 0
    17861 4 0 . "UGA" 0 1 0
    17861 4 0 . "UGA" 1 0 0
    17861 3 0 . "UGA" 1 0 0
    10206 4 1 . "UGA" 1 0 0
    10206 4 1 . "UGA" 0 0 1
     7655 2 0 . "UGA" 0 0 1
     2551 5 0 . "UGA" 1 0 0
     3402 4 0 . "UGA" 1 0 0
    15310 3 0 . "UGA" 1 0 0
    20413 4 0 . "UGA" 1 0 0
    12758 5 0 . "UGA" 1 0 0
     9356 4 0 . "UGA" 0 0 1
     1701 5 0 . "UGA" 1 0 0
     2551 5 0 . "UGA" 1 0 0
     2551 5 0 . "UGA" 0 1 0
     2551 5 0 . "UGA" 1 0 0
     2551 5 0 . "UGA" 0 0 1
    10206 2 0 . "UGA" 0 0 1
    12758 4 0 . "UGA" 0 0 1
    12758 3 1 . "UGA" 1 0 0
    12758 3 1 . "UGA" 0 0 1
    12758 4 0 . "UGA" 1 0 0
    20413 4 0 . "UGA" 1 0 0
    20413 4 0 . "UGA" 0 0 1
    28068 4 1 . "UGA" 0 1 0
    28068 4 1 . "UGA" 1 0 0
    28068 4 1 . "UGA" 0 0 1
    12758 3 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 0 0 1
    28068 3 0 . "UGA" 1 0 0
     7655 5 1 . "UGA" 0 0 1
    12758 3 0 . "UGA" 1 0 0
    22965 5 0 . "UGA" 0 0 1
    10206 4 0 . "UGA" 0 0 1
     6379 4 0 . "UGA" 0 0 1
     3827 5 0 . "UGA" 0 0 1
    15310 4 0 . "UGA" 1 0 0
    10206 5 0 . "UGA" 1 0 0
    20413 1 0 . "UGA" 1 0 0
    15310 3 0 . "UGA" 1 0 0
    17861 4 0 . "UGA" 1 0 0
    17861 4 0 . "UGA" 0 0 1
     5103 4 1 . "UGA" 0 1 0
     5103 4 1 . "UGA" 1 0 0
     5103 4 1 . "UGA" 0 0 0
     7655 5 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 0 0 1
    17861 5 0 . "UGA" 1 0 0
     3827 5 0 . "UGA" 0 0 0
     7655 5 0 . "UGA" 1 0 0
     3827 5 0 . "UGA" 0 0 1
    15310 3 0 . "UGA" 1 0 0
    10206 4 0 . "UGA" 1 0 0
    15310 4 0 . "UGA" 1 0 0
    11482 4 0 . "UGA" 1 0 0
    20413 2 0 . "UGA" 1 0 0
    10206 3 0 . "UGA" 1 0 0
     7655 3 0 . "UGA" 0 0 1
     3827 3 0 . "UGA" 1 0 0
    15310 3 0 . "UGA" 1 0 0
    15310 1 0 . "UGA" 1 0 0
    15310 1 0 . "UGA" 0 0 1
     5103 4 0 . "UGA" 1 0 0
     6379 2 1 . "UGA" 0 0 1
     8930 2 0 . "UGA" 0 0 1
    20413 4 0 . "UGA" 1 0 0
    10206 3 1 . "UGA" 0 0 1
    22965 1 1 . "UGA" 1 0 0
    22965 1 1 . "UGA" 0 0 1
     3827 3 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 1 0 0
     2551 5 1 . "UGA" 1 0 0
    15310 3 0 . "UGA" 0 0 1
    10206 5 0 . "UGA" 0 0 1
    61240 1 0 . "UGA" 0 0 1
     5103 2 0 . "UGA" 0 0 1
     5103 4 0 . "UGA" 1 0 0
     7655 5 1 . "UGA" 0 0 1
     3402 5 0 . "UGA" 0 0 1
     3402 5 0 . "UGA" 0 0 1
     2551 5 0 . "UGA" 0 0 1
    20413 3 0 . "UGA" 0 1 0
    20413 3 0 . "UGA" 1 0 0
    20413 3 0 . "UGA" 0 0 1
     7655 5 0 . "UGA" 1 0 0
     4252 3 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 0 0 1
    20413 4 0 . "UGA" 1 0 0
    12758 5 0 . "UGA" 0 0 1
    15310 3 0 . "UGA" 1 0 0
     2551 5 0 . "UGA" 0 0 1
     2551 4 0 . "UGA" 0 0 1
    22965 4 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 1 0 0
      930 5 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 1 0 0
      930 5 0 . "UGA" 1 0 0
      465 5 1 . "UGA" 1 0 0
      465 5 1 . "UGA" 0 0 1
    13962 4 0 . "UGA" 1 0 0
    16754 3 1 . "UGA" 0 0 1
     2792 5 0 . "UGA" 0 0 0
    16754 4 0 . "UGA" 1 0 0
     4188 5 0 . "UGA" 1 0 0
     7679 4 0 . "UGA" 1 0 0
     5584 2 0 . "UGA" 1 0 0
    41887 5 0 . "UGA" 1 0 0
     2792 4 0 . "UGA" 1 0 0
    11169 5 0 . "UGA" 0 0 1
     8377 3 0 . "UGA" 1 0 0
     6981 2 1 . "UGA" 0 0 1
     5584 3 1 . "UGA" 0 0 1
     8377 5 0 . "UGA" 1 0 0
    16754 4 0 . "UGA" 1 0 0
    16754 3 0 . "UGA" 1 0 0
     2792 4 0 . "UGA" 1 0 0
     2792 4 0 . "UGA" 1 0 0
     1396 5 0 . "UGA" 0 0 1
     4188 4 0 . "UGA" 1 0 0
    16754 2 1 . "UGA" 0 0 1
     6981 3 0 . "UGA" 0 0 0
    11169 3 0 . "UGA" 1 0 0
    27924 3 0 . "UGA" 1 0 0
    27924 3 0 . "UGA" 0 0 1
    13962 1 1 . "UGA" 1 0 0
    11169 2 1 . "UGA" 0 0 1
    27924 1 0 . "UGA" 0 0 1
      930 5 0 . "UGA" 1 0 0
     4654 4 0 . "UGA" 0 0 1
     2792 4 0 . "UGA" 1 0 0
     2792 4 0 . "UGA" 0 0 1
    16754 1 0 . "UGA" 1 0 0
    16754 4 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 1 0 0
     5584 5 1 . "UGA" 0 1 0
     5584 5 1 . "UGA" 1 0 0
    11169 4 0 . "UGA" 0 0 1
     4188 4 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 0 0 1
     4654 2 0 . "UGA" 1 0 0
     3723 3 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 1 0 0
     5584 5 1 . "UGA" 1 0 0
     5584 5 1 . "UGA" 0 0 1
     5584 5 1 . "UGA" 0 0 0
    19547 4 1 . "UGA" 1 0 0
    27924 4 1 . "UGA" 1 0 0
    27924 4 1 . "UGA" 0 0 1
    13962 4 1 . "UGA" 0 0 1
    25132 5 1 . "UGA" 0 0 1
    25132 5 1 . "UGA" 0 0 0
    22339 4 1 . "UGA" 1 0 0
    22339 4 1 . "UGA" 0 0 1
     6981 5 0 . "UGA" 0 0 1
     6981 5 0 . "UGA" 0 0 0
    12566 3 1 . "UGA" 1 0 0
    22339 5 0 . "UGA" 0 0 1
    11169 5 0 . "UGA" 1 0 0
    11169 3 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 1 0 0
     6981 4 1 . "UGA" 1 0 0
    19547 1 0 . "UGA" 0 0 1
     2792 5 1 . "UGA" 1 0 0
     2792 5 1 . "UGA" 0 0 0
    19547 3 1 . "UGA" 0 0 1
    25132 2 0 . "UGA" 1 0 0
     5584 4 0 . "UGA" 0 0 0
    19547 4 0 . "UGA" 0 0 1
     6379 4 0 . "UGA" 1 0 0
     3827 4 1 . "UGA" 1 0 0
    15310 4 0 . "UGA" 1 0 0
     3827 4 0 . "UGA" 1 0 0
    25517 4 0 . "UGA" 0 0 1
     5103 4 0 . "UGA" 0 0 1
     2551 5 0 . "UGA" 0 0 1
    17861 5 0 . "UGA" 1 0 0
    22965 2 0 . "UGA" 1 0 0
    20413 3 0 . "UGA" 0 0 1
     5103 3 0 . "UGA" 1 0 0
     1275 5 0 . "UGA" 1 0 0
     3827 4 0 . "UGA" 0 0 1
    22965 4 0 . "UGA" 1 0 0
    15310 1 0 . "UGA" 0 0 1
    20413 5 0 . "UGA" 1 0 0
    25517 2 0 . "UGA" 1 0 0
    10206 5 0 . "UGA" 1 0 0
    10206 3 0 . "UGA" 1 0 0
     2551 5 1 . "UGA" 1 0 0
     2551 5 1 . "UGA" 0 0 0
     5584 5 0 . "UGA" 1 0 0
    16754 5 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 0 0 1
    19547 3 0 . "UGA" 1 0 0
    19547 3 0 . "UGA" 0 0 0
    16754 4 0 . "UGA" 0 0 1
    13962 4 0 . "UGA" 1 0 0
     5584 5 0 . "UGA" 0 0 1
     2792 5 0 . "UGA" 1 0 0
    16754 5 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 0 0 1
    16754 3 0 . "UGA" 0 0 1
     2792 5 1 . "UGA" 1 0 0
     8377 5 0 . "UGA" 0 0 1
    22339 2 0 . "UGA" 0 0 1
    11169 3 1 . "UGA" 0 0 1
    13962 5 0 . "UGA" 1 0 0
    30717 5 0 . "UGA" 0 0 1
     9773 5 0 . "UGA" 0 0 1
     2792 5 0 . "UGA" 0 0 1
     5584 5 1 . "UGA" 0 1 0
     5584 5 1 . "UGA" 1 0 0
     5584 5 1 . "UGA" 0 0 1
     1396 5 0 . "UGA" 1 0 0
    30717 5 0 . "UGA" 0 1 0
    30717 5 0 . "UGA" 1 0 0
    30717 5 0 . "UGA" 0 0 0
     4188 5 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 0 0 1
    13962 5 0 . "UGA" 0 1 0
    13962 5 0 . "UGA" 1 0 0
     2792 5 0 . "UGA" 1 0 0
    22339 5 0 . "UGA" 1 0 0
     8377 3 0 . "UGA" 0 1 0
     8377 3 0 . "UGA" 1 0 0
     8377 5 0 . "UGA" 1 0 0
    11169 5 0 . "UGA" 0 0 1
     6060 1 1 . "UGA" 1 0 0
     6060 1 1 . "UGA" 0 0 1
     2272 1 0 . "UGA" 1 0 0
    22726 1 0 . "UGA" 1 0 0
    12499 3 0 . "UGA" 1 0 0
     7954 2 0 . "UGA" 1 0 0
    18181 3 0 . "UGA" 1 0 0
     4545 3 0 . "UGA" 0 0 0
     1363 5 1 . "UGA" 0 1 0
     1363 5 1 . "UGA" 1 0 0
     1363 3 1 . "UGA" 0 1 0
     1363 3 1 . "UGA" 1 0 0
     2272 1 0 . "UGA" 1 0 0
    13635 1 0 . "UGA" 1 0 0
    24999 3 0 . "UGA" 0 1 0
    24999 3 0 . "UGA" 1 0 0
     8333 1 0 . "UGA" 1 0 0
     2272 3 1 . "UGA" 1 0 0
    15908 3 0 . "UGA" 1 0 0
    18181 2 0 . "UGA" 0 1 0
    10226 1 0 . "UGA" 1 0 0
     9090 2 0 . "UGA" 1 0 0
    13635 1 0 . "UGA" 1 0 0
    20453 1 0 . "UGA" 1 0 0
     7386 1 0 . "UGA" 1 0 0
     7386 1 0 . "UGA" 0 0 1
     6249 2 0 . "UGA" 1 0 0
    18181 1 0 . "UGA" 0 0 1
    29544 1 0 . "UGA" 1 0 0
     6817 1 0 . "UGA" 1 0 0
    11363 1 0 . "UGA" 1 0 0
    11363 3 1 . "UGA" 0 1 0
    11363 3 1 . "UGA" 1 0 0
    15908 4 0 . "UGA" 1 0 0
     4545 4 0 . "UGA" 1 0 0
    20453 5 0 . "UGA" 0 1 0
    20453 5 0 . "UGA" 1 0 0
     2272 5 0 . "UGA" 1 0 0
     4545 4 1 . "UGA" 0 1 0
     4545 4 1 . "UGA" 1 0 0
     4545 4 1 . "UGA" 0 0 1
    22726 1 0 . "UGA" 1 0 0
     3787 5 0 . "UGA" 1 0 0
    13635 4 0 . "UGA" 1 0 0
    11363 5 0 . "UGA" 0 1 0
    11363 5 0 . "UGA" 1 0 0
     9090 5 0 . "UGA" 0 1 0
     9090 5 0 . "UGA" 1 0 0
    24999 2 0 . "UGA" 1 0 0
    11363 2 0 . "UGA" 0 1 0
    11363 2 0 . "UGA" 1 0 0
    18181 2 0 . "UGA" 1 0 0
    15908 2 0 . "UGA" 1 0 0
    15908 2 0 . "UGA" 0 0 1
     7954 4 1 . "UGA" 0 1 0
     7954 4 1 . "UGA" 1 0 0
    13635 2 0 . "UGA" 1 0 0
    15908 3 0 . "UGA" 1 0 0
    10226 3 0 . "UGA" 1 0 0
     2272 5 1 . "UGA" 1 0 0
    13635 4 1 . "UGA" 0 1 0
    13635 4 1 . "UGA" 1 0 0
    15908 4 0 . "UGA" 1 0 0
    20453 2 0 . "UGA" 1 0 0
     9090 3 1 . "UGA" 1 0 0
    12499 2 0 . "UGA" 1 0 0
     7954 2 0 . "UGA" 1 0 0
     2272 5 0 . "UGA" 1 0 0
     7954 2 0 . "UGA" 1 0 0
     6817 2 0 . "UGA" 0 0 1
    18181 2 0 . "UGA" 0 0 0
    22726 2 0 . "UGA" 0 0 1
    36362 3 0 . "UGA" 1 0 0
    11363 2 0 . "UGA" 1 0 0
    11363 2 0 . "UGA" 0 0 0
    29544 4 0 . "UGA" 0 1 0
    29544 4 0 . "UGA" 1 0 0
     1136 5 1 . "UGA" 0 0 1
     7954 3 0 . "UGA" 0 0 1
      944.879 3 1 1 "SLE" 1 1 1
1511.8064 1 1 1 "SLE" 1 1 1
  944.879 1 1 1 "SLE" 1 1 1
1322.8306 2 1 0 "SLE" 0 0 1
1133.8547 2 1 1 "SLE" 1 1 1
1133.8547 1 1 0 "SLE" 0 0 1
 774.3396 4 0 1 "SLE" 0 0 1
 1742.264 2 0 0 "SLE" 1 1 0
 967.9245 4 0 0 "SLE" 0 1 0
1161.5094 2 1 0 "SLE" 1 1 1
1161.5094 4 0 0 "SLE" 0 0 1
1355.0942 4 0 0 "SLE" 1 0 1
 1935.849 2 0 0 "SLE" 1 0 1
1355.0942 4 0 0 "SLE" 1 1 1
 580.7547 4 1 1 "SLE" 1 1 1
1355.0942 4 0 0 "SLE" 1 0 1
2024.7405 4 1 1 "SLE" 1 0 1
 2834.637 3 1 1 "SLE" 1 1 1
1619.7924 5 1 1 "SLE" 1 1 1
 3644.533 1 1 1 "SLE" 1 0 1
2429.6885 4 1 0 "SLE" 1 1 1
1619.7924 3 1 1 "SLE" 1 1 1
 2834.637 4 0 0 "SLE" 0 0 1
 3239.585 3 1 1 "SLE" 1 0 1
 2834.637 4 0 0 "SLE" 1 0 1
 2834.637 3 1 1 "SLE" 0 0 1
 663.7198 4 0 0 "SLE" 0 0 1
 497.7899 4 0 0 "SLE" 1 1 1
 663.7198 2 0 0 "SLE" 0 0 1
 497.7899 2 1 . "SLE" 0 0 1
 829.6497 1 1 . "SLE" 1 1 1
 663.7198 2 1 0 "SLE" 1 1 1
 580.7548 3 1 1 "SLE" 1 1 1
 580.7548 3 0 0 "SLE" 1 1 1
 580.7548 3 1 0 "SLE" 1 1 1
 414.8249 3 0 0 "SLE" 1 0 1
 644.6511 4 1 1 "SLE" 1 1 1
1074.4185 2 1 1 "SLE" 1 1 1
1074.4185 2 1 1 "SLE" 0 0 1
1933.9532 1 1 1 "SLE" 1 0 1
 1504.186 2 1 1 "SLE" 1 0 1
 644.6511 4 0 0 "SLE" 1 1 0
 1504.186 2 1 1 "SLE" 1 1 1
 859.5348 3 0 0 "SLE" 0 0 1
1289.3022 2 0 0 "SLE" 0 0 1
 1504.186 2 1 1 "SLE" 1 1 1
   686.28 2 1 1 "SLE" 1 1 1
   800.66 1 1 . "SLE" 1 1 1
   915.04 2 1 1 "SLE" 1 0 1
1143.7999 1 1 . "SLE" 1 1 1
571.89996 1 . . "SLE" 1 1 1
1029.4199 2 1 1 "SLE" 1 0 1
   457.52 3 1 . "SLE" 1 0 1
   457.52 3 1 . "SLE" 1 1 1
1143.7999 1 1 . "SLE" 1 1 1
1029.4199 1 1 . "SLE" 1 1 1
 644.3685 4 1 1 "SLE" 1 0 1
1073.9475 1 1 . "SLE" 1 0 1
1073.9475 2 1 1 "SLE" 1 0 0
1503.5265 3 1 1 "SLE" 1 0 0
 1288.737 3 1 1 "SLE" 1 1 1
  859.158 3 0 0 "SLE" . . .
  859.158 5 0 0 "SLE" 0 1 0
 1288.737 1 1 1 "SLE" 1 0 1
 1288.737 1 1 1 "SLE" 1 0 1
1073.9475 3 0 0 "SLE" . . .
1296.4546 4 0 0 "SLE" 1 0 1
1481.6624 3 0 0 "SLE" . . .
1111.2468 4 0 1 "SLE" 1 0 1
 926.0389 4 0 1 "SLE" 1 0 1
 555.6234 5 0 1 "SLE" 1 0 0
1111.2468 4 0 1 "SLE" 1 0 1
 555.6234 5 0 0 "SLE" 1 0 1
1111.2468 4 0 1 "SLE" 1 0 1
1111.2468 4 0 0 "SLE" 1 0 0
1296.4546 4 0 1 "SLE" 1 0 1
  380.438 2 1 . "SLE" 0 0 1
 228.2628 3 1 . "SLE" 0 0 1
304.35037 3 1 . "SLE" 0 0 1
152.17519 2 1 . "SLE" 0 0 1
  380.438 3 1 . "SLE" 0 0 1
304.35037 3 1 . "SLE" 0 0 1
  380.438 1 1 . "SLE" 0 0 1
 228.2628 1 1 . "SLE" 0 0 1
 456.5256 2 1 . "SLE" 1 0 1
 228.2628 3 1 . "SLE" 0 0 1
 2619.974 5 0 0 "SLE" 1 0 0
 982.4904 4 0 0 "SLE" 0 0 1
 1637.484 5 0 1 "SLE" 1 0 1
 1637.484 3 0 0 "SLE" 1 0 1
 1309.987 4 0 0 "SLE" 0 0 1
 982.4904 4 0 0 "SLE" 1 0 1
 2619.974 3 1 . "SLE" 1 0 1
1964.9807 3 0 0 "SLE" 0 0 1
 982.4904 4 0 1 "SLE" 1 0 1
2292.4775 2 1 . "SLE" 1 0 1
1998.8567 2 1 1 "SLE" 1 1 1
 666.2856 3 1 1 "SLE" 0 0 1
 1332.571 2 1 1 "SLE" 1 1 1
 1665.714 3 1 1 "SLE" 1 1 1
2331.9995 1 1 1 "SLE" 0 1 1
 1665.714 3 1 1 "SLE" 1 1 1
1998.8567 1 . . "SLE" 1 1 1
 1665.714 1 1 . "SLE" 1 1 1
1998.8567 1 1 1 "SLE" 1 1 1
1998.8567 2 1 1 "SLE" 1 1 1
  74.5957 1 0 0 "SLE" . . .
104.43398 3 1 1 "SLE" 1 1 1
  74.5957 3 0 0 "SLE" . . .
 59.67656 3 0 0 "SLE" . . .
104.43398 4 0 0 "SLE" 1 1 1
 59.67656 4 1 1 "SLE" 1 1 1
 89.51484 2 0 0 "SLE" . . .
  74.5957 3 1 0 "SLE" 1 0 1
 89.51484 3 0 0 "SLE" 0 0 1
 59.67656 4 0 0 "SLE" 1 1 1
 444.4132 5 0 0 "SLE" 0 0 1
 666.6198 4 0 0 "SLE" 0 0 1
1999.8594 1 1 1 "SLE" 1 0 1
 1111.033 2 0 1 "SLE" 0 0 1
 666.6198 3 1 . "SLE" 1 1 1
 1777.653 1 1 . "SLE" 1 1 1
 666.6198 2 1 . "SLE" 1 0 1
1555.4463 1 1 . "SLE" 1 0 1
1555.4463 1 1 1 "SLE" 1 0 1
 888.8264 1 1 1 "SLE" 1 0 1
 747.3132 1 1 . "SLE" 0 0 1
 747.3132 4 0 0 "SLE" . . .
  622.761 4 1 1 "SLE" 0 0 1
 747.3132 2 1 . "SLE" 1 0 1
 373.6566 4 1 . "SLE" 1 0 1
 747.3132 4 1 . "SLE" 1 0 1
 498.2088 4 1 1 "SLE" 0 0 1
 747.3132 3 1 1 "SLE" 0 0 1
 498.2088 4 1 . "SLE" 0 0 1
 373.6566 4 0 1 "SLE" 0 0 1
 913.7975 3 1 . "SLE" 1 1 1
 913.7975 3 1 1 "SLE" 1 0 1
 1305.425 1 1 1 "SLE" 0 0 1
  1044.34 2 0 0 "SLE" 0 0 1
 913.7975 2 1 . "SLE" 1 1 1
 913.7975 1 1 . "SLE" 0 0 1
   522.17 5 0 1 "SLE" 1 1 1
 652.7125 4 0 0 "SLE" 0 0 1
  1044.34 2 1 1 "SLE" 1 0 1
 652.7125 4 1 . "SLE" 0 0 1
 840.0204 1 1 . "SLE" 1 0 1
 980.0238 3 0 0 "SLE" 1 1 1
  700.017 3 0 1 "SLE" 1 1 1
1120.0272 3 0 0 "SLE" 1 0 1
 840.0204 2 0 0 "SLE" 0 1 1
 840.0204 1 1 . "SLE" 1 0 1
 280.0068 4 1 1 "SLE" 1 0 1
  700.017 2 0 0 "SLE" 1 0 1
 840.0204 1 1 . "SLE" 1 1 1
  700.017 2 1 . "SLE" 1 1 1
 701.6114 1 1 . "SLE" 1 1 1
 400.9208 1 . . "SLE" 1 0 1
 400.9208 2 1 . "SLE" 1 1 1
 601.3812 1 0 0 "SLE" 1 0 1
 300.6906 3 1 1 "SLE" 1 1 1
 801.8416 2 1 . "SLE" 1 1 1
 1002.302 3 0 0 "SLE" 1 1 1
 400.9208 5 1 1 "SLE" 1 0 1
  501.151 5 0 0 "SLE" 1 0 1
 601.3812 2 1 . "SLE" 1 1 1
1217.2935 3 1 1 "SLE" 1 0 1
1217.2935 4 1 1 "SLE" 1 0 1
 973.8348 4 0 1 "SLE" 0 0 1
1217.2935 1 1 . "SLE" 0 0 1
 973.8348 4 0 0 "SLE" 0 0 1
2191.1282 2 0 0 "SLE" 0 0 1
1704.2108 2 1 0 "SLE" 1 0 1
1460.7522 1 1 1 "SLE" 1 0 1
1460.7522 2 1 1 "SLE" 0 0 1
1217.2935 1 1 1 "SLE" 1 0 1
 362.2035 2 1 1 "SLE" 1 0 1
181.10175 2 1 . "SLE" 1 1 1
  241.469 3 1 1 "SLE" 1 0 1
181.10175 4 0 0 "SLE" 1 0 1
 422.5707 1 0 0 "SLE" 1 1 1
181.10175 3 1 1 "SLE" 1 0 1
  482.938 1 0 0 "SLE" . . .
 362.2035 2 0 0 "SLE" 0 1 0
  241.469 2 1 1 "SLE" 1 0 1
301.83624 3 0 0 "SLE" 1 0 1
 477.8384 2 1 1 "SLE" 1 0 1
 716.7576 2 1 1 "SLE" 1 0 1
 358.3788 3 0 1 "SLE" 0 0 1
 716.7576 1 1 . "SLE" 1 1 1
597.29803 2 1 . "SLE" 1 1 1
 836.2172 3 1 0 "SLE" 1 1 1
 358.3788 3 1 1 "SLE" 1 0 1
 955.6768 1 1 1 "SLE" 1 1 1
 716.7576 2 1 . "SLE" 1 1 1
597.29803 1 1 1 "SLE" 1 0 1
1320.0096 1 1 1 "SLE" 1 0 1
 1100.008 4 1 . "SLE" 1 0 1
1320.0096 1 1 . "SLE" 1 0 1
 440.0032 4 1 1 "SLE" 1 1 1
 880.0064 2 1 1 "SLE" 1 0 1
 880.0064 3 0 0 "SLE" 0 0 1
1540.0112 1 1 . "SLE" 1 0 1
1320.0096 2 1 1 "SLE" 1 0 1
end
label values hh_nexpcap_quintile hh_nexpcap_quintile
label def hh_nexpcap_quintile 1 "poorest", modify
label def hh_nexpcap_quintile 2 "poorer", modify
label def hh_nexpcap_quintile 3 "middle", modify
label def hh_nexpcap_quintile 4 "richer", modify
label def hh_nexpcap_quintile 5 "richest", modify

.

[Michal Onah]

Different problem now. It's difficult to play here because your data example in #1 is just UGAnda alone.

Dear Nick,
I have over 400000 cases in my dataset so using the count command in dataex produces only values for one category in the ID variable. The smallest country in the ID variable has 2300 cases. I have produced a different dataet below using the code

dataex popweight hh_nexpcap_quintile cata_tot_10 cata_nf_40 ID oop_drugs oop_OP oop_IP if ID=="KEN"

For instance, a cross-tab between ID and oop_drugs will produce the table below

 

oop_drugs


ID
0
1
Total

BGD
25,906
20,169
46,075

CMR
9,045
1,872
10,917

ETH
23,215
178
23,393

GIN
6,955
546
7,501

GTM
1,634
2,523
4,157

KEN
4,661
8,497
13,158

SEN
15,191
31,884
47,075

SLE
1,393
4,549
5,942

UGA
679
1,503
2,182

Total
88,679
71,721
160,400

I dont know if this will help.

* Example generated by -dataex-. To install: ssc install dataex
clear
input float popweight byte hh_nexpcap_quintile float(cata_tot_10 cata_nf_40) str3 ID float(oop_drugs oop_OP oop_IP)
 2386.4 2 0 0 "KEN" 1 0 0
 2576.4 5 0 0 "KEN" 1 0 0
  328.6 5 0 0 "KEN" 1 0 0
 4305.6 4 0 0 "KEN" 1 0 0
 4797.1 1 0 0 "KEN" 1 0 0
  760.9 3 0 0 "KEN" 1 0 0
 5922.8 4 0 0 "KEN" 1 0 0
  511.8 4 0 0 "KEN" 1 0 0
  498.4 4 0 0 "KEN" 1 0 0
   1718 2 0 0 "KEN" 1 0 0
   2009 3 0 0 "KEN" 1 0 0
   4449 3 0 0 "KEN" 1 0 0
    891 4 0 0 "KEN" 1 0 0
 2722.5 2 0 0 "KEN" 1 0 0
 1354.9 5 0 0 "KEN" 1 0 0
   1338 3 0 0 "KEN" 1 0 0
   5972 2 0 0 "KEN" 1 0 0
   5187 3 0 0 "KEN" 1 0 0
  186.9 1 0 0 "KEN" 1 0 0
 6757.5 5 0 0 "KEN" 1 0 0
 2046.4 5 0 0 "KEN" 1 0 0
 1127.7 1 0 0 "KEN" 1 0 0
    422 1 0 0 "KEN" 1 0 0
 3824.4 2 0 0 "KEN" 1 0 0
    528 4 0 0 "KEN" 1 0 0
 1526.4 2 0 0 "KEN" 1 0 0
   2847 4 0 0 "KEN" 1 0 0
 1443.6 2 0 0 "KEN" 1 0 0
   2210 1 0 0 "KEN" 1 0 0
   3093 2 0 0 "KEN" 1 0 0
  274.2 3 0 0 "KEN" 1 0 0
 7100.1 2 0 0 "KEN" 1 0 0
  916.5 4 0 0 "KEN" 1 0 0
 4673.6 3 0 0 "KEN" 1 0 0
  806.6 5 0 0 "KEN" 1 0 0
  481.8 4 0 0 "KEN" 1 0 0
 1053.6 5 0 0 "KEN" 1 0 0
 2584.8 2 0 0 "KEN" 1 0 0
 5193.6 1 0 0 "KEN" 1 0 0
 1014.8 3 0 0 "KEN" 1 0 0
 2295.2 5 0 0 "KEN" 1 0 0
  171.4 5 0 0 "KEN" 1 0 0
  620.2 5 0 0 "KEN" 1 0 0
   4144 2 0 0 "KEN" 1 0 0
   1119 5 0 0 "KEN" 1 0 0
   1823 1 0 0 "KEN" 1 0 0
 7192.8 1 0 0 "KEN" 1 0 0
 7490.4 3 0 0 "KEN" 1 0 0
   73.1 5 0 0 "KEN" 1 0 0
 9734.4 1 0 0 "KEN" 1 0 0
   4653 1 0 0 "KEN" 1 0 0
 2195.5 2 0 0 "KEN" 1 0 0
 3352.2 2 0 0 "KEN" 1 0 0
14742.7 1 0 0 "KEN" 1 0 0
 6252.6 4 0 0 "KEN" 1 0 0
 6784.2 2 0 0 "KEN" 1 0 0
 4978.2 5 0 0 "KEN" 1 0 0
 3264.5 3 0 0 "KEN" 1 0 0
 6816.8 2 0 0 "KEN" 1 0 0
 6816.8 2 0 0 "KEN" 1 0 0
  743.6 5 0 0 "KEN" 1 0 0
  953.6 3 0 0 "KEN" 1 0 0
 1183.8 1 0 0 "KEN" 1 0 0
 7169.4 5 0 0 "KEN" 1 0 0
 5390.7 3 0 0 "KEN" 1 0 0
   5121 2 0 0 "KEN" 1 0 0
   73.1 4 0 0 "KEN" 1 0 0
    623 3 0 0 "KEN" 1 0 0
     45 5 0 0 "KEN" 1 0 0
    522 4 0 0 "KEN" 1 0 0
  994.8 3 0 0 "KEN" 1 0 0
 6248.9 4 0 0 "KEN" 1 0 0
   4899 2 0 0 "KEN" 1 0 0
 2706.8 2 0 0 "KEN" 1 0 0
 6051.5 3 0 0 "KEN" 1 0 0
   9970 2 0 0 "KEN" 1 0 0
 3244.8 1 0 0 "KEN" 1 0 0
 6617.1 5 0 0 "KEN" 1 0 0
 3855.2 4 0 0 "KEN" 1 0 0
 2152.8 5 0 0 "KEN" 1 0 0
 1529.5 1 0 0 "KEN" 1 0 0
 2716.8 5 0 0 "KEN" 1 0 0
 1089.2 2 0 0 "KEN" 1 0 0
 1149.3 5 0 0 "KEN" 1 0 0
    483 2 0 0 "KEN" 1 0 0
 3847.8 2 0 0 "KEN" 1 0 0
 3214.2 2 0 0 "KEN" 1 0 0
 3454.4 4 0 0 "KEN" 1 0 0
 1517.4 5 0 0 "KEN" 1 0 0
 1234.2 2 0 0 "KEN" 1 0 0
   94.1 4 0 0 "KEN" 1 0 0
  177.5 5 0 0 "KEN" 1 0 0
 5493.6 3 0 0 "KEN" 1 0 0
 3475.5 4 0 0 "KEN" 1 0 0
    525 5 0 0 "KEN" 1 0 0
 3744.9 3 0 0 "KEN" 1 0 0
 2255.5 1 0 0 "KEN" 1 0 0
 4545.5 2 0 0 "KEN" 1 0 0
 2361.6 5 0 0 "KEN" 1 0 0
   1734 4 0 0 "KEN" 1 0 0
end
label values hh_nexpcap_quintile hh_nexpcap_quintile
label def hh_nexpcap_quintile 1 "poorest", modify
label def hh_nexpcap_quintile 2 "poorer", modify
label def hh_nexpcap_quintile 3 "middle", modify
label def hh_nexpcap_quintile 4 "richer", modify
label def hh_nexpcap_quintile 5 "richest", modify

[Michal Onah]

Nick Cox Clyde Schechter Sincere apologies for tagging you in my post. I am desperate with a looming deadline and would greatly appreciate any response

Many thanks!!

[Nick Cox]

We have advice on bumping, including claims of urgency, visible at https://www.statalist.org/forums/help#adviceextras #1, The short summary is Please don't. Really, please don't.

I haven't been looking at this thread very carefully if only because there's never been a data example that corresponded to your syntax. Threads compete with each other and what looks (a) interesting to me (b) soluble by me always goes to the top of my list, as should surprise no-one.

But the deepest problem is, I guess, one you've worked out by now. If you're plotting binary values for each observation, there is no obvious way that national summaries will emerge.

NOTE: The thread https://www.statalist.org/forums/for...s-in-dot-chart looks like a fresh start on your problem.

Copy Clyde Schechter