--------------------------------------------------------------------------------------------------------------
       log:  C:\Documents and Settings\HP_Owner\My Documents\My Classes\SOCY498C\By-Egen\SOCY498C-HW6-BY-EGEN.
> txt
  log type:  text
 opened on:  30 Jan 2009, 12:33:24

. 
. clear

. 
. capture confirm file "C:\Documents and Settings\HP_Owner\My Documents\My Research\GSS\GSS-Cumulative-72-06.d
> ta"

. if _rc {
.   di "_rc"
. }

. else {
.   local gss "C:\Documents and Settings\HP_Owner\My Documents\My Research\GSS\GSS-Cumulative-72-06.dta"
. }

. 
. #delimit ;
delimiter now ;
. use year
>     socbar
>     socrel
>     socommun
>     socfrend
>     marital
>     race
>     age
>     sex
>     sexfreq if race!=3 using "`gss'", clear;
(General Social Surveys, 1972-2006 [Cumulative File], Dataset 0001)

. #delimit cr
delimiter now cr
. 
. /* Create average sociability measure */
. #delimit ;
delimiter now ;
. recode socrel socommun socfrend socbar
>   (1=7) (2=6) (3=5),
>   prefix(x)
>   label(socrel);
(14973 differences between socrel and xsocrel)
(10039 differences between socommun and xsocommun)
(11703 differences between socfrend and xsocfrend)
(4596 differences between socbar and xsocbar)

. #delimit cr
delimiter now cr
. 
. generate sociability=(xsocrel+xsocommun+xsocfrend+xsocbar)/4
(21251 missing values generated)

. label variable sociability "Sociability Scale (1-25)"

. drop xsocrel xsocommun xsocfrend xsocbar

. 
. #delimit ;
delimiter now ;
. recode sexfreq (0=0)
>                (1=1.5)
>                (2=12)
>                (3=30)
>                (4=52)
>                (5=130)
>                (6=237), gen(sexfreq1)
> ;
(15308 differences between sexfreq and sexfreq1)

. #delimit cr
delimiter now cr
. label variable sexfreq1 "Sexual Frequency (yearly)"

. 
. 
. /* by and egen examples */
. sort marital

. by marital: summarize sociability

--------------------------------------------------------------------------------------------------------------
-> marital = MARRIED

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |     15117    5.594546    .5533408          4          7

--------------------------------------------------------------------------------------------------------------
-> marital = WIDOWED

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |      2819    5.961245    .5406074          4          7

--------------------------------------------------------------------------------------------------------------
-> marital = DIVORCED

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |      3317     5.67757    .5673931          4          7

--------------------------------------------------------------------------------------------------------------
-> marital = SEPARATED

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |       971    5.742791    .5823429          4          7

--------------------------------------------------------------------------------------------------------------
-> marital = NEVER MARRIED

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |      5318    5.690062    .5650854          4          7

--------------------------------------------------------------------------------------------------------------
-> marital = .

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 sociability |         4         5.5    .5773503          5          6


. 
. sort marital age

. by marital: gen minage=age[1]

. 
. drop minage

. bysort marital (age): gen minage=age[1] 

. 
. egen age_cat1 = cut(age), at(18, 25, 35, 45, 55, 65, 75, 90)
(177 missing values generated)

. egen age_cat2 = cut(age), group(6)
(177 missing values generated)

. 
. egen sexfreq2 = mean(sexfreq1), by(marital)

. egen sexfreq3 = mean(sexfreq1), by(sex marital)
(5 missing values generated)

. 
. egen numobs1 = count(sexfreq1), by(year)

. egen numobs2 = count(sexfreq1), by(year marital)

. 
. egen sexmar=group(sex marital), label
(12 missing values generated)

. egen marsex=group(marital sex), label
(12 missing values generated)

. 
. egen sexmarcon=concat(sex marital), punct(/)

. 
. 
. /* by and egen problems */
. egen socmiss=rowmiss(socrel socommun socfrend socbar)

. tab socmiss

    socmiss |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |     27,546       56.45       56.45
          1 |        197        0.40       56.85
          2 |         19        0.04       56.89
          3 |         16        0.03       56.93
          4 |     21,019       43.07      100.00
------------+-----------------------------------
      Total |     48,797      100.00

. 
. egen racesex=group(race sex), label

. tab racesex

  group(race |
        sex) |      Freq.     Percent        Cum.
-------------+-----------------------------------
  WHITE MALE |     18,725       38.37       38.37
WHITE FEMALE |     23,039       47.21       85.59
  BLACK MALE |      2,682        5.50       91.08
BLACK FEMALE |      4,351        8.92      100.00
-------------+-----------------------------------
       Total |     48,797      100.00

. graph bar (p25) sociability (p75) sociability, over(racesex)

. 
. egen avgsoc=mean(sociability), by(year sex)
(9235 missing values generated)

. 
. log close
       log:  C:\Documents and Settings\HP_Owner\My Documents\My Classes\SOCY498C\By-Egen\SOCY498C-HW6-BY-EGEN.
> txt
  log type:  text
 closed on:  30 Jan 2009, 12:33:39
--------------------------------------------------------------------------------------------------------------