Article thumbnail

Creating a 2000 IES-LFS Database in Stata

By Kalie Pauw


The Income and Expenditure Survey of 2000 is the most recent comprehensive source of information on income and expenditure patterns of South African households. This data is used to compile various household-related sub-matrices for a series of Social Accounting Matrices for South Africa. By linking the Labour Force Survey of September 2000, which contains detailed employment data on occupation codes, activity codes and wages of workers, with the Income and Expenditure Survey of 2000 various factor-related sub-matrices can also be extracted. This paper discusses the steps followed to extract data, correct problems and errors where appropriate or necessary, merge various files, and create Stata format data files that can be used to compile the relevant submatrices. The focus remains highly technical throughout.Consumer/Household Economics,

OAI identifier:
Downloaded from

To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.

Suggested articles


  1. (2003). A Critical Assessment of the 1995 and 2000 Income and Expenditure Surveys as Sources of Information on Incomes,"
  2. (2001). A Social Accounting Matrix for the Western Cape." Department of Agriculture,
  3. (2003). Comments on Income and Expenditure Survey
  4. (2000). Compiling a Social Accounting Matrix for South Africa:
  5. (2003). Consumption patterns and living standards of the black population in perspective."
  6. (2003). Consumption Patterns of South Africa's Rising Black Middle-Class: Correcting for Measurement Errors." Paper presented at the CSAE conference on Poverty Reduction, Growth and Human Development in Africa,
  7. (1995). Creating a
  8. Forming Representative Household Groups in a SAM,"
  9. (2004). Not Separate, Not Equal. Poverty and Inequality in PostApartheid South Africa." World Bank.
  10. (2002). Quarterly Bulletin,
  11. SSA (2003b): Final supply and use tables, 2000: an input-output framework, Pretoria: Statistics South Africa.
  12. (2001). Statistical Software: Release 7.0. Stata Corporation: College Station,
  13. (1997). The Analysis of Household Surveys. A Microeconometric Approach to Development Policy.
  14. (1998). The People of South Africa: Population Census