--------------------------------------------------------------------------------------------
name: <unnamed>
log: C:\Users\Michael\Documents\newer web pages\soc_meth_proj3\soc_180B_win2013\clas
> s3.log
log type: text
opened on: 17 Jan 2013, 13:51:59
. use "C:\Users\Michael\Desktop\cps_mar_2000_new_unchanged.dta", clear
. summarize incwage
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
incwage | 103226 19462.59 28843.38 0 364302
* One thing to notice about incwage is that there are fewer than 133,710 cases. That means some values are missing. Look up the variable in ipums to see why… It turns out that children are not in the universe for the income question.
. tabulate incwage if age <15
no observations
. tabulate incwage if age <15, miss
Wage and |
salary |
income | Freq. Percent Cum.
------------+-----------------------------------
. | 30,484 100.00 100.00
------------+-----------------------------------
Total | 30,484 100.00
* Ordinarily, STATA does not show you missing values in a table, but if you specify the option “miss”, it will show you the missing values and note: the missing value code for numerical variables is the period.
. tabulate citizen
Citizenship status | Freq. Percent Cum.
--------------------------------+-----------------------------------
NIU | 117,310 87.73 87.73
Born abroad of American parents | 976 0.73 88.46
Naturalized citizen | 5,348 4.00 92.46
Not a citizen | 10,076 7.54 100.00
--------------------------------+-----------------------------------
Total | 133,710 100.00
* If we want to work with the variable citizen, we need to know the numerical codes beneath the value labels.
. codebook citizen
------------------------------------------------------------------------------------
citizen Citizenship status
------------------------------------------------------------------------------------
type: numeric (byte)
label: citizenlbl
range: [0,3] units: 1
unique values: 4 missing .: 0/133710
tabulation: Freq. Numeric Label
1.2e+05 0 NIU
976 1 Born abroad of American parents
5348 2 Naturalized citizen
10076 3 Not a citizen
. tabulate citizen, nolab
Citizenship |
status | Freq. Percent Cum.
------------+-----------------------------------
0 | 117,310 87.73 87.73
1 | 976 0.73 88.46
2 | 5,348 4.00 92.46
3 | 10,076 7.54 100.00
------------+-----------------------------------
Total | 133,710 100.00
* And by the way, if we want to know where the citizen=NIU people were born, we can cross-tabulate with bpl.
. tabulate bpl citizen
| Citizenship status
Birthplace | NIU Born abro Naturaliz Not a cit | Total
----------------------+--------------------------------------------+----------
United States, n.s. | 116,213 0 0 0 | 116,213
Puerto Rico | 950 0 0 0 | 950
U.S. outlying areas, | 140 0 0 0 | 140
Canada | 0 102 135 179 | 416
Bermuda | 0 2 0 1 | 3
North America, n.s. | 0 0 4 10 | 14
Mexico | 4 155 1,090 4,294 | 5,543
Belize/British Hondur | 0 0 9 17 | 26
Costa Rica | 0 1 19 33 | 53
El Salvador | 3 13 107 461 | 584
Guatemala | 0 1 45 186 | 232
Honduras | 0 5 42 120 | 167
Nicaragua | 0 5 31 125 | 161
Panama | 0 13 20 20 | 53
Central America, n.s. | 0 3 24 83 | 110
Cuba | 0 5 382 282 | 669
Dominican Republic | 0 6 170 326 | 502
Haiti | 0 0 60 94 | 154
Jamaica | 0 3 85 75 | 163
Bahamas | 0 3 3 4 | 10
Barbados | 0 1 13 10 | 24
Dominica | 0 0 0 4 | 4
Grenada | 0 1 6 9 | 16
Trinidad and Tobago | 0 1 32 41 | 74
Caribbean, n.s. | 0 3 14 18 | 35
Argentina | 0 2 30 28 | 60
Bolivia | 0 0 7 19 | 26
Brazil | 0 3 17 68 | 88
Chile | 0 3 27 26 | 56
Colombia | 0 5 120 193 | 318
Ecuador | 0 3 67 144 | 214
Guyana/British Guiana | 0 1 61 41 | 103
Peru | 0 3 68 152 | 223
Uruguay | 0 0 18 26 | 44
Venezuela | 0 8 26 46 | 80
South America, n.s. | 0 1 19 20 | 40
Denmark | 0 1 4 2 | 7
Finland | 0 1 3 4 | 8
Norway | 0 4 3 7 | 14
Sweden | 0 3 5 17 | 25
England | 0 72 95 124 | 291
Scotland | 0 7 22 16 | 45
United Kingdom, n.s. | 0 2 1 7 | 10
Ireland | 0 4 52 38 | 94
Belgium | 0 5 4 5 | 14
France | 0 26 34 25 | 85
Netherlands | 0 4 24 18 | 46
Switzerland | 0 1 6 8 | 15
Greece | 0 1 44 17 | 62
Italy | 0 25 144 53 | 222
Portugal | 0 4 39 51 | 94
Azores | 0 2 14 5 | 21
Spain | 0 14 25 22 | 61
Austria | 0 2 20 9 | 31
Czechoslavakia | 0 0 14 6 | 20
Slovakia | 0 0 3 0 | 3
Czech Republic | 0 0 6 1 | 7
Germany | 0 234 170 109 | 513
Hungary | 0 0 21 14 | 35
Poland | 0 7 101 96 | 204
Romania | 0 0 22 19 | 41
Yugoslavia | 0 1 18 43 | 62
Latvia | 0 0 4 0 | 4
Lithuania | 0 0 3 15 | 18
Other USSR/Russia | 0 4 62 88 | 154
Ukraine | 0 0 23 37 | 60
USSR, n.s. | 0 0 7 18 | 25
Europe, n.s. | 0 1 8 29 | 38
China | 0 9 169 175 | 353
Hong Kong | 0 3 40 39 | 82
Taiwan | 0 5 60 65 | 130
Japan | 0 36 31 87 | 154
South Korea | 0 38 137 150 | 325
Cambodia | 0 1 15 39 | 55
Indonesia | 0 1 7 14 | 22
Laos | 0 0 16 16 | 32
Malaysia | 0 0 3 14 | 17
Philippines | 0 40 322 221 | 583
Singapore | 0 0 6 3 | 9
Thailand | 0 6 17 44 | 67
Vietnam | 0 5 140 157 | 302
Afghanistan | 0 0 4 8 | 12
India | 0 3 143 239 | 385
Bangladesh | 0 0 18 19 | 37
Burma | 0 0 7 6 | 13
Pakistan | 0 0 28 47 | 75
Iran | 0 1 53 55 | 109
Iraq | 0 0 18 19 | 37
Israel/Palestine | 0 5 15 17 | 37
Palestine | 0 0 10 0 | 10
Jordan | 0 0 8 7 | 15
Lebanon | 0 2 29 15 | 46
Saudi Arabia | 0 1 5 4 | 10
Syria | 0 0 11 4 | 15
Turkey | 0 9 20 26 | 55
Middle East, n.s. | 0 0 2 3 | 5
Armenia | 0 0 5 16 | 21
Asia, n.e.c./n.s. | 0 1 27 24 | 52
Northern Africa | 0 0 1 10 | 11
Egypt/United Arab Rep | 0 0 26 22 | 48
Morocco | 0 1 4 17 | 22
Ghana | 0 0 10 20 | 30
Nigeria | 0 1 9 23 | 33
Ethiopia | 0 0 9 17 | 26
Kenya | 0 0 4 4 | 8
South Africa (Union o | 0 3 14 16 | 33
Africa, n.s./n.e.c. | 0 2 16 49 | 67
Australia | 0 1 1 14 | 16
New Zealand | 0 0 2 6 | 8
Pacific Islands | 0 5 9 19 | 33
Fiji | 0 0 4 6 | 10
Other, n.e.c. and unk | 0 20 121 262 | 403
----------------------+--------------------------------------------+----------
Total | 117,310 976 5,348 10,076 | 133,710
. codebook citizen
------------------------------------------------------------------------------------
citizen Citizenship status
------------------------------------------------------------------------------------
type: numeric (byte)
label: citizenlbl
range: [0,3] units: 1
unique values: 4 missing .: 0/133710
tabulation: Freq. Numeric Label
1.2e+05 0 NIU
976 1 Born abroad of American parents
5348 2 Naturalized citizen
10076 3 Not a citizen
* A quick look at a couple of ways to generate an immigrant variable.
. generate immigrant=0 if citizen==0
(16400 missing values generated)
. replace immigrant=1 if citizen>0
(16400 real changes made)
. drop immigrant
* this version makes more sense to me, where only citizen==2 and citizen==3 are considered immigrants:
. generate immigrant=0 if citizen<2
(15424 missing values generated)
. replace immigrant=1 if citizen >=2
(15424 real changes made)
. tabulate immigrant citizen
| Citizenship status
immigrant | NIU Born abro Naturaliz Not a cit | Total
-----------+--------------------------------------------+----------
0 | 117,310 976 0 0 | 118,286
1 | 0 0 5,348 10,076 | 15,424
-----------+--------------------------------------------+----------
Total | 117,310 976 5,348 10,076 | 133,710
. clear all
. use "C:\Users\Michael\Desktop\cps_mar_2000_new_unchanged.dta", clear
. by citizen: summarize yrsed if age>20 & age<29
not sorted
r(5);
* If you want to use the “by” syntax, you have to sort by those variable(s) first.
. sort citizen
. by citizen: summarize yrsed if age>20 & age<29
------------------------------------------------------------------------------------
-> citizen = NIU
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
yrsed | 10886 13.58451 2.199255 0 17
------------------------------------------------------------------------------------
-> citizen = Born abroad of American parents
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
yrsed | 111 14.08108 2.207982 9 17
------------------------------------------------------------------------------------
-> citizen = Naturalized citizen
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
yrsed | 391 13.38491 2.928998 0 17
------------------------------------------------------------------------------------
-> citizen = Not a citizen
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
yrsed | 2054 11.02872 3.763516 0 17
* Table can do a lot of the things that summarize does.
. table citizen if age >20 & age<29, contents (mean yrsed)
---------------------------------------------
Citizenship status | mean(yrsed)
--------------------------------+------------
NIU | 13.58451
Born abroad of American parents | 14.08108
Naturalized citizen | 13.38491
Not a citizen | 11.02872
---------------------------------------------
. tabulate citizen
Citizenship status | Freq. Percent Cum.
--------------------------------+-----------------------------------
NIU | 117,310 87.73 87.73
Born abroad of American parents | 976 0.73 88.46
Naturalized citizen | 5,348 4.00 92.46
Not a citizen | 10,076 7.54 100.00
--------------------------------+-----------------------------------
Total | 133,710 100.00
. tabulate citizen if yrsed >=12
Citizenship status | Freq. Percent Cum.
--------------------------------+-----------------------------------
NIU | 100,860 90.34 90.34
Born abroad of American parents | 821 0.74 91.08
Naturalized citizen | 3,980 3.56 94.64
Not a citizen | 5,981 5.36 100.00
--------------------------------+-----------------------------------
Total | 111,642 100.00
* Sometimes you need to make 2 tables to get the numerator and the denominator to answer the question, so you can use the “display” function or your own calculator to get the percentage that way.
. display 100860/117310
.85977325
. log close
name: <unnamed>
log: C:\Users\Michael\Documents\newer web pages\soc_meth_proj3\soc_180B_win2
> 013\class3.log
log type: text
closed on: 17 Jan 2013, 16:17:15
------------------------------------------------------------------------------------