Creating a 2000 IES-LFS Database in Stata
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.