Creating a 2000 IES-LFS Database in Stata



PROVIDE Project Technical Paper 2005:1

February 2005


List of Figures

Figure 1: Comparing LFS 2000:2 and IES 2000 average wages and employment figures ....12

Figure 2: Comparing patterns of expenditure from IES 2000 and SUT 2000 ........................19

Figure 3: Comparing patterns of expenditure from IES 2000, SUT 2000 and SARB 2000...20

Figure 4: Relative income sources by income deciles ............................................................24

Figure 5: Food budget share by expenditure deciles using adult equivalent scales................24

Figure 6: Average tax rates by expenditure deciles ................................................................27

Figure 7: Savings rate by expenditure deciles.........................................................................27

Figure 8: Do-file structure of ies2000.do ................................................................................29

Figure 9: Do-file structure of ies2000h.do ..............................................................................30

Figure 10: Distribution of the difference between income and expenditure (variable diff)....54

Figure 11: Distribution of the relative income and expenditure difference (variable diffp) ...55

Figure 12: Do-file structure of adjustments.do .......................................................................57

Figure 13: Total value of transfer payments and receipts by income decile...........................67

Figure 14: Transfer payments and receipts as a percentage of total income ..........................68

List of Tables

Table 1: Percentage differences (employment and wages).....................................................13

Table 2: Cross-tabulation of employment data.......................................................................14

Table 3: Cross-tabulating gender, location and race...............................................................16

Table 4: Comparing patterns of expenditure from IES 2000, SUT 2000 and SARB 2000 ....19

Table 5: Comparing IES 2000 and SARB 2000 income and expenditure patterns ................21

Table 6: Tax rates reported in IES 2000 (R millions).............................................................25

Table 7: Occupation codes (variable factors) .........................................................................35

Table 8: Uncoded, miscoded and true missing values in IES 2000 .......................................40

Table 9: Four error types in housing section (monthly instalment on bond)..........................42

Table 10: Forming deciles using income and expenditure......................................................56

Table 11: Commodity accounts and other expenditure categories .........................................66

Table 12: Adjusted transfers data extracted from IES 2000 ...................................................69

Table 13: Inter-household transfers sub-matrix......................................................................70

Table 14: Final inter-household transfers matrix....................................................................70

iii

© PROVIDE Project



More intriguing information

1. The Importance of Global Shocks for National Policymakers: Rising Challenges for Central Banks
2. The name is absent
3. The name is absent
4. Innovation in commercialization of pelagic fish: the example of "Srdela Snack" Franchise
5. Cancer-related electronic support groups as navigation-aids: Overcoming geographic barriers
6. Towards a framework for critical citizenship education
7. The name is absent
8. The name is absent
9. The name is absent
10. Revisiting The Bell Curve Debate Regarding the Effects of Cognitive Ability on Wages
11. Land Police in Mozambique: Future Perspectives
12. EU enlargement and environmental policy
13. Regionale Wachstumseffekte der GRW-Förderung? Eine räumlich-ökonometrische Analyse auf Basis deutscher Arbeitsmarktregionen
14. Synthesis and biological activity of α-galactosyl ceramide KRN7000 and galactosyl (α1→2) galactosyl ceramide
15. Labour Market Flexibility and Regional Unemployment Rate Dynamics: Spain (1980-1995)
16. The economic doctrines in the wine trade and wine production sectors: the case of Bastiat and the Port wine sector: 1850-1908
17. Une Classe de Concepts
18. TOWARD CULTURAL ONCOLOGY: THE EVOLUTIONARY INFORMATION DYNAMICS OF CANCER
19. Ex post analysis of the regional impacts of major infrastructure: the Channel Tunnel 10 years on.
20. The Functions of Postpartum Depression