*options obs=100 ; options nocenter ; **------------------------------------------------; ** by Jean Roth Wed Jan 29 17:47:30 EST 2014 ** This program reads the 2008 SIPP Wave 13 Topical Module Data File ; ** Report errors to jroth@nber.org ; ** A value of -1 (or -1/# of implied decimals) indicates 'Not in Universe' ; ** This program is distributed under the GNU GPL. ; ** See end of this file and ** http://www.gnu.org/licenses/ for details. ; **-----------------------------------------------; * The following line should contain the directory where the SAS file is to be stored ; libname library "/homes/data/sipp/2008"; * The following line should contain the complete path and name of the raw data file. On a PC, use backslashes in paths as in C:\ ; FILENAME datafile pipe "unzip -p /homes/data/sipp/2008/p08putm13.zip "; * The following line should contain the name of the SAS dataset ; %let dataset = sippp08putm13 ; DATA library.&dataset ; INFILE datafile LRECL = 20000 ; ** ------------------------------------------------ ; ** The following variable names have been changed, ; ** if necessary: '$' to 'd', '-' to '_', '%' to 'p' ; ** ----------------------------------------------- ; attrib ssuseq length=4 label="SU: Sequence Number of Sample Unit - Primary"; attrib ssuid length=$12 label="SU: Sample Unit Identifier"; attrib spanel length=4 label="SU: Sample Code - Indicates Panel Year"; attrib swave length=3 label="SU: Wave of data collection"; attrib srotaton length=3 label="SU: Rotation of data collection"; attrib tfipsst length=3 label="HH: FIPS State Code"; attrib shhadid length=3 label="SU: Hhld Address ID differentiates hhlds in"; attrib eoutcome length=3 label="HH: Interview Status code for this household"; attrib rfid length=3 label="FA: Family ID Number for this month"; attrib rfid2 length=3 label="FA: Family ID excluding related subfamily"; attrib eppidx length=3 label="PE: Person index"; attrib eentaid length=$3 label="PE: Address ID of hhld where person entered"; attrib epppnum length=$4 label="PE: Person number"; attrib epopstat length=3 label="PE: Population status based on age in 4th"; attrib eppintvw length=3 label="PE: Person's interview status"; attrib eppmis4 length=3 label="PE: Person's 4th month interview status"; attrib esex length=3 label="PE: Sex of this person"; attrib erace length=3 label="PE: The race(s) the respondent is"; attrib eorigin length=3 label="PE: Spanish, Hispanic or Latino"; attrib wpfinwgt length=8 label="WW: Person weight"; attrib errp length=3 label="PE: Household relationship"; attrib tage length=3 label="PE: Age as of last birthday"; attrib ems length=3 label="PE: Marital status"; attrib epnspous length=4 label="PE: Person number of spouse"; attrib epnmom length=4 label="PE: Person number of mother"; attrib epndad length=4 label="PE: Person number of father"; attrib epnguard length=4 label="PE: Person number of guardian"; attrib rdesgpnt length=3 label="PE: Designated parent or guardian flag"; attrib eeducate length=3 label="ED: Highest Degree received or grade completed"; attrib lgtkey length=$8 label="PE: Person longitudinal key"; attrib sinthhid length=3 label="SU: Hhld Address ID of person in interview"; attrib eaecunv length=3 label="AEC: Universe indicator."; attrib iprocert length=3 label="AEC: Have a professional or state or industry"; attrib iwhopcer length=3 label="AEC: Who awarded this certification or license"; attrib iwhypcer length=3 label="AEC: Mainly for work-related or personal"; attrib ifldpcer length=3 label="AEC: Major subject or field of study"; attrib ijobpcer length=3 label="AEC: Can cert be used to get a job"; attrib irjpcert length=3 label="AEC: Is certification or license required"; attrib itrnpcer length=3 label="AEC: Take course or training to earn cert or"; attrib iexpcert length=3 label="AEC: Demo skills take test or exam to earn"; attrib icdpcert length=3 label="AEC: Take test or class or earn CEUs"; attrib icert length=3 label="AEC: Ever earned this type of certificate"; attrib ifldcert length=3 label="AEC: MOST RECENT completed certificate"; attrib ischcert length=3 label="AEC: Type of school or organization"; attrib isdycert length=3 label="AEC: Mainly self-study or classes or course"; attrib itimcert length=3 label="AEC: How long to earn certificate"; INPUT @1 ssuseq 5. @6 ssuid $12. @18 spanel 4. @22 swave 2. @24 srotaton 1. @25 tfipsst 2. @27 shhadid 3. @30 eoutcome 3. @33 rfid 3. @36 rfid2 3. @39 eppidx 3. @42 eentaid $3. @45 epppnum $4. @49 epopstat 1. @50 eppintvw 2. @52 eppmis4 1. @53 esex 1. @54 erace 1. @55 eorigin 2. @57 wpfinwgt 10.4 @67 errp 2. @69 tage 2. @71 ems 1. @72 epnspous 4. @76 epnmom 4. @80 epndad 4. @84 epnguard 4. @88 rdesgpnt 2. @90 eeducate 2. @92 lgtkey $8. @100 sinthhid 3. @103 eaecunv 2. @105 iprocert 2. @107 iwhopcer 2. @109 iwhypcer 2. @111 ifldpcer 2. @113 ijobpcer 2. @115 irjpcert 2. @117 itrnpcer 2. @119 iexpcert 2. @121 icdpcert 2. @123 icert 2. @125 ifldcert 2. @127 ischcert 2. @129 isdycert 2. @131 itimcert 2. ; **------------------------------------------------; ** The PROC FORMAT statement will store the formats ; ** in a sas data set called fsippp08putm13 ; ** To use the stored formats in a subsequent program, ; ** use code like the following; ** proc format cntlin=library.fsppp08putm13; ** PROC freq; ** tables pesex ; ** format pesex P135L.; ** For more information, consult PROC FORMAT in the SAS Procedures Guide ; **-----------------------------------------------; PROC FORMAT cntlout=library.fsppp08putm13; ; VALUE spanel (default=32) 2008 = "Panel Year" ; VALUE tfipsst (default=32) 1 = "Alabama" 2 = "Alaska" 4 = "Arizona" 5 = "Arkansas" 6 = "California" 8 = "Colorado" 9 = "Connecticut" 10 = "Delaware" 11 = "DC" 12 = "Florida" 13 = "Georgia" 15 = "Hawaii" 16 = "Idaho" 17 = "Illinois" 18 = "Indiana" 19 = "Iowa" 20 = "Kansas" 21 = "Kentucky" 22 = "Louisiana" 23 = "Maine" 24 = "Maryland" 25 = "Massachusetts" 26 = "Michigan" 27 = "Minnesota" 28 = "Mississippi" 29 = "Missouri" 30 = "Montana" 31 = "Nebraska" 32 = "Nevada" 33 = "New Hampshire" 34 = "New Jersey" 35 = "New Mexico" 36 = "New York" 37 = "North Carolina" 38 = "North Dakota" 39 = "Ohio" 40 = "Oklahoma" 41 = "Oregon" 42 = "Pennsylvania" 44 = "Rhode Island" 45 = "South Carolina" 46 = "South Dakota" 47 = "Tennessee" 48 = "Texas" 49 = "Utah" 50 = "Vermont" 51 = "Virginia" 53 = "Washington" 54 = "West Virginia" 55 = "Wisconsin" 56 = "Wyoming" ; VALUE eoutcome (default=32) 201 = "Completed interview" 203 = "Compl. partial- missing data; no" 207 = "Complete partial - TYPE-Z; no" 213 = "TYPE-A, language problem" 216 = "TYPE-A, no one home (noh)" 217 = "TYPE-A, temporarily absent (ta)" 218 = "TYPE-A, hh refused" 219 = "TYPE-A, other occupied (specify)" 234 = "TYPE-B, entire hh institut. or" 248 = "TYPE-C, other (specify)" 249 = "TYPE-C, sample adjustment" 250 = "TYPE-C, hh deceased" 251 = "TYPE-C, moved out of country" 252 = "TYPE-C, living in armed forces" 253 = "TYPE-C, on active duty in Armed" 254 = "TYPE-C, no one over age 15 years" 255 = "TYPE-C, no Wave 1 persons" 260 = "TYPE-D, moved address unknown" 261 = "TYPE-D, moved within U.S. but" 262 = "TYPE-C, merged with another SIPP" 270 = "TYPE-C, mover, no longer located" 271 = "TYPE-C, mover, new address" 280 = "TYPE-D, mover, no longer located" ; VALUE rfid2l (default=32) -1 = "Not in Universe" ; VALUE epopstat (default=32) 1 = "Adult (15 years of age or older)" 2 = "Child (Under 15 years of age)" ; VALUE eppintvw (default=32) 1 = "Interview (self)" 2 = "Interview (proxy)" 3 = "Noninterview - Type Z" 4 = "Noninterview - pseudo Type Z." 5 = "Children under 15 during" ; VALUE eppmis4l (default=32) 1 = "Interview" 2 = "Non-interview" ; VALUE esex (default=32) 1 = "Male" 2 = "Female" ; VALUE erace (default=32) 1 = "White alone" 2 = "Black alone" 3 = "Asian alone" 4 = "Residual" ; VALUE eorigin (default=32) 1 = "Yes" 2 = "No" ; VALUE errp (default=32) 1 = "Reference person with related" 2 = "Reference Person without related" 3 = "Spouse of reference person" 4 = "Child of reference person" 5 = "Grandchild of reference person" 6 = "Parent of reference person" 7 = "Brother/sister of reference person" 8 = "Other relative of reference person" 9 = "Foster child of reference person" 10 = "Unmarried partner of reference" 11 = "Housemate/roommate" 12 = "Roomer/boarder" 13 = "Other non-relative of reference" ; VALUE tage (default=32) 0 = "Less than 1 full year old" ; VALUE ems (default=32) 1 = "Married, spouse present" 2 = "Married, spouse absent" 3 = "Widowed" 4 = "Divorced" 5 = "Separated" 6 = "Never Married" ; VALUE epnspous (default=32) 9999 = "Spouse not in household or person" ; VALUE epnmom (default=32) 9999 = "No mother in household" ; VALUE epndad (default=32) 9999 = "No father in household" ; VALUE epnguard (default=32) -1 = "Not in Universe" 9999 = "Guardian not in household" ; VALUE rdesgpnt (default=32) -1 = "Not in Universe" 1 = "Yes" 2 = "No" ; VALUE eeducate (default=32) -1 = "Not in Universe" 31 = "Less Than 1st Grade" 32 = "1st, 2nd, 3rd or 4th grade" 33 = "5th Or 6th Grade" 34 = "7th Or 8th Grade" 35 = "9th Grade" 36 = "10th Grade" 37 = "11th Grade" 38 = "12th grade, no diploma" 39 = "High School Graduate - (diploma" 40 = "Some college, but no degree" 41 = "Diploma or certificate from a" 43 = "Associate (2-yr) college degree" 44 = "Bachelor's degree (for example:" 45 = "Master's degree (For example: MA," 46 = "Professional School degree (for" 47 = "Doctorate degree (for example:" ; VALUE sinthhid (default=32) 0 = "Not In Universe" ; VALUE eaecunv (default=32) -1 = "Not in Universe" 1 = "In universe" ; VALUE iprocert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE iwhopcer (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Federal government" 2 = "State government" 3 = "Local government" 4 = "Industry" 5 = "Business, company, or non-profit" 6 = "Professional Association" 7 = "Other" ; VALUE iwhypcer (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Mainly work-related" 2 = "Mainly personal interest" ; VALUE ifldpcer (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Architecture and engineering" 2 = "Computer networking and" 3 = "Computer applications and design" 4 = "Business/finance management" 5 = "Administrative support" 6 = "Nursing/nurse assisting" 7 = "Other medical/health care" 8 = "Cosmetology" 9 = "Culinary arts" 10 = "Protective services" 11 = "Legal and social services" 12 = "Education" 13 = "Construction and manufacturing" 14 = "Transportation and material moving" 15 = "Public utilities" 16 = "Other" ; VALUE ijobpcer (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE irjpcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" 3 = "Not applicable(never worked)" ; VALUE itrnpcer (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE iexpcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE icdpcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE icert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Yes" 2 = "No" ; VALUE ifldcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Architecture and engineering" 2 = "Communications" 3 = "Computer and information sciences" 4 = "Engineering and related" 5 = "Business management" 6 = "Business support" 7 = "Marketing" 8 = "Health professions, except nursing" 9 = "Nursing" 10 = "Health technologists and" 11 = "Health aides" 12 = "Cosmetology" 13 = "Culinary arts" 14 = "Personal services(other than" 15 = "Protective services" 16 = "Public and social services(other" 17 = "Education" 18 = "Construction trades" 19 = "Manufacturing" 20 = "Mechanic and repair technologies" 21 = "Transportation and material moving" 22 = "OTHER" ; VALUE ischcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "A community college" 2 = "A university or college other" 3 = "A trade, vocational, technical," 4 = "Business or company" 5 = "Professional organization" 6 = "Trade union" 7 = "Non-profit organization" 8 = "Federal, state, or local" 9 = "Military" 10 = "Someplace else" ; VALUE isdycert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Mainly self-study" 2 = "Mainly Instructor" ; VALUE itimcert (default=32) -2 = "Refused" -1 = "Don't know" 0 = "Not answered" 1 = "Less than one week" 2 = "One week to one month" 3 = "More than one month" ; proc print data=library.sippp08putm13 (obs=6); FORMAT spanel spanel. tfipsst tfipsst. eoutcome eoutcome. rfid2 rfid2l. epopstat epopstat. eppintvw eppintvw. eppmis4 eppmis4l. esex esex. erace erace. eorigin eorigin. errp errp. tage tage. ems ems. epnspous epnspous. epnmom epnmom. epndad epndad. epnguard epnguard. rdesgpnt rdesgpnt. eeducate eeducate. sinthhid sinthhid. eaecunv eaecunv. iprocert iprocert. iwhopcer iwhopcer. iwhypcer iwhypcer. ifldpcer ifldpcer. ijobpcer ijobpcer. irjpcert irjpcert. itrnpcer itrnpcer. iexpcert iexpcert. icdpcert icdpcert. icert icert. ifldcert ifldcert. ischcert ischcert. isdycert isdycert. itimcert itimcert. ; proc contents data=library.sippp08putm13; run; ** Copyright 2014 shared by the National Bureau of Economic Research and Jean Roth ; ** National Bureau of Economic Research. ; ** 1050 Massachusetts Avenue ; ** Cambridge, MA 02138 ; ** jroth@nber.org ; ** This program and all programs referenced in it are free software. You ; ** can redistribute the program or modify it under the terms of the GNU ; ** General Public License as published by the Free Software Foundation; ** either version 2 of the License, or (at your option) any later version. ; ** This program is distributed in the hope that it will be useful, ; ** but WITHOUT ANY WARRANTY, without even the implied warranty of ; ** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ; ** GNU General Public License for more details. ; ** You should have received a copy of the GNU General Public License ; ** along with this program, if not, write to the Free Software ; ** Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. ;