Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: To: statalist@hsphsun2.harvard.edu


From   peter harper <pharper11@yahoo.co.uk>
To   undisclosed-recipients: ;
Subject   st: To: statalist@hsphsun2.harvard.edu
Date   Wed, 17 May 2006 16:09:25 +0000 (GMT)

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index