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. The Mathematical Components of Engineering
2. Exchange Rate Uncertainty and Trade Growth - A Comparison of Linear and Nonlinear (Forecasting) Models
3. El impacto espacial de las economías de aglomeración y su efecto sobre la estructura urbana.El caso de la industria en Barcelona, 1986-1996
4. Valuing Farm Financial Information
5. INTERACTION EFFECTS OF PROMOTION, RESEARCH, AND PRICE SUPPORT PROGRAMS FOR U.S. COTTON
6. Geography, Health, and Demo-Economic Development
7. BARRIERS TO EFFICIENCY AND THE PRIVATIZATION OF TOWNSHIP-VILLAGE ENTERPRISES
8. The demand for urban transport: An application of discrete choice model for Cadiz
9. Om Økonomi, matematik og videnskabelighed - et bud på provokation
10. FDI Implications of Recent European Court of Justice Decision on Corporation Tax Matters