cameron

CPS_all_micro.dta
makedata.do:138

→ CPS_panel.dta ↘

```
CPS_panel.dta open
file:data:dta
```

All properties
key	content
N	1836
datasignature	1836:5(80647):2750722809:788198030
date	Mon Nov 17 11:53:39 EST 2014
lastmodified	1416189219000
variables	5

Variable Graph Type N Descriptives Label

[+] lnwage
@CPS_panel.dta

other
(float)

1836
(.)

(x̄=2.605, 0.118) [2.294,3.138]

(mean) lnwage

All properties
key	content
N	1836
N_unique	.
class	other
example0	2.5629244
histh	.08258864, .3097074, .39229605, .59876764, .72265065, 1.2801239, 1.9614803, 2.4983065, 2.3744235, 3.220957, 3.4480758, 3.1383684, 3.4480758, 2.952544, 2.1473048, 2.7460723, 2.0027747, 1.4453013, 1.1768882, .66070914, .51617903, .37164891, .12388296, .04129432, .04129432, .08258864, .04129432, .02064716, .06194148
histw	2.3069615, 2.3333411, 2.3597205, 2.3861001, 2.4124796, 2.4388592, 2.4652386, 2.4916182, 2.5179977, 2.5443773, 2.5707567, 2.5971363, 2.6235158, 2.6498954, 2.6762748, 2.7026544, 2.7290339, 2.7554135, 2.7817929, 2.8081725, 2.834552, 2.8609316, 2.887311, 2.9136906, 2.9400702, 2.9664497, 2.9928291, 3.0455883, 3.1247268
label	(mean) lnwage
max	3.138
mean	2.605
min	2.294
sd	0.118
type	float

file # command

makedata.do:

131 [+]

areg lnwage age age2 sex yrseduc [pw=wtsupp] , a(styr)

file # command

makedata.do:

135 [+]

collapse (mean) lnwage lnwage_sy (rawsum) wtsupp [pw=wtsupp] , by(statefip year)

Script Output


lnwage:  (mean) lnwage                          Number of Observations
----------------------                      ------------------------------
                                            Total   Integers   Nonintegers
|      #                     Negative           -         -          -
|      #                     Zero               -         -          -
|      #   #                 Positive        1836         -       1836
|      #   #                                -----     -----      -----
|      #   #                 Total           1836         -       1836
|  #   #   #   .   .         Missing            -
+----------------------                     -----
2.293772       3.137917                      1836
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
      lnwage |      1836    2.604528    .1179528   2.293772   3.137917
@mean     2.605
@sd     0.118
@min     2.294
@max     3.138
@example0 2.5629244
@histh .08258864, .3097074, .39229605, .59876764, .72265065, 1.2801239, 1.9614803, 2.4983065, 2.3744235, 3.220957, 3.4480758, 3.1383684, 3.4480758, 2.952544, 2.1473048, 2.7460723, 2.0027747, 1.4453013, 1.1768882, .66070914, .51617903, .37164891, .12388296, .04129432, .04129432, .08258864, .04129432, .02064716, .06194148
@histw 2.3069615, 2.3333411, 2.3597205, 2.3861001, 2.4124796, 2.4388592, 2.4652386, 2.4916182, 2.5179977, 2.5443773, 2.5707567, 2.5971363, 2.6235158, 2.6498954, 2.6762748, 2.7026544, 2.7290339, 2.7554135, 2.7817929, 2.8081725, 2.834552, 2.8609316, 2.887311, 2.9136906, 2.9400702, 2.9664497, 2.9928291, 3.0455883, 3.1247268
@type float
@label (mean) lnwage
@class other
@N_unique .
@N 1836

[+] lnwage_sy
@CPS_panel.dta

other
(float)

1836
(.)

(x̄=-0.021, 0.112) [-0.309,0.579]

(mean) lnwage_sy

All properties
key	content
N	1836
N_unique	.
class	other
example0	.09576894
histh	.09814136, .39256546, .41219375, .70661783, 1.2169529, 1.648775, 2.944241, 3.4153197, 3.5134609, 3.0620105, 3.0620105, 3.7686286, 2.8853562, 2.6301887, 1.8843143, 1.5310053, 1.079555, .68698955, .45145029, .215911, .11776964, .07851309, .01962827, .03925655, .05888482, .03925655, .01962827, .05888482
histw	-.29490405, -.2671552, -.23940633, -.21165746, -.1839086, -.15615974, -.12841088, -.10066201, -.07291314, -.04516428, -.01741541, .01033345, .03808232, .06583118, .09358005, .12132891, .14907777, .17682664, .20457551, .23232438, .26007324, .2878221, .31557098, .34331983, .37106869, .39881757, .48206416, .56531078
label	(mean) lnwage_sy
max	0.579
mean	-0.021
min	-0.309
sd	0.112
type	float

file # command

makedata.do:

132 [+]

predict lnwage_sy , d

135 [+]

collapse (mean) lnwage lnwage_sy (rawsum) wtsupp [pw=wtsupp] , by(statefip year)

Script Output


lnwage_sy:  (mean) lnwage_sy                    Number of Observations
----------------------------                ------------------------------
                                            Total   Integers   Nonintegers
|      #                     Negative        1069         -       1069
|      #                     Zero               -         -          -
|      #                     Positive         767         -        767
|      #                                    -----     -----      -----
|      #   #                 Total           1836         -       1836
|  #   #   #   .   .         Missing            -
+----------------------                     -----
-.3087785      .5791852                      1836
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
   lnwage_sy |      1836   -.0209217    .1121829  -.3087785   .5791852
@mean    -0.021
@sd     0.112
@min    -0.309
@max     0.579
@example0 .09576894
@histh .09814136, .39256546, .41219375, .70661783, 1.2169529, 1.648775, 2.944241, 3.4153197, 3.5134609, 3.0620105, 3.0620105, 3.7686286, 2.8853562, 2.6301887, 1.8843143, 1.5310053, 1.079555, .68698955, .45145029, .215911, .11776964, .07851309, .01962827, .03925655, .05888482, .03925655, .01962827, .05888482
@histw -.29490405, -.2671552, -.23940633, -.21165746, -.1839086, -.15615974, -.12841088, -.10066201, -.07291314, -.04516428, -.01741541, .01033345, .03808232, .06583118, .09358005, .12132891, .14907777, .17682664, .20457551, .23232438, .26007324, .2878221, .31557098, .34331983, .37106869, .39881757, .48206416, .56531078
@type float
@label (mean) lnwage_sy
@class other
@N_unique .
@N 1836

[+] popweight
@CPS_panel.dta

other
(double)

1836
(.)

(x̄=1.64e+06, 1.85e+06) [72969.100,1.25e+07]

(rawsum) wtsupp

All properties
key	content
N	1836
N_unique	.
class	other
example0	822288.43
histh	7.229e-07, 3.509e-07, 3.804e-07, 2.429e-07, 1.811e-07, 1.937e-07, 5.755e-08, 1.123e-07, 4.913e-08, 3.509e-08, 7.440e-08, 3.229e-08, 5.615e-09, 8.423e-09, 2.246e-08, 1.965e-08, 2.246e-08, 9.826e-09, 7.019e-09, 5.615e-09, 1.404e-09, 5.615e-09, 1.404e-09, 2.808e-09, 5.615e-09, 2.808e-09, 4.211e-09, 2.808e-09, 7.019e-09, 5.615e-09, 4.211e-09
histw	266969.03, 654968.88, 1042968.7, 1430968.5, 1818968.4, 2206968.3, 2594968, 2982968, 3370967.8, 3758967.5, 4146967.5, 4534967.5, 4922967, 5310967, 5698967, 6086966.5, 6474966.5, 6862966.5, 7250966, 7638966, 8026966, 8414966, 8802966, 9190965, 9578965, 9966965, 10354965, 11130965, 11518964, 11906964, 12294964
label	(rawsum) wtsupp
max	1.25e+07
mean	1.64e+06
min	72969.100
sd	1.85e+06
type	double

file # command

makedata.do:

136 [+]

rename wtsupp popweight

Script Output


popweight:  (rawsum) wtsupp                     Number of Observations
---------------------------                 ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative           -         -          -
|  #                         Zero               -         -          -
|  #                         Positive        1836         -       1836
|  #                                        -----     -----      -----
|  #                         Total           1836         -       1836
|  #   .   .   .   .         Missing            -
+----------------------                     -----
72969.1        1.25e+07                      1836
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
   popweight |      1836     1635884     1850099    72969.1   1.25e+07
@mean  1.64e+06
@sd  1.85e+06
@min 72969.100
@max  1.25e+07
@example0 822288.43
@histh 7.229e-07, 3.509e-07, 3.804e-07, 2.429e-07, 1.811e-07, 1.937e-07, 5.755e-08, 1.123e-07, 4.913e-08, 3.509e-08, 7.440e-08, 3.229e-08, 5.615e-09, 8.423e-09, 2.246e-08, 1.965e-08, 2.246e-08, 9.826e-09, 7.019e-09, 5.615e-09, 1.404e-09, 5.615e-09, 1.404e-09, 2.808e-09, 5.615e-09, 2.808e-09, 4.211e-09, 2.808e-09, 7.019e-09, 5.615e-09, 4.211e-09
@histw 266969.03, 654968.88, 1042968.7, 1430968.5, 1818968.4, 2206968.3, 2594968, 2982968, 3370967.8, 3758967.5, 4146967.5, 4534967.5, 4922967, 5310967, 5698967, 6086966.5, 6474966.5, 6862966.5, 7250966, 7638966, 8026966, 8414966, 8802966, 9190965, 9578965, 9966965, 10354965, 11130965, 11518964, 11906964, 12294964
@type double
@label (rawsum) wtsupp
@class other
@N_unique .
@N 1836

[+] statefip
@CPS_panel.dta

other
(byte)

1836
(51)

(x̄=28.961, 15.681) [1,56]

State (FIPS code)

All properties
key	content
N	1836
N_unique	51
class	other
example0	1
histh	.0228164, .0114082, .0228164, .0228164, .0228164, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0228164, .0228164, .0114082, .0114082, .0228164, .0228164
histw	1.859375, 3.578125, 5.296875, 8.734375, 10.453125, 12.171875, 15.609375, 17.328125, 19.046875, 20.765625, 22.484375, 24.203125, 25.921875, 27.640625, 29.359375, 31.078125, 32.796875, 34.515625, 36.234375, 37.953125, 39.671875, 41.390625, 44.828125, 46.546875, 48.265625, 49.984375, 51.703125, 53.421875, 55.140625
label	State (FIPS code)
max	56
mean	28.961
min	1
sd	15.681
type	byte

file # command

makedata.do:

130 [+]

egen styr = group(statefip year)

135 [+]

collapse (mean) lnwage lnwage_sy (rawsum) wtsupp [pw=wtsupp] , by(statefip year)

Script Output


statefip:  State (FIPS code)                    Number of Observations
----------------------------                ------------------------------
                                            Total   Integers   Nonintegers
|          #       #         Negative           -         -          -
|      #   #   #   #         Zero               -         -          -
|  #   #   #   #   #         Positive        1836      1836          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total           1836      1836          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1                    56                      1836
  (51 unique values)

      statefip is labeled and all values are documented in the label.

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
    statefip |      1836    28.96078    15.68111          1         56
@mean    28.961
@sd    15.681
@min         1
@max        56
@example0 1
@histh .0228164, .0114082, .0228164, .0228164, .0228164, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0114082, .0228164, .0228164, .0228164, .0228164, .0228164, .0114082, .0114082, .0228164, .0228164
@histw 1.859375, 3.578125, 5.296875, 8.734375, 10.453125, 12.171875, 15.609375, 17.328125, 19.046875, 20.765625, 22.484375, 24.203125, 25.921875, 27.640625, 29.359375, 31.078125, 32.796875, 34.515625, 36.234375, 37.953125, 39.671875, 41.390625, 44.828125, 46.546875, 48.265625, 49.984375, 51.703125, 53.421875, 55.140625
@type byte
@label State (FIPS code)
@class other
@N_unique 51
@N 1836

[+] year
@CPS_panel.dta

other
(int)

1836
(36)

(x̄=1994.500, 10.391) [1977,2012]

Survey year

All properties
key	content
N	1836
N_unique	36
class	other
example0	1977
histh	.05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365
histw	1977.5469, 1978.6406, 1979.7344, 1980.8281, 1981.9219, 1983.0156, 1984.1094, 1985.2031, 1986.2969, 1987.3906, 1988.4844, 1989.5781, 1990.6719, 1991.7656, 1992.8594, 1993.9531, 1995.0469, 1996.1406, 1997.2344, 1998.3281, 1999.4219, 2000.5156, 2001.6094, 2002.7031, 2003.7969, 2004.8906, 2005.9844, 2007.0781, 2008.1719, 2009.2656, 2010.3594, 2011.4531
label	Survey year
max	2012
mean	1994.500
min	1977
sd	10.391
type	int

file # command

makedata.do:

130 [+]

egen styr = group(statefip year)

135 [+]

collapse (mean) lnwage lnwage_sy (rawsum) wtsupp [pw=wtsupp] , by(statefip year)

Script Output


year:  Survey year                              Number of Observations
------------------                          ------------------------------
                                            Total   Integers   Nonintegers
|                  #         Negative           -         -          -
|  #   #   #   #   #         Zero               -         -          -
|  #   #   #   #   #         Positive        1836      1836          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total           1836      1836          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1977               2012                      1836
  (36 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |      1836      1994.5    10.39112       1977       2012
@mean  1994.500
@sd    10.391
@min      1977
@max      2012
@example0 1977
@histh .05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .02539683, .05079365
@histw 1977.5469, 1978.6406, 1979.7344, 1980.8281, 1981.9219, 1983.0156, 1984.1094, 1985.2031, 1986.2969, 1987.3906, 1988.4844, 1989.5781, 1990.6719, 1991.7656, 1992.8594, 1993.9531, 1995.0469, 1996.1406, 1997.2344, 1998.3281, 1999.4219, 2000.5156, 2001.6094, 2002.7031, 2003.7969, 2004.8906, 2005.9844, 2007.0781, 2008.1719, 2009.2656, 2010.3594, 2011.4531
@type int
@label Survey year
@class other
@N_unique 36
@N 1836

Content



>  * A do file to run the standard stats for a whole data set. 
>  *
>  * Note that you must delete the files in the derived directory
>  * for changes to be reflected in the output.
>  *
>  * @version 0.1
> */

Contains data from /Users/mas/Dropbox/Public/cameron/CPS_panel.dta
  obs:         1,836                          
 vars:             5                          5 Jul 2014 11:08
 size:        34,884                          
Sorted by:  statefip  year
@N 1836
@variables 5
  1836:5(80647):2750722809:788198030
@datasignature 1836:5(80647):2750722809:788198030
panel variable not set; use xtset varname ...
.

- - Tokens
    CPS CPS panel dta panel panel dta

CPS_all_micro.dta		makedata.do:138
	→	CPS_panel.dta	↘

File CPS_panel.dta

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens