Creating a 2000 IES-LFS Database in Stata

(A)

Uncoded

(B)

True
missing

(C)

Total
"missing"
(A + B)

(D)

Miscoded

(E)

Not missing,
not
miscoded

(F)

Total obs.

(C + D + E)

Monthly housing cost if rented

P0303Q0101

17,485

5

17,490

1,018

7,755

26,263

P0303Q010101

17,541

10

17,551

962

7,750

26,263

P0303Q010102

17,562

12

17,574

941

7,748

26,263

P0303Q02

17,534

11

17,545

969

7,749

26,263

P0303Q03

17,452

49

17,501

1,051

7,711

26,263

P0303Q04

17,426

29

17,455

1,077

7,731

26,263

Monthly housing cost if owned

P0303Q0501

8,006

9

8,015

1,309

16,939

26,263

P0303Q050101

8,075

14

8,089

1,240

16,934

26,263

P0303Q050102

8,075

13

8,088

1,240

16,935

26,263

P0303Q0502

8,033

11

8,044

1,282

16,937

26,263

P0303Q0503

8,018

12

8,030

1,297

16,936

26,263

Annual housing costs

P0304Q0401

111

1

112

24,642

1,509

26,263

P0304Q0402

111

1

112

24,642

1,509

26,263

P0304Q0403

111

1

112

24,642

1,509

26,263

P0304Q0404

111

1

112

24,642

1,509

26,263

P0304Q0405

111

1

112

24,642

1,509

26,263

P0304Q05

109

-

109

24,644

1,510

26,263

Holiday expenses

P03052Q0101

25,023

-

25,023

146

1,094

26,263

P03052Q0102

25,093

1

25,094

76

1,093

26,263

P0305~010401

26,032

-

26,032

49

182

26,263

P0305~010402

26,060

26,060

21

182

26,263

P03052Q02

26,060

-

26,060

21

182

26,263

Cigarettes

P0702Q01

16,947

3

16,950

22

9,291

26,263

P0702Q02

16,947

3

16,950

22

9,291

26,263

P0702Q03

16,947

2

16,949

22

9,292

26,263

P0702Q04

16,947

2

16,949

22

9,292

26,263

P0702Q05

16,947

3

16,950

22

9,291

26,263

P0702total

16,947

2

16,949

22

9,292

26,263