Creating a 2000 IES-LFS Database in Stata



PROVIDE Project Technical Paper 2005:1


February 2005


Figure 12: Do-file structure of adjustments.do


adjustments.do


Master do-file. Starts by copying ies2000h.dta and ies2000p.dta created by ies2000.do to
thisfolder.This do-file makes various changes to the data before creating tables used for
sub-SAM matrices.

I Merges ies2000p_orig.dta and lfs2000_2_orig.dta to create ieslfsmerge.dta. New variables for factors, labour

I income, activities, gender, age, province, location, race and person-weights are created.

Next, the newly created ieslfsmerge. dta database is ‘cleared up ’, some additional variables created, and demographic variables are carried over to
ies2000h.dta.


ieslfsmerge.do



1 This do-file creates variables for transfers to and from the rest of the world based on SARB 2000 data and IES 2000 data
r on inter-household transfers (which by assumption include transfers to and from the rest of the world). Total domestic
t transfer receipts and payments should also match by definition, hence these levels are re-scaled.

} Undeclared income and under-declared expenditure is added to total income or expenditure and all income
or expenditure categories are scaled upwards, keeping the patterns of income or expenditure constant. A
similar adjustment is also made for “other” income or expenditure.


Creates a scaling factor for the person-level labour income variable, inclabp_new. This variable is scaled
■ up so that it matches the household-level variable inclab. The old version of inclabp_new is saved as
inclabp_old and can also be used if necessary (together with newfact_old and mergeact_old.


C Creates new factor groups, either for use with inclabp_old (newfact_old) or inclabp_new (newfact).


A series of do-files are run to form various household classifications that can be used for the formation of household
groups for the SAM. These include homeland.do (former homelands areas), metro.do (metropolitan areas), nodals.do
(areas earmarkedfor rural development programmes, municipalities.do (district municipalities), and newrhg.do (current
household accounts for SAM).


57


© PROVIDE Project




More intriguing information

1. The name is absent
2. Commitment devices, opportunity windows, and institution building in Central Asia
3. The name is absent
4. Benchmarking Regional Innovation: A Comparison of Bavaria, Northern Ireland and the Republic of Ireland
5. Retirement and the Poverty of the Elderly in Portugal
6. The duration of fixed exchange rate regimes
7. The name is absent
8. The Provisions on Geographical Indications in the TRIPS Agreement
9. Pupils’ attitudes towards art teaching in primary school: an evaluation tool
10. AN ECONOMIC EVALUATION OF COTTON AND PEANUT RESEARCH IN SOUTHEASTERN UNITED STATES
11. On Evolution of God-Seeking Mind
12. The name is absent
13. CHANGING PRICES, CHANGING CIGARETTE CONSUMPTION
14. DISCUSSION: ASSESSING STRUCTURAL CHANGE IN THE DEMAND FOR FOOD COMMODITIES
15. The name is absent
16. Strategic monetary policy in a monetary union with non-atomistic wage setters
17. Lumpy Investment, Sectoral Propagation, and Business Cycles
18. Qualifying Recital: Lisa Carol Hardaway, flute
19. ASSESSMENT OF MARKET RISK IN HOG PRODUCTION USING VALUE-AT-RISK AND EXTREME VALUE THEORY
20. The name is absent