Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138

Used PUMS-ACS Data

Data Transformation

1. Recoded Educational Attainment Variable (SCHL) into (attain) see syntax

2. Limit to age group 24 to 65 (AGEP)

3. recode race variable (rac1p) into white, black and other, then I said anyone who answered (HISP) hispanic were hispanic on new variable (race)

4. recode state variable to 2 Letter state abbreviation

Data Analysis

used pwgtp weight

ran for Missouri only and for each state

cross attainment by race, sex

SAS SYNTAX for 2007 file for 1A1

options nocenter pagesize=32767 linesize=256;

data pums;

set '/data/cbhe/home/Jeffrey/PUMS/2007/psam_pusa.sas7bdat' '/data/cbhe/home/Jeffrey/PUMS/2007/psam_pusb.sas7bdat';

*limit age;

*if (AGEP>24 and AGEP<65);

if (AGEP>17 and AGEP<25);

*recode educational attainment;

if schl in ('bb','01','02','03','04','05','06','07','08') then attain='< than HS';

if schl in ('09','10','11') then attain='HS diploma';

if schl in ('12') then attain='assoc';

if schl in ('13') then attain='bachelor';

if schl in ('14','15','16') then attain='graduate/prof';

if attain='' then attain='missing';

*recode racial categories;

if hisp='01' then hispanic='0';

if hisp in ('02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24') then hispanic='1';

if rac1p='1' then race='white';

if rac1p='2' then race='black';

if rac1p in ('3', '4','5','6','7','8','9') then race='other';

if hispanic='1' then race='hispanic';

if st= '01' then st= 'AL';

if st= '02' then st= 'AK';

if st= '04' then st= 'AZ';

if st= '05' then st= 'AR';

if st= '06' then st= 'CA';

if st= '08' then st= 'CO';

if st= '09' then st= 'CT';

if st= '10' then st= 'DE';

if st= '12' then st= 'FL';

if st= '13' then st= 'GA';

if st= '15' then st= 'HI';

if st= '16' then st= 'ID';

if st= '17' then st= 'IL';

if st= '18' then st= 'IN';

if st= '19' then st= 'IA';

if st= '20' then st= 'KS';

if st= '21' then st= 'KY';

if st= '22' then st= 'LA';

if st= '23' then st= 'ME';

if st= '24' then st= 'MD';

if st= '25' then st= 'MA';

if st= '26' then st= 'MI';

if st= '27' then st= 'MN';

if st= '28' then st= 'MS';

if st= '29' then st= 'MO';

if st= '30' then st= 'MT';

if st= '31' then st= 'NE';

if st= '32' then st= 'NV';

if st= '33' then st= 'NH';

if st= '34' then st= 'NJ';

if st= '35' then st= 'NM';

if st= '36' then st= 'NY';

if st= '37' then st= 'NC';

if st= '38' then st= 'ND';

if st= '39' then st= 'OH';

if st= '40' then st= 'OK';

if st= '41' then st= 'OR';

if st= '42' then st= 'PA';

if st= '44' then st= 'RI';

if st= '45' then st= 'SC';

if st= '46' then st= 'SD';

if st= '47' then st= 'TN';

if st= '48' then st= 'TX';

if st= '49' then st= 'UT';

if st= '50' then st= 'VT';

if st= '51' then st= 'VA';

if st= '53' then st= 'WA';

if st= '54' then st= 'WV';

if st= '55' then st= 'WI';

if st= '56' then st= 'WY';

*******************************************************************************************************************************************;

ODS HTML FILE = '/data/cbhe/home/Jeffrey/ifc/ifc1A1.xls' style=minimal;

*attainment by state;

proc freq;

weight pwgtp;

tables st*attain /nopercent norow nocol;

*attainment by demographics;

proc freq;

weight pwgtp;

tables attain attain*race attain*sex/nopercent norow nocol;

*attainment by demographics for MO;

proc freq;

where ST='MO';

weight pwgtp;

tables attain attain*race attain*sex/nopercent norow nocol;

*attainment by demographics for MO;

proc freq;

where ST='MO';

tables attain attain*race attain*sex/nopercent norow nocol;

RUN;

ODS HTML close;

*******************************************************************************************************************************************;

*data pums02;

*set '/data/cbhe/home/Jeffrey/PUMS/2002/pums2002.sas7bdat';

methodology

SAS 02

SAS 07

US TABLES

MO Demo

Old 2006 Map

CD 25_64

CD over 25