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