Statalist The Stata Listserver


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

st: Re: RE: Re: RE: calculating gender wage ratioes for different levels of education


From   "Christer Thrane" <ch-thran@online.no>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: RE: Re: RE: calculating gender wage ratioes for different levels of education
Date   Thu, 7 Sep 2006 20:03:45 +0200

Thanks to you also, Nick!

Chris
----- Original Message ----- From: "Nick Cox" <n.j.cox@durham.ac.uk>
To: <statalist@hsphsun2.harvard.edu>
Sent: Thursday, September 07, 2006 6:41 PM
Subject: st: RE: Re: RE: calculating gender wage ratioes for different levels of education



Scott Merryman has given you code for a calculate,
put in locals and print style.

Another approach is to get results into variables.
You might even want to show graphs, or use the
results downstream. The main trick is to copy
non-missing values over missing values, so that
you can calculate ratios in place:

bysort rep78 (foreign) : egen f_mean = mean(price) if foreign
by rep78 : egen d_mean = mean(price) if !foreign
bysort rep78 (f_mean) : replace f_mean = f_mean[1]
bysort rep78 (d_mean) : replace d_mean = d_mean[1]
gen ratio = d_mean / f_mean
tabdisp rep78, c(ratio)

Nick
n.j.cox@durham.ac.uk

Christer Thrane

Okay, a second try, then.

Using the auto data, I wish to calculate the foreign/domestic
price ratioes
for three different levels of repair record.

 use c:\data\auto.dta, clear
(1978 Automobile Data)

.
. recode rep 1/3=3
(rep78: 10 changes made)

. tab rep

     Repair |
Record 1978 |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |         40       57.97       57.97
          4 |         18       26.09       84.06
          5 |         11       15.94      100.00
------------+-----------------------------------
      Total |         69      100.00

. drop if rep==.
(5 observations deleted)

. sort rep

. by rep: oneway price foreign, t

--------------------------------------------------------------
------------------------------------------------
-> rep78 = 3

            |          Summary of Price
   Car type |        Mean   Std. Dev.       Freq.
------------+------------------------------------
   Domestic |   6,358.405    3,526.92          37
    Foreign |   4,828.667   1,285.613           3
------------+------------------------------------
      Total |   6,243.675    3,425.43          40

 rest of output omitted
--------------------------------------------------------------
------------------------------------------------
-> rep78 = 4

            |          Summary of Price
   Car type |        Mean   Std. Dev.       Freq.
------------+------------------------------------
   Domestic |   5,881.556   1,592.019           9
    Foreign |   6,261.444   1,896.092           9
------------+------------------------------------
      Total |     6,071.5   1,709.608          18

  rest of output omitted
--------------------------------------------------------------
------------------------------------------------
-> rep78 = 5

            |          Summary of Price
   Car type |        Mean   Std. Dev.       Freq.
------------+------------------------------------
   Domestic |     4,204.5   311.83409           2
    Foreign |   6,292.667   2,765.629           9
------------+------------------------------------
      Total |       5,913   2,615.763          11

 rest of output omitted

.
end of do-file


... and here I must stop the do-file and obtain the results
above in the
following calcualtions:

. dis 6358/4828
1.3169014

. dis 5881/6261
.93930682

. dis 4204/6292
.66815003

Question: Is it possible to do this in one operation?
*
*   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/




*
*   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