| |
|
| 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'; |
|
| |
|