Hey everyone,

Firstly happy Christmas to those who celebrate it and happy holidays too!

Back to the topic, I am trying to replicate tables of summary statistics similar to the pictures attached below. I have been using 'asdoc' mostly but in this case I don't think it applies. In the second picture, the country stats haven't been shown since I'm focusing on a single country, so instead, I'll add ethnicity and province dummies.

Any help will be appreciated, thanks!

Here's an example of the data:


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(lit high_educ rural) byte(windex province) float vehicle byte(toilet water)
0 0 0 4 1 1 1 1
0 0 0 5 1 1 0 1
0 0 0 3 1 1 1 1
0 0 0 3 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 0 0 3 1 1 1 1
1 1 0 3 1 1 1 1
1 1 0 5 1 1 1 1
0 0 0 3 1 1 0 1
1 1 0 4 1 1 1 1
1 0 0 5 1 1 1 1
1 0 0 5 1 1 1 1
1 1 0 5 1 1 1 1
0 0 0 3 1 1 1 1
0 0 0 4 1 1 1 1
0 0 0 3 1 1 1 1
1 0 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
0 0 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 0
1 1 0 5 1 1 1 0
0 0 1 3 1 1 1 1
0 0 1 2 1 0 1 1
0 0 1 3 1 1 1 1
0 0 1 2 1 1 1 1
1 0 1 3 1 0 0 1
1 1 1 3 1 0 1 1
0 0 1 2 1 1 1 1
1 0 1 4 1 1 1 1
0 0 1 2 1 1 1 1
0 0 1 2 1 1 1 1
0 0 1 3 1 1 1 1
1 0 1 3 1 1 1 1
1 0 1 3 1 1 1 1
0 0 1 2 1 1 0 1
0 0 1 1 1 0 0 1
0 0 1 2 1 1 1 1
0 0 1 2 1 1 1 1
1 0 1 2 1 1 1 1
1 0 1 2 1 1 1 1
0 0 1 3 1 0 1 1
1 0 1 3 1 0 1 1
0 0 1 4 1 1 1 1
0 0 1 2 1 0 0 1
0 0 1 5 1 1 1 1
1 0 1 5 1 1 1 1
1 0 1 5 1 1 1 1
0 0 1 2 1 1 1 1
0 0 1 5 1 1 1 1
0 0 1 5 1 1 1 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 0 0 1
0 0 1 2 1 0 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 4 1 1 1 1
0 0 1 4 1 1 1 1
0 0 1 4 1 1 1 1
0 0 1 2 1 1 1 1
1 0 1 2 1 0 0 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 0 1
0 0 1 2 1 1 1 1
0 0 1 1 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 1 0 1
0 0 1 2 1 0 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 0 0 1
0 0 1 1 1 1 0 1
0 0 1 1 1 0 0 1
0 0 1 2 1 1 0 1
0 0 1 1 1 0 0 1
0 0 1 2 1 1 1 1
0 0 1 1 1 0 0 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
1 1 0 5 1 1 1 1
end
label values windex HV270
label def HV270 1 "Poorest", modify
label def HV270 2 "Poorer", modify
label def HV270 3 "Middle", modify
label def HV270 4 "Richer", modify
label def HV270 5 "Richest", modify
label values province HV024
label def HV024 1 "Punjab", modify
label values toilet HV205
label values water HV201

Array

Array