st: To: statalist@hsphsun2.harvard.edu

[peter harper <pharper11@yahoo.co.uk>]

Dear Statalist
 
Thanks. My apologies. 
 
I want to create a dependent log pay hour per worker, say,
yij. These pay levels are to be taken from individual
workers self-reports (across 12 wage bands), and
converted into earnings per hour using the reports of
hours worked. I would like to please ask what would be the most appropriate command in Stata for this dependent variable.
 
.ta e15
how much do you get paid 
for your job here, 
before tax and  
other dedu |           Freq.     Percent        Cum.
       |      
----------------------------------------+-------------
not answered (99) |        414        1.84        1.84
multicoded (97) |           19        0.08        1.93
�50 or less per week 
�2600 or less per 
year |                     634        2.82        4.75
�51-�80 per week 
�2601-�4160 per year |     730        3.25        8.00
�81-�110 per week 
�4161-�5720 per year |     872        3.88       11.89
�111-�140 per week 
�5721-�7280 per year |   1,021        4.55       16.44
�141-�180 per week 
�7281-�9360 per year |  1,269        5.65       22.09
�181-�220 per week 
�9361-�11440 per yea |  1,723        7.67       29.76
�221-�260 per week 
�11441-�13520 per ye |  2,083        9.28       39.04
�261-�310 per week 
�13521-�16120 per ye |  2,498       11.13       50.17
�311-�360 per week 
�16121-�18720 per ye |  2,099        9.35       59.52
�361-�430 per week 
�18721-�22360 per ye |  2,496       11.12       70.63
�431-�540 per week 
�22361-�28080 per ye |  2,493       11.10       81.74
�541-�680 per week 
�28081-�35360 per ye |  2,004        8.93       90.66
�681-�870 per week 
�35361-�45240 per ye |  1,083        4.82       95.49
�871 or more a week 
�45241 or more per  |   1,013        4.51      100.00
----------------------------------------+-------------
 Total |                22,451      100.00
 
The variable gives many hours, individual worked.
 
. ta a3
    how many hours, |
 including overtime |
 or extra hours, do |
   you  usually wor |      Freq.     Percent       
Cum.
--------------------+-----------------------------------
  not answered (99) |        337        1.50       
1.50
                  0 |        104        0.46       
1.96
                  1 |         32        0.14       
2.11
                  2 |         75        0.33       
2.44
                  3 |         78        0.35       
2.79
                  4 |         80        0.36       
3.14
                  5 |        123        0.55       
3.69
                  6 |        131        0.58       
4.28
                  7 |        130        0.58       
4.86
                  8 |        174        0.78       
5.63
                  9 |         69        0.31       
5.94
                 10 |        206        0.92       
6.85
                 11 |         53        0.24       
7.09
                 12 |        180        0.80       
7.89
                 13 |         64        0.29       
8.18
                 14 |         99        0.44       
8.62
                 15 |        263        1.17       
9.79
                 16 |        269        1.20      
10.99
                 17 |         98        0.44      
11.42
                 18 |        273        1.22      
12.64
                 19 |        102        0.45      
13.10
                 20 |        558        2.49      
15.58
                 21 |        189        0.84      
16.42
                 22 |        229        1.02      
17.44
                 23 |        138        0.61      
18.06
                 24 |        237        1.06      
19.11
                 25 |        430        1.92      
21.03
                 26 |        121        0.54      
21.57
                 27 |        106        0.47      
22.04
                 28 |        200        0.89      
22.93
                 29 |         55        0.24      
23.17
                 30 |        656        2.92      
26.10
                 31 |         51        0.23      
26.32
                 32 |        221        0.98      
27.31
                 33 |        129        0.57      
27.88
                 34 |         96        0.43      
28.31
                 35 |      1,208        5.38      
33.69
                 36 |        567        2.53      
36.22
                 37 |      2,616       11.65      
47.87
                 38 |      1,445        6.44      
54.30
                 39 |        957        4.26      
58.57
                 40 |      3,071       13.68      
72.25
                 41 |        179        0.80      
73.04
                 42 |        777        3.46      
76.50
                 43 |        352        1.57      
78.07
                 44 |        275        1.22      
79.30
                 45 |      1,330        5.92      
85.22
                 46 |        171        0.76      
85.98
                 47 |        165        0.73      
86.72
                 48 |        592        2.64      
89.35
                 49 |         75        0.33      
89.69
                 50 |      1,048        4.67      
94.36
                 51 |         29        0.13      
94.49
                 52 |        119        0.53      
95.02
                 53 |         43        0.19      
95.21
                 54 |         50        0.22      
95.43
                 55 |        281        1.25      
96.68
                 56 |         69        0.31      
96.99
                 57 |         22        0.10      
97.09
                 58 |         24        0.11      
97.19
                 59 |          6        0.03      
97.22
                 60 |        365        1.63      
98.85
                 61 |          5        0.02      
98.87
                 62 |         17        0.08      
98.94
                 63 |          8        0.04      
98.98
                 64 |          8        0.04      
99.02
                 65 |         58        0.26      
99.27
                 66 |          5        0.02      
99.30
                 67 |          4        0.02      
99.31
                 68 |         21        0.09      
99.41
                 69 |          3        0.01      
99.42
                 70 |         47        0.21      
99.63
                 71 |          2        0.01      
99.64
                 72 |         25        0.11      
99.75
                 73 |          2        0.01      
99.76
                 74 |          1        0.00      
99.76
                 75 |          6        0.03      
99.79
                 76 |          1        0.00      
99.80
                 77 |          3        0.01      
99.81
                 78 |          4        0.02      
99.83
                 80 |         12        0.05      
99.88
                 82 |          2        0.01      
99.89
                 84 |         13        0.06      
99.95
                 85 |          4        0.02      
99.96
                 86 |          1        0.00      
99.97
                 89 |          1        0.00      
99.97
                 90 |          4        0.02      
99.99
                 96 |          2        0.01     
100.00
--------------------+-----------------------------------
              Total |     22,451      100.00

I would be grateful, if you would let me know, if
intreg is the right estimation method. This has been done using an older version of the data set.
 
1. To do a median of pay is not possible where it is
<=50 and �871 or more a week.
I would be grateful, if you would let me know the
command in Stata, to get log pay per hour per
worker.
 
Thanking You

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/