Creating a 2000 IES-LFS Database in Stata



PROVIDE Project Technical Paper 2005:1

February 2005


Table 10: Forming deciles using income and expenditure

Exp decile

1

Exp decile
2

Exp decile
3

Exp decile
4

Exp decile
5

Exp decile
6

Exp decile

7

Exp decile
8

Exp decile
9

Exp decile

10

Inc decile 1

1.791

312

_______132

________84

_______84

________54

________59

_______46

________41

________45

Inc decile 2

525

1.460

499

_______137

_______66

_______42

_______22

_________18

____B

____________5

Inc decile 3

________165

510

1.291

376

________95

________51

_______24

________17

________19

___________3

Inc decile 4

________59

_______147

422

1.330

373

_______92

_______39

_________18

________14

________10

Inc decile 5

________48

________101

_______153

436

1.387

402

_______77

_______44

________14

_______________1

Inc decile 6

_________14

__________55

_______69

_______137

380

1.415

412

_______60

________19

_________15

Inc decile 7

_________14

________18

_______28

_______66

_______140

387

1.490

394

________61

_______24

Inc decile 8

____________5

_________7

________17

_______37

_______57

________125

385

1,613

344

________33

Inc decile 9

_______________1

_________11

___________8

________12

_______27

_______44

_______98

359

1.800

285

Inc decile 10

_______________1

___________3

____________5

____B

_________9

________16

________52

297

2.200

Total obs.

2,622

2,622

2,622

2,620

2,622

2,621

2,622

2,621

2,622

2,621

Diagonal____

68.3%

55.7%

49.2%

50.8%

52.9%

54.0%

56.8%

61.5%

68.6%

83.9%

Shaded band

88.3%

87.0%

84.4%

81.8%

81.6%

84.1%

87.2%

90.3%

93.1%

94.8%

Note: Analytic weights assumed (variable weight)

4.2.   Adjusting the data (adjustments.do )

Do-file adjustments.do creates final person- and household level files from which the various
household- and factor-related SAM sub-matrices are extracted. The person-level file is
created by merging the IES 2000 and LFS 2000:2 files. This allows the user the option to
either use the IES 2000 employment data or the LFS 2000:2 employment data for the factor-
related sub-matrices. Some adjustments, which are discussed below, are also made to the
household-level IES 2000 file. Figure 12 shows the structure of
adjustments.do and its sub-
do-files.

56

© PROVIDE Project



More intriguing information

1. Does adult education at upper secondary level influence annual wage earnings?
2. Fiscal Insurance and Debt Management in OECD Economies
3. The name is absent
4. An institutional analysis of sasi laut in Maluku, Indonesia
5. Strategic Investment and Market Integration
6. The name is absent
7. CREDIT SCORING, LOAN PRICING, AND FARM BUSINESS PERFORMANCE
8. Regional differentiation in the Russian federation: A cluster-based typification
9. Analyse des verbraucherorientierten Qualitätsurteils mittels assoziativer Verfahren am Beispiel von Schweinefleisch und Kartoffeln
10. The name is absent