*options obs=100 ; options nocenter ; /*------------------------------------------------ by Jean Roth Mon Apr 10 14:11:24 EDT 2006 This program reads the 2004 SIPP Wave 1 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 "./"; * 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/2004/sipp04t1.zip "; * The following line should contain the name of the SAS dataset ; %let dataset = sip04t1 ; 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="SU: FIPS State Code for fifth month household"; attrib shhadid length=3 label="SU: Hhld Address ID in fourth reference month"; attrib sinthhid length=3 label="SU: Hhld Address ID of person in interview"; attrib eoutcome length=3 label="HH: Interview Status code for fifth month"; attrib rfid length=3 label="FA: Family ID Number in month four"; 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 fourth"; attrib eppintvw length=3 label="PE: Person's interview status at time of"; 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: Race of this person"; attrib eorigin length=3 label="PE: Origin of this person"; 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 earcunv length=3 label="REC: Universe indicator."; attrib ecurafdc length=3 label="REC: Any other time authorized to recieve"; attrib acurafdc length=3 label="REC: Allocation flag for ECURAFDC"; attrib eevrgard length=3 label="REC: Has ... ever had a child or served as a"; attrib avergard length=3 label="REC: Allocation flag for EEVRGARD"; attrib eaplafdc length=3 label="REC: Ever applied for AFDC, TANF, or State"; attrib aaplafdc length=3 label="REC: Allocation flag for EAPLAFDC"; attrib ercvafdc length=3 label="REC: Authorized to receive AFDC, TANF, or"; attrib arcvafdc length=3 label="REC: Allocation flag for ERCVAFDC"; attrib tafdcsty length=4 label="REC: Year 1st received AFDC, TANF, or State"; attrib aafdcsty length=3 label="REC: Allocation flag for TAFDCSTY"; attrib tafdcly length=4 label="REC: Year last received AFDC, TANF, or State"; attrib aafdcly length=3 label="REC: Allocation flag for TAFDCLY"; attrib tafdctim length=3 label="REC: Number of times received AFDC, TANF, or"; attrib aafdctim length=3 label="REC: Allocation flag for TAFDCTIM"; attrib ecurssi length=3 label="REC: Any other time authorized to recieve SSI"; attrib acurssi length=3 label="REC: Allocation flag for ECURSSI"; attrib eaplssi length=3 label="REC: Ever applied for SSI program"; attrib aaplssi length=3 label="REC: Ever applied for SSI allocation flag"; attrib erecvssi length=3 label="REC: Authorized to receive SSI"; attrib arecvssi length=3 label="REC: Authorized to receive SSI allocation flag"; attrib tssistry length=4 label="REC: Year first received SSI benefits"; attrib assistry length=3 label="REC: Allocation flag for TSSISTRY"; attrib tssily length=4 label="REC: Length of time received SSI(years)"; attrib assily length=3 label="REC: Allocation flag for TSSILY"; attrib ecurfs length=3 label="REC: Other Times When Authorized to Receive"; attrib acurfs length=3 label="REC: Allocation flag for ECURFS"; attrib eaplfs length=3 label="REC: Ever applied for Food Stamp Program"; attrib aaplfs length=3 label="REC: Allocation flag for EAPLFS"; attrib erecvfs length=3 label="REC: Authorized to receive Food Stamps"; attrib arecvfs length=3 label="REC: Allocation flag for ERECVFS"; attrib tfsstryr length=4 label="REC: Year first received food stamp"; attrib afsstryr length=3 label="REC: Allocation flag for TFSSTRYR"; attrib tfsly length=4 label="REC: Length of time received food stamp(years)"; attrib afsly length=3 label="REC: Allocation flag for TFSLY"; attrib tfstimes length=3 label="REC: Number of separate times go on food"; attrib afstimes length=3 label="REC: Allocation flag for TFSTIMES"; INPUT @1 ssuseq 5. @6 ssuid $12. @18 spanel 4. @22 swave 2. @24 srotaton 1. @25 tfipsst 2. @27 shhadid 3. @30 sinthhid 3. @33 eoutcome 3. @36 rfid 3. @39 rfid2 3. @42 eppidx 3. @45 eentaid $3. @48 epppnum $4. @52 epopstat 1. @53 eppintvw 2. @55 eppmis4 1. @56 esex 1. @57 erace 1. @58 eorigin 2. @60 wpfinwgt 10.4 @70 errp 2. @72 tage 2. @74 ems 1. @75 epnspous 4. @79 epnmom 4. @83 epndad 4. @87 epnguard 4. @91 rdesgpnt 2. @93 eeducate 2. @95 lgtkey $8. @103 earcunv 2. @105 ecurafdc 2. @107 acurafdc 1. @108 eevrgard 2. @110 avergard 1. @111 eaplafdc 2. @113 aaplafdc 1. @114 ercvafdc 2. @116 arcvafdc 1. @117 tafdcsty 4. @121 aafdcsty 1. @122 tafdcly 4. @126 aafdcly 1. @127 tafdctim 2. @129 aafdctim 1. @130 ecurssi 2. @132 acurssi 1. @133 eaplssi 2. @135 aaplssi 1. @136 erecvssi 2. @138 arecvssi 1. @139 tssistry 4. @143 assistry 1. @144 tssily 4. @148 assily 1. @149 ecurfs 2. @151 acurfs 1. @152 eaplfs 2. @154 aaplfs 1. @155 erecvfs 2. @157 arecvfs 1. @158 tfsstryr 4. @162 afsstryr 1. @163 tfsly 4. @167 afsly 1. @168 tfstimes 2. @170 afstimes 1. ; /*------------------------------------------------ The PROC FORMAT statement will store the formats in a sas data set called fsip04t1 To use the stored formats in a subsequent program, use code like the following: proc format cntlin=library.fsp04t1; PROC freq; tables pesex ; format pesex P135L.; For more information, consult PROC FORMAT in the SAS Procedures Guide ----------------------------------------------- */ PROC FORMAT cntlout=library.fsp04t1; ; VALUE spanel (default=32) 1996 = "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" 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" 39 = "Ohio" 40 = "Oklahoma" 41 = "Oregon" 42 = "Pennsylvania" 44 = "Rhode Island" 45 = "South Carolina" 47 = "Tennessee" 48 = "Texas" 49 = "Utah" 51 = "Virginia" 53 = "Washington" 54 = "West Virginia" 55 = "Wisconsin" 61 = "Maine, Vermont" 62 = "North Dakota, South Dakota," ; VALUE sinthhid (default=32) 0 = "Not in universe" ; VALUE eoutcome (default=32) 201 = "Completed interview" 203 = "Compl. partial- missing data; no" 207 = "Complete partial - TYPE-Z; no" 213 = "TYPE-A, language problem" 215 = "TYPE-A, insufficient partial" 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 w/in U.S. but" 262 = "Merged with another SIPP household" 270 = "Mover, no longer located in same" 271 = "Mover, new address located in" 280 = "Newly spawned case outside fr's" ; VALUE rfid2l (default=32) 0 = "Member of related subfamily" ; 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 = "Nonintrvw - pseudo Type Z. Left" 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" 2 = "Black" 3 = "American Indian, Aleut, or Eskimo" 4 = "Asian or Pacific Islander" ; VALUE eorigin (default=32) 1 = "Canadian" 10 = "Polish" 11 = "Russian" 12 = "Scandinavian" 13 = "Scotch-Irish" 14 = "Scottish" 15 = "Slovak" 16 = "Welsh" 17 = "Other European" 2 = "Dutch" 20 = "Mexican" 21 = "Mexican-American" 22 = "Chicano" 23 = "Puerto Rican" 24 = "Cuban" 25 = "Central American" 26 = "South American" 27 = "Dominican Republic" 28 = "Other Hispanic" 3 = "English" 30 = "African-American or Afro-American" 31 = "American Indian, Eskimo, or Aleut" 32 = "Arab" 33 = "Asian" 34 = "Pacific Islander" 35 = "West Indian" 39 = "Another group not listed" 4 = "French" 40 = "American" 5 = "French-Canadian" 6 = "German" 7 = "Hungarian" 8 = "Irish" 9 = "Italian" ; VALUE wpfinwgt (default=32) 0 = "0000:999999.9999 .Final person weight" ; VALUE errp (default=32) 1 = "Reference person w/ rel. persons" 10 = "Unmarried partner of reference" 11 = "Housemate/roommate" 12 = "Roomer/boarder" 13 = "Other non-relative of reference" 2 = "Reference Person w/out rel." 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" ; 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 hhld or person not" ; 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" 39 = "High school graduate - high" 40 = "Some college but no degree" 41 = "Diploma or certificate from a" 42 = "Associate degree in college -" 43 = "Associate Degree in college -" 44 = "Bachelors degree (For example:" 45 = "Master's degree (For example: MA," 46 = "Professional School Degree (For" 47 = "Doctorate degree (For example:" ; VALUE earcunv (default=32) 1 = "In universe" -1 = "Not in universe" ; VALUE ecurafdc (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE acurafdc (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE eevrgard (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE avergard (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE eaplafdc (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE aaplafdc (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE ercvafdc (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE arcvafdc (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tafdcsty (default=32) -1 = "Not in universe" ; VALUE aafdcsty (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tafdcly (default=32) -1 = "Not in universe" ; VALUE aafdcly (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tafdctim (default=32) 1 = "One time on ADFC/TANF" 2 = "Two times on ADFC/TANF" 3 = "Three or more times on ADFC/TANF" -1 = "Not in universe" ; VALUE aafdctim (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE ecurssi (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE acurssi (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE eaplssi (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE aaplssi (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE erecvssi (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE arecvssi (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tssistry (default=32) -1 = "Not in universe" ; VALUE assistry (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tssily (default=32) -1 = "Not in universe" ; VALUE assily (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE ecurfs (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE acurfs (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE eaplfs (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE aaplfs (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE erecvfs (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE arecvfs (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tfsstryr (default=32) -1 = "Not in universe" ; VALUE afsstryr (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tfsly (default=32) -1 = "Not in universe" ; VALUE afsly (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; VALUE tfstimes (default=32) 1 = "One time on food stamps" 2 = "Two times on food stamps" 3 = "Three or more times on food stamps" -1 = "Not in universe" ; VALUE afstimes (default=32) 0 = "Not imputed" 1 = "Statistical imputation (hot deck)" 2 = "Cold deck imputation" 3 = "Logical imputation (derivation)" ; proc print data=library.sip04t1 (obs=6); FORMAT spanel spanel. tfipsst tfipsst. sinthhid sinthhid. eoutcome eoutcome. rfid2 rfid2l. epopstat epopstat. eppintvw eppintvw. eppmis4 eppmis4l. esex esex. erace erace. eorigin eorigin. wpfinwgt wpfinwgt. errp errp. tage tage. ems ems. epnspous epnspous. epnmom epnmom. epndad epndad. epnguard epnguard. rdesgpnt rdesgpnt. eeducate eeducate. earcunv earcunv. ecurafdc ecurafdc. acurafdc acurafdc. eevrgard eevrgard. avergard avergard. eaplafdc eaplafdc. aaplafdc aaplafdc. ercvafdc ercvafdc. arcvafdc arcvafdc. tafdcsty tafdcsty. aafdcsty aafdcsty. tafdcly tafdcly. aafdcly aafdcly. tafdctim tafdctim. aafdctim aafdctim. ecurssi ecurssi. acurssi acurssi. eaplssi eaplssi. aaplssi aaplssi. erecvssi erecvssi. arecvssi arecvssi. tssistry tssistry. assistry assistry. tssily tssily. assily assily. ecurfs ecurfs. acurfs acurfs. eaplfs eaplfs. aaplfs aaplfs. erecvfs erecvfs. arecvfs arecvfs. tfsstryr tfsstryr. afsstryr afsstryr. tfsly tfsly. afsly afsly. tfstimes tfstimes. afstimes afstimes. ; proc contents data=library.sip04t1; run; /* Copyright 2006 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. */