help ceqrace Rodrigo Aranda

Title

ceqrace -- Produces results tables for Ethno Racial Master Workbook under Commitment to Equity (CEQ) framework

Syntax

ceqrace using(filename) [weight] [if] [in] [,table(name) options]

Tables
f3 Ethno-Racial Populations

f5 Population Composition

f6 Income Distribution

f7 Summary Poverty Rates

f8 Summary Poverty Gap Rates

f9 Summary Poverty Gap Squared Rates

f10 Summary Inequality Indicators

f11 Mean Incomes

f12 Incidence by Decile

f13 Incidence by Socioeconomic Group

f16 Fiscal Profile

f17 Coverage Rates (Totals)

f18 Coverage Rates (Targets)

f20 Mobility Matrices

f21 Education (populations)

f23 Educational Probability

f24 Infrastructure Access

f25 Theil Disaggregation

f26 Inequality of Opportunity

f27 Significance

open Automatically open CEQ Ethno Racial Master Workbook with new results added

Ethno-Racial groups

race1(varname) Indigenous Population

race2(varname) White/Non-Ethnic Population

race3(varname) African Descendant Population

race4(varname) Other Races/Ethnicities

race5(varname) Non-Responses

Income Concepts
original(varname) Original income

market(varname) Market income

mpluspensions(varname) Market income plus pensions

netmarket(varname) Net market income

gross(varname) Gross income

taxable(varname) Taxable income

disposable(varname) Disposable income

consumable(varname) Consumable income

final(varname) Final income

Tax and Transfer Concepts
dtax(varname) Direct Taxes

contrib(varname) Contributions

conypensions(varname) Contributory Pensions

contpensions(varname) Contributions to Pensions

noncontrib(varname) Non Contributory Pensions

flagcct(varname) Flagship CCT

otransfers(varname) Other Direct Transfers

isubsidies(varname) Indirect Subsidies

itax(varname) Indirect Taxes

ikeduc(varname) In-kind Education

ikhealth(varname) In-kind Health

hurban(varname) Housing and Urban

PPP conversion
ppp(real) PPP conversion factor (LCU per international $, consumption-based) from year of PPP (e.g., 2005 or 2011) to year of PPP; do not use PPP factor for year of household survey

cpibase(real) CPI of base year (i.e., year of PPP, usually 2005 or 2011)

cpisurvey(real) CPI of year of household survey

daily Indicates that variables are in daily currency

monthly Indicates that variables are in monthly currency

yearly Indicates that variables are in yearly currency (the default)

Poverty lines
nextreme(string) National Extreme Poverty Line in same units as income variables (can be a scalar or varname)

nmoderate(string) National Moderate Poverty Line in same units as income variables (can be a scalar or varname)

Income group cut-offs
cut1(real) Upper bound income for ultra-poor; default is $1.25 PPP per day

cut2(real) Upper bound income for extreme poor; default is $2.50 PPP per day

cut3(real) Upper bound income for moderate poor; default is $4 PPP per day

cut4(real) Upper bound income for vulnerable; default is $10 PPP per day

cut5(real) Upper bound income for middle class; default is $50 PPP per day

Coverage
cct(varname) Conditional Cash Transfers

noncontrib(varname) Non Contributory Pensions

pensions(varname) Non Contributory Pensions

unemploy(varname) Unemployment Benefits

foodtransfers(varname) Food Transfers

otransfers(varname) Other Direct Transfers

health(varname) Health

pensions(varname) Pensions

scholarships(varname) Scholarships

tarcct(varname) Conditional Cash Transfers Target Population

tarncp(varname) Non Contributory Pensions Target Population

tarpen(varname) Pensions Target Population

Education
age(varname) Age

edpre(varname) Pre-School

redpre(varname) Pre-School Age Range (1 if is in range)

edpri(varname) Primary School

redpri(varname) Primary School Age Range (1 if is in range)

edsec(varname) Secondary School

redsec(varname) Secondary School Age Range (1 if is in range)

edter(varname) Terciary School

redter(varname) Terciary School Age Range (1 if is in range)

edpublic(varname) Public School

edprivate(varname) Private School

attend(varname) Attends School

Infrastructure Access (Dichotomous Variables)
water(varname) Water

electricity(varname) Electricity

walls(varname) Walls

floors(varname) Floors

roof(varname) Roof

sewage(varname) Sewage

roads(varname) Roads

Household
hhead(varname) Household head identifier

hhid(varname) Household ID

Circumstance
gender(varname) Gender

urban(varname) Urban Identifier

edpar(varname) Parent's Education

Survey Information
hsize(varname) Number of members in the household

psu(varname) Primary sampling unit; can also be set using svyset

strata(varname) Strata (used with complex sampling designs); can also be set using svyset

pweight allowed; see weights. Alternatively, weights can be specified using svyset.

Description

ceqrace Produces results by race or ethnicity based on Commitment to Equity (CEQ) framework, the 20 tables of the Ethno-racial Workbook can be estimated separately and saved in the Excel file specified in using(filename).

The variables given by race(varname) must be dummy variables that identify different races or groups in the intended order where up to five variables are allowed, and the ordering in the Ethno-racial Workbook is taken as reference.

This program uses the table(name) option to identify which table to generate and uses the putexcel command to export to Excel. Options vary depending on the table that is being exported (for more information see below in section Tables and Examples.

This program uses the following built in programs from DASP digini, dientropy and dinineq. It uses ineqdeco and ceq as well.

All monetary values must be in per capita monthly LCU.

Poverty lines are used for poverty results; for results by income group, the cut-offs of these groups can be changed using the cut1(real) to cut5(real) options; the default groups are ultra-poor ($0 to $1.25 per day in purchasing power parity [PPP] adjusted US dollars), extreme poor ($1.25 to $2.50 PPP per day), moderate poor ($2.50 to $4 PPP per day), vulnerable ($4 to $10 PPP per day), middle class ($10 to $50 PPP per day) and wealthy ($50 and more PPP per day). For example, specify cut1(1.90) to change the first cut-off to $1.90 PPP per day (which would cause the lowest group to range from $0 to $1.90 PPP per day, and the second group--if cut2(real) is not specified so the default second cut-off is maintained--to range from $1.90 to $2.50 PPP).

ceqrace automatically converts local currency variables to PPP dollars, using the PPP conversion
factor given by ppp(real), the consumer price index (CPI) of the year of PPP (e.g., 2005 or
2011) given by cpibase(real), and the CPI of the year of the household
survey used in the analysis given by cpisurvey(real). The year of PPP, also called base year,
refers to the year of the International Comparison Program (ICP) that is being used, e.g. 2005 or 2011.
The survey year refers to the year of the household survey used in the analysis. If the year of PPP is
2005, the PPP conversion factor should be the "2005 PPP conversion factor, private consumption (LCU per
international $)" indicator from the World Bank's World Development Indicators (WDI). If the year of
PPP is 2011, use the "PPP conversion factor, private consumption (LCU per international $)" indicator
from WDI. The PPP conversion factor should convert from year of PPP to year of PPP. In other words,
when extracting the PPP conversion factor, it is possible to select any year; DO NOT select the year of
the survey, but rather the year that the ICP was conducted to compute PPP conversion factors (e.g.,
2005 or 2011). The base year (i.e., year of PPP) CPI, which can also be obtained from WDI, should match
the base year chosen for the PPP conversion factor. The survey year CPI should match the year of the
household survey. Finally, for the PPP conversion, the user can specify whether the original variables
are in local currency units per day (daily), per month (monthly), or per year
(yearly, the default assumption).

Tables and examples

F3.- Ethno-Racial Populations Variables in varlist, and [[weight]] are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_Workbook.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f3)

F5.- Population Composition Variables in varlist, [[weight]], original(varname), disposable(varname), hhid(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f5) o(y_m) d(y_d) hhid(hhid) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F6.- Distribution Variables in varlist, [[weight]], original(varname), disposable(varname), hhid(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f6) o(y_m) d(y_d) hhid(hhid) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F7.- Poverty Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), nextreme(string), and nmoderate(string) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f7) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year next(137) nmod(350)

F8.- Poverty Gap Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname), nextreme(string), and nmoderate(string) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f8) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year next(137) nmod(350)

F9.- Poverty Gap Squared Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname), nextreme(string), and nmoderate(string) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f9) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year next(137) nmod(350)

F10.- Inequality Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname) are required..

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f10) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f)

F11.- Mean Income Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx, race1(indig) race2(white) race3(afrd) table(f11)m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f)

F12.- Incidence (Decile) Variables in varlist, [[weight]], original(varname), market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname),
dtax(varname), contributions(varname), contpensions(varname), contypensions(varname), noncontributory(varname), flagcct(varname), otransfers(varname), isubsidies(varname), itax(varname), ikeducation(varname),
ikhealth(varname), hurban(varname), hhid(varname), are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f12) o(y_m) m(y_m) contp(contp) conyp(conyp) mplusp(y_mp) dtax(dtax) n(y_nm) nonc(nonc) flagcct(fcct) otran(otran) g(y_g) taxab(y_taxab) d(y_d) isub(isub) itax(itax) c(y_c) ike(ik_e) ikh(ik_h) hu(hu) f(y_f) hhid(hhid)

F13.- Incidence (income groups) Variables in varlist, [[weight]], original(varname), market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname),
dtax(varname), contributions(varname), contpensions(varname), contypensions(varname), noncontributory(varname), flagcct(varname), otransfers(varname), isubsidies(varname), itax(varname), ikeducation(varname),
ikhealth(varname), hurban(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f13) o(y_m) m(y_m) contp(contp) contyp(contyp) mplusp(y_mp) dtax(dtax) n(y_nm) nonc(nonc) flagcct(fcct) otran(otran) g(y_g) taxab(y_taxab) d(y_d) isub(isub) itax(itax) c(y_c) ike(ik_e) ikh(ik_h) hu(hu) f(y_f) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F16.- Fiscal Profile Variables in varlist, [[weight]], original(varname), disposable(varname), consumable(varname), age(varname), pensions(varname), hhe(varname), hhid(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f16) o(y_m) d(y_d) c(y_c) pens(pensions) hhe(hhe_id) hhid(hh_id) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F17.- Coverage (Total) Variables in varlist, [[weight]], original(varname), cct(varname), noncontrib(varname), unemploy(varname), foodtransf(varname), otransfers(varname),
health(varname), pensions(varname), hhe(varname), hhid(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f17) o(y_m) cct(cct) nonc(nonc) unem(unemployment) foodt(f_tran) otran(o_tran) hea(health) pen(pensions) hhe(hhe_id) hhid(hh_id) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F18.- Coverage (target) Variables in varlist, [[weight]], original(varname), cct(varname), noncontrib(varname), pensions(varname), hhe(varname), hhid(varname), tarcct(varname), tarncp(varname), tarpen(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f18) o(y_m) cct(cct) nonc(nonc) pen(pensions) hhe(hhe_id) hhid(hh_id) tarncp(tncp) tarcct(tcct) tarpen(tpen) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F20.- Mobility Variables in varlist, [[weight]], original(varname), disposable(varname), consumable(varname), final(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f20) o(y_m) d(y_d) c(y_c) f(y_f) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F21.- Education (populations) Variables in varlist, [[weight]], original(varname), edpre(varname), edpri(varname), edsec(varname),
edter(varname), redpre(varname), redpri(varname), redsec(varname), redter(varname), edpublic(varname), edprivate(varname), and attend(varname) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f21) o(y_m) edpre(ed_pre) edpri(ed_pri) edsec(ed_sec) edter(ed_ter) attend(attendschool) redpre(red_pre) redpri(red_pri) redsec(red_sec) redter(red_ter) hhe(id_hhead) hhid(id_hh) edpriv(private) edpub(public)

F23.- Educational Probability Variables in varlist, [[weight]], original(varname), edpre(varname), edpri(varname), edsec(varname),
edter(varname), redpre(varname), redpri(varname), redsec(varname), redter(varname), attend(varname), hhid(varname), and hhead(varname) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f23) o(y_m) edpre(ed_pre) edpri(ed_pri) edsec(ed_sec) edter(ed_ter) attend(attendschool) redpre(red_pre) redpri(red_pri) redsec(red_sec) redter(red_ter) hhid(id_hh) hhe(id_hhead) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F24.- Infraestructure Access Variables in varlist, [[weight]], original(varname), hhid(varname), hhead(varname), water(varname), electricity(varname), walls(varname),
floors(varname), roof(varname), sewage(varname), roads(varname),and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f24) o(y_m) hhid(id_hh) hhe(id_hhead) water(water) electricity(elect) walls(walls) floors(floors) roof(roof) sewage(sewage) roads(roads) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

F25.- Theil Decomposition Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname),
gender(varname), urban(varname), and edpar(varname) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f25) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) gender(sex) urban(rururb) edpar(parentsed)

F26.- Inequality of Opportunity Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname),
gender(varname), urban(varname) are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f26) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) gender(sex) urban(rururb)

F27.- Significance Variables in varlist, [[weight]], market(varname), mpluspensions(varname), netmarket(varname), gross(varname), taxable(varname), disposable(varname), consumable(varname), final(varname), psu(varname), strata(varname), and poverty lines are required.

Example:

. ceqrace [pw=weight] using CEQ_Ethno_Racial_MWB.xlsx,race1(indig) race2(white) race3(afrd) race4(orace) race5(nonrace) table(f27) m(y_m) mplusp(y_mp) n(y_nm) g(y_g) taxab(y_taxab) d(y_d) c(y_c) f(y_f) psu(upm) strata(strata) ppp(7.65) cpibase(78.661) cpisurvey(105.196) year

Author

Rodrigo Aranda, Tulane University, raranda@tulane.edu

References

Commitment to Equity (CEQ) Handbook, which describes the income concepts and contents of CEQ Master Workbook:

Lustig, N. and S. Higgins. 2013. "Commitment to Equity Assessment (CEQ): Estimating the Incidence of Social Spending, Subsidies and Taxes Handbook." CEQ Working Paper 1.

Commitment to Equity website

Fiscal Policy and the Ethno-racial Divide in Bolivia, Brazil, Guatemala and Uruguay (Working document)