/*------------------------------------------------------------------------------------*/ /*by Jean Roth Tue Nov 4 11:37:55 EST 2003 This program reads the 1996 SIPP Wave 1x Topical Module Data File NOTE: This program is distributed under the GNU GPL. See end of this file and http://www.gnu.org/licenses/ for details. Please report errors to jroth@nber.org Six steps: (1) Uncomment the 'options compress=yes' statement if desired to save space (2) Uncomment 'LENGTH' statement if desired to save space (3) Specify output directories in 'libname' statements (4) Specify the input file name/location in the 'filename' statement (5) On a PC, use backslashes as in C:\ (6) Read in the compressed or uncompressed raw data file. See the 'filename' and 'INFILE' statements. Other changes may be user and platform specific. NOTE: A value of -1 (or -1/# of implied decimals) indicates 'Not in Universe' */ /*------------------------------------------------------------------------------------*/ *options obs=100; *options compress=yes; *Choose compress=yes to save space ; *Choose compress=no if converting to another package using transfer software ; *options pagesize=59 linesize=72; /*------------------------------------------------------------------------------------*/ libname library './'; *See the codebook for more detail; PROC FORMAT cntlout=library.fsp96t1x; /* The PROC FORMAT statement will store the formats in a sas data set called fsip96t1x To use the stored formats in a subsequent program, include something like this: proc format cntlin=library.fsp96t1x; PROC freq; tables pesex ; format pesex P135L.; For more information, consult the SAS Procedures Guide section of PROC FORMAT */ ; 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" 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" 4 = "Asian or Pacific Islander" ; VALUE EORIGIN (default=32) 1 = "Canadian" 2 = "Dutch" 3 = "English" 4 = "French" 5 = "French-Canadian" 6 = "German" 7 = "Hungarian" 8 = "Irish" 9 = "Italian" 10 = "Polish" 11 = "Russian" 12 = "Scandinavian" 13 = "Scotch-Irish" 14 = "Scottish" 15 = "Slovak" 16 = "Welsh" 17 = "Other European" 20 = "Mexican" 21 = "Mexican-American" 22 = "Chicano" 23 = "Puerto Rican" 24 = "Cuban" 25 = "Central American" 26 = "South American" 27 = "Dominican Republic" 28 = "Other Hispanic" 30 = "African-American or" 31 = "American Indian, Eskimo, or" 32 = "Arab" 33 = "Asian" 34 = "Pacific Islander" 35 = "West Indian" 39 = "Another group not listed" 40 = "American" ; VALUE ERRP (default=32) 1 = "Reference person w/ rel. persons" 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" 8 = "Other relative of reference" 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 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:" 46 = "Professional School Degree (For" 47 = "Doctorate degree (For example:" ; VALUE TCDBEGYR (default=32) -1 = "Not in universe" ; VALUE ACDBEGYR (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE ECDBEGMO (default=32) -1 = "Not in universe" ; VALUE ACDBEGMO (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE EHIALLCV (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE AHIALLCV (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE THINOYR (default=32) -1 = "Not in universe" ; VALUE AHINOYR (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE EHINOMTH (default=32) -1 = "Not in universe" ; VALUE AHINOMTH (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE EHIEVRCV (default=32) -1 = "Not in universe" 1 = "Yes" 2 = "No" ; VALUE AHIEVRCV (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE THICVYR (default=32) -1 = "Not in universe" ; VALUE AHICVYR (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; VALUE EHICVMTH (default=32) -1 = "Not in universe" ; VALUE AHICVMTH (default=32) 0 = "No imputation" 1 = "Statistical imputation (hot" 2 = "Cold deck" 3 = "Logical imputation (derivation)" ; filename raw pipe "unzip -p /homes/data/sipp/1996/sipp96t1x.zip "; data library.sip96t1x; missing A; infile raw lrecl = 20000 missover ; * To read in uncompressed file, uncomment INFILE & comment filename & infile lines; * On a PC, you may need to change the direction of the slashes as in C:\; *INFILE '/homes/data/sipp/1996/sipp96t1x.dat' LRECL=20000 PAD END=EOF; *LENGTH SSUSEQ 4 SSUID $12 SPANEL 4 EPPPNUM $4 WPFINWGT 8 EPNSPOUS 4 EPNMOM 4 EPNDAD 4 EPNGUARD 4 TCDBEGYR 4 THINOYR 4 THICVYR 4 DEFAULT=3; /*-------------------------------------------------------------------------------------*/ /* The following changes in variable names have been made, if necessary: '$' to 'd'; '-' to '_'; '%' to 'p'; Note: Variable names in SAS are not case-sensitive */ /*-------------------------------------------------------------------------------------*/ 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 TCDBEGYR 4. @99 ACDBEGYR 1. @100 ECDBEGMO 2. @102 ACDBEGMO 1. @103 EHIALLCV 2. @105 AHIALLCV 1. @106 THINOYR 4. @110 AHINOYR 1. @111 EHINOMTH 2. @113 AHINOMTH 1. @114 EHIEVRCV 2. @116 AHIEVRCV 1. @117 THICVYR 4. @121 AHICVYR 1. @122 EHICVMTH 2. @124 AHICVMTH 1. ; LABEL SSUSEQ = "SU: Sequence Number of Sample Unit - P" SSUID = "SU: Sample Unit Identifier" SPANEL = "SU: Sample Code - Indicates Panel Year" SWAVE = "SU: Wave of data collection" SROTATON = "SU: Rotation of data collection" TFIPSST = "SU: FIPS State Code for fifth month" SHHADID = "SU: Hhld Address ID in fourth referenc" SINTHHID = "SU: Hhld Address ID of person in inter" EOUTCOME = "HH: Interview Status code for fifth mo" RFID = "FA: Family ID Number in month four" RFID2 = "FA: Family ID excluding related subfam" EPPIDX = "PE: Person index" EENTAID = "PE: Address ID of hhld where person en" EPPPNUM = "PE: Person number" EPOPSTAT = "PE: Population status based on age in " EPPINTVW = "PE: Person's interview status at time " EPPMIS4 = "PE: Person's 4th month interview statu" ESEX = "PE: Sex of this person" ERACE = "PE: Race of this person" EORIGIN = "PE: Origin of this person" WPFINWGT = "WW: Person weight" ERRP = "PE: Household relationship" TAGE = "PE: Age as of last birthday" EMS = "PE: Marital status" EPNSPOUS = "PE: Person number of spouse" EPNMOM = "PE: Person number of mother" EPNDAD = "PE: Person number of father" EPNGUARD = "PE: Person number of guardian" RDESGPNT = "PE: Designated parent or guardian flag" EEDUCATE = "ED: Highest Degree received or grade" TCDBEGYR = "HIR: In what year did ... become cover" ACDBEGYR = "HIR: Allocation flag for TCDBEGYR" ECDBEGMO = "HIR: In what month did ... become cove" ACDBEGMO = "HIR: Allocation flag for ECDBEGMO" EHIALLCV = "HIR: Has ... always been covered by he" AHIALLCV = "HIR: Allocation flag for EHIALLCV" THINOYR = "HIR: In what year was ... last not cov" AHINOYR = "HIR: Allocation flag for THINOYR" EHINOMTH = "HIR: In what month was ... last not co" AHINOMTH = "HIR: Allocation flag for EHINOMTH" EHIEVRCV = "HIR: Has ... ever been covered by heal" AHIEVRCV = "HIR: Allocation flag for EHIEVRCV" THICVYR = "HIR: In what year was ... last covered" AHICVYR = "HIR: Allocation flag for THICVYR" EHICVMTH = "HIR:In what month was ... last covered" AHICVMTH = "HIR: Allocation flag for EHICVMTH" ; proc print data=library.sip96t1x (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. ERRP ERRP. TAGE TAGE. EMS EMS. EPNSPOUS EPNSPOUS. EPNMOM EPNMOM. EPNDAD EPNDAD. EPNGUARD EPNGUARD. RDESGPNT RDESGPNT. EEDUCATE EEDUCATE. TCDBEGYR TCDBEGYR. ACDBEGYR ACDBEGYR. ECDBEGMO ECDBEGMO. ACDBEGMO ACDBEGMO. EHIALLCV EHIALLCV. AHIALLCV AHIALLCV. THINOYR THINOYR. AHINOYR AHINOYR. EHINOMTH EHINOMTH. AHINOMTH AHINOMTH. EHIEVRCV EHIEVRCV. AHIEVRCV AHIEVRCV. THICVYR THICVYR. AHICVYR AHICVYR. EHICVMTH EHICVMTH. AHICVMTH AHICVMTH. ; proc contents data=library.sip96t1x; /* Copyright 2003 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. */