/*------------------------------------------------------------------------------------*/ /*by Jean Roth Thu Mar 18 11:54:16 EST 2004 This program reads the 1993 SIPP Wave 5 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.fsp93t5; /* The PROC FORMAT statement will store the formats in a sas data set called fsip93t5 To use the stored formats in a subsequent program, include something like this: proc format cntlin=library.fsp93t5; PROC freq; tables pesex ; format pesex P135L.; For more information, consult the SAS Procedures Guide section of PROC FORMAT */ ; VALUE ROTATION (default=32) 1 = "Interview month: September 1994" 2 = "Interview month: June 1994" 3 = "Interview month: July 1994" 4 = "Interview month: August 1994" ; VALUE STATE (default=32) 1 = "Alabama" 4 = "Arizona" 5 = "Arkansas" 6 = "California" 8 = "Colorado" 9 = "Connecticut" 10 = "Delaware" 11 = "District Of Columbia" 12 = "Florida" 13 = "Georgia" 15 = "Hawaii" 17 = "Illinois" 18 = "Indiana" 20 = "Kansas" 21 = "Kentucky" 22 = "Louisiana" 24 = "Maryland" 25 = "Massachusetts" 26 = "Michigan" 27 = "Minnesota" 28 = "Mississippi" 29 = "Missouri" 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 = "Iowa, North Dakota, South Dakota" 63 = "Alaska, Idaho, Montana, Wyoming" ; VALUE ITEM36B (default=32) 1 = "Interviewed" 2 = "No one home" 3 = "Temporarily absent" 4 = "Refused" 5 = "Unable to locate" 6 = "Other Type A" 23 = "Entire household deceased," 24 = "Moved, address unknown" 25 = "Moved within country beyond" 26 = "All sample persons relisted on" ; VALUE INTVW (default=32) 0 = "Not applicable (children" 1 = "Interview (self)" 2 = "Interview (proxy)" 3 = "Noninterview - Type Z refusal" 4 = "Noninterview - Type Z other" ; VALUE PPMIS1L (default=32) 1 = "Interview" 2 = "Noninterview" ; VALUE PPMIS2L (default=32) 1 = "Interview" 2 = "Noninterview" ; VALUE PPMIS3L (default=32) 1 = "Interview" 2 = "Non-interview" ; VALUE PPMIS4L (default=32) 1 = "Interview" 2 = "Non-interview" ; VALUE PPMIS5L (default=32) 1 = "Interview" 2 = "Non-interview" ; VALUE RRP (default=32) 0 = "Not a sample person in this" 1 = "Household reference person," 2 = "Household reference person" 3 = "Spouse of household reference" 4 = "Child of household reference" 5 = "Other relative of household" 6 = "Non-relative of household" 7 = "Non-relative of household" ; VALUE AGE (default=32) 0 = "Less than 1 full year" 1 = "1 year" ; VALUE SEX (default=32) 1 = "Male" 2 = "Female" ; VALUE RACE (default=32) 1 = "White" 2 = "Black" 3 = "American Indian, Eskimo or Aleut" 4 = "Asian or Pacific Islander" ; VALUE MS (default=32) 0 = "Not applicable or not a sample" 1 = "Married, spouse present" 2 = "Married, spouse absent" 3 = "Widowed" 4 = "Divorced" 5 = "Separated" 6 = "Never married" ; VALUE PNSP (default=32) 0 = "Not a sample person in this" 999 = "Not applicable" ; VALUE PNPT (default=32) 0 = "Not a sample person in this" 999 = "Not applicable" ; VALUE HIGRADE (default=32) 0 = "Not applicable if under 15," ; VALUE GRDCMPL (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE ETHNICTY (default=32) 1 = "German" 2 = "English" 3 = "Irish" 4 = "French" 5 = "Italian" 6 = "Scottish" 7 = "Polish" 8 = "Dutch" 9 = "Swedish" 10 = "Norwegian" 11 = "Russian" 12 = "Ukrainian" 13 = "Welsh" 14 = "Mexican-American" 15 = "Chicano" 16 = "Mexican" 17 = "Puerto Rican" 18 = "Cuban" 19 = "Central or South American" 20 = "Other Spanish" 21 = "Afro-American" 30 = "Another group not listed" 39 = "Don't know" ; VALUE TM9610L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - End of section" ; VALUE TM9612L (default=32) 0 = "Not applicable" 1 = "Elementary grades 1-8" 2 = "High school grades 9-12" 3 = "College year 1" 4 = "College year 2" 5 = "College year 3" 6 = "College year 4" 7 = "College year 5" 8 = "College year 6+" 9 = "Vocational school" 10 = "Technical school" 11 = "Business school" 12 = "Other or Don t Know" ; VALUE TM9614L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - skip to TM9618" ; VALUE TM9616L (default=32) 0 = "Not applicable" 1 = "Yes - End of section" 2 = "No" ; VALUE TM9618L (default=32) 0 = "Not applicable" -3 = "None" 4500 = "Amount from $4000 - 4999" 5500 = "Amount from $5000 - 5999" 65000 = "Amount from $6000 - 6999" 7000 = "Amount from $7000 +" ; VALUE TM9620L (default=32) 0 = "Not applicable" -3 = "None" ; VALUE TM9622L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - skip to TM9626" ; VALUE TM9624L (default=32) 0 = "Not applicable" ; VALUE TM9626L (default=32) 0 = "Not applicable" -3 = "None received - End of" ; VALUE TM9628L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9632L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9636L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9640L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9644L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9648L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9652L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9656L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9660L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9664L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9668L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE TM9672L (default=32) 0 = "Not marked as received" 1 = "Received" ; VALUE IMP9612L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9616L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9618L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9620L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9622L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9624L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9630L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9634L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9638L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9642L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9646L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9650L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9654L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9658L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9662L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9666L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9670L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE IMP9674L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TMTEDFIN (default=32) 4500 = "Amount from $4100 - 4999" 5500 = "Amount from $5000 - 5999" 6500 = "Amount from $6000 - 6999" 7500 = "Amount from $7000 - 7999" 8500 = "Amount from $8000 - 8999" 9500 = "Amount from $9000 - 9999" 10500 = "Amount from $10000 - 10999" 11000 = "Amount from $11000 +" 0 = "Not applicable" ; filename raw pipe "unzip -p /homes/data/sipp/1993/sipp93t5.zip "; data library.sip93t5; 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/1993/sipp93t5.dat' LRECL=20000 PAD END=EOF; *LENGTH SUSEQNUM 4 ID 6 ADDID $2 ENTRY $2 FINALWGT 8 TM9618 4 TM9620 4 TM9624 4 TM9630 4 TM9634 4 TM9638 4 TM9642 4 TM9646 4 TM9650 4 TM9654 4 TM9658 4 TM9662 4 TM9666 4 TM9670 4 TM9674 4 TMTEDFIN 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 SUSEQNUM 5. @6 ID 9. @15 ROTATION 1. @16 STATE 2. @18 PINX 2. @20 ADDID $2. @22 ITEM36B 2. @24 INTVW 1. @25 PPMIS1 1. @26 PPMIS2 1. @27 PPMIS3 1. @28 PPMIS4 1. @29 PPMIS5 1. @30 ENTRY $2. @32 PNUM $3. @35 FINALWGT 12.4 @47 RRP 1. @48 AGE 3. @51 SEX 1. @52 RACE 1. @53 MS 1. @54 PNSP 3. @57 PNPT 3. @60 HIGRADE 2. @62 GRDCMPL 1. @63 ETHNICTY 2. @65 WAVE 1. @69 TM9610 1. @70 TM9612 2. @72 TM9614 1. @73 TM9616 1. @74 TM9618 5. @79 TM9620 4. @83 TM9622 1. @84 TM9624 5. @89 TM9626 2. @91 TM9628 1. @92 TM9630 4. @96 TM9632 1. @97 TM9634 5. @102 TM9636 1. @103 TM9638 4. @107 TM9640 1. @108 TM9642 4. @112 TM9644 1. @113 TM9646 4. @117 TM9648 1. @118 TM9650 4. @122 TM9652 1. @123 TM9654 5. @128 TM9656 1. @129 TM9658 4. @133 TM9660 1. @134 TM9662 5. @139 TM9664 1. @140 TM9666 5. @145 TM9668 1. @146 TM9670 4. @150 TM9672 1. @151 TM9674 5. @156 TMETCNT 2. @158 IMP9612 1. @159 IMP9616 1. @160 IMP9618 1. @161 IMP9620 1. @162 IMP9622 1. @163 IMP9624 1. @164 IMP9630 1. @165 IMP9634 1. @166 IMP9638 1. @167 IMP9642 1. @168 IMP9646 1. @169 IMP9650 1. @170 IMP9654 1. @171 IMP9658 1. @172 IMP9662 1. @173 IMP9666 1. @174 IMP9670 1. @175 IMP9674 1. @176 TMTEDFIN 5. ; LABEL SUSEQNUM = "Sequence number of sample unit" ID = "Sample unit identifier" ROTATION = "Rotation group" STATE = "FIPS state code" PINX = "Person index from core" ADDID = "Current address ID - This field" ITEM36B = "Household interview status code" INTVW = "Person's interview status" PPMIS1 = "Person's interview status:" PPMIS2 = "Person Interview status:" PPMIS3 = "Person's interview status:" PPMIS4 = "Person's interview status:" PPMIS5 = "Person's interview status:" ENTRY = "Edited entry address ID" PNUM = "Person number" FINALWGT = "Person weight (interview month)" RRP = "Relationship to reference person" AGE = "Age" SEX = "Sex" RACE = "Race" MS = "Marital status" PNSP = "Person number of spouse" PNPT = "Person number of parent" HIGRADE = "What is the highest grade or year of" GRDCMPL = "Did he/she complete that grade" ETHNICTY = "Ethnic origin" WAVE = "Wave number within Panel" TM9610 = "Was ... enrolled in school anytime" TM9612 = "At what level or grade was..." TM9614 = "Check item T21" TM9616 = "Was...enrolled in a public school?" TM9618 = "During the past 12 months what" TM9620 = "During the past 12 months, what was" TM9622 = "During the past 12 months, did..." TM9624 = "During the past 12 months, what" TM9626 = "No educational assistance" TM9628 = "Educational assistance received" TM9630 = "Percent of total educational" TM9632 = "Educational assistance received" TM9634 = "Percent of total educational" TM9636 = "Educational assistance received" TM9638 = "Percent of total educational" TM9640 = "Educational assistance received" TM9642 = "Percent of total educational" TM9644 = "Educational assistance received" TM9646 = "Percent of total educational" TM9648 = "Educational assistance received" TM9650 = "Percent of total educational" TM9652 = "Educational assistance received during" TM9654 = "Percent of total educational assistanc" TM9656 = "Educational assistance received" TM9658 = "Percent of total educational" TM9660 = "Educational assistance received" TM9662 = "Percent of total educational" TM9664 = "Educational assistance received" TM9666 = "Percent of total educational" TM9668 = "Educational assistance received" TM9670 = "Percent of total educational" TM9672 = "Educational assistance received" TM9674 = "Percent of total educational" TMETCNT = "Number of non-blank entries" IMP9612 = "Imputation flag for 'TM9612'" IMP9616 = "Imputation flag for 'TM9616'" IMP9618 = "Imputation flag for 'TM9618'" IMP9620 = "Imputation flag for 'TM9620'" IMP9622 = "Imputation flag for 'TM9622'" IMP9624 = "Imputation flag for 'TM9624'" IMP9630 = "Imputation flag for 'TM9630'" IMP9634 = "Imputation flag for 'TM9634'" IMP9638 = "Imputation flag for 'TM9638'" IMP9642 = "Imputation flag for 'TM9642'" IMP9646 = "Imputation flag for 'TM9646'" IMP9650 = "Imputation flag for 'TM9650'" IMP9654 = "Imputation flag for 'TM9654'" IMP9658 = "Imputation flag for 'TM9658'" IMP9662 = "Imputation flag for 'TM9662'" IMP9666 = "Imputation flag for 'TM9666'" IMP9670 = "Imputation flag for 'TM9670'" IMP9674 = "Imputation flag for 'TM9674'" TMTEDFIN = "Total amount of educational assistance" ; proc print data=library.sip93t5 (obs=6); FORMAT ROTATION ROTATION. STATE STATE. ITEM36B ITEM36B. INTVW INTVW. PPMIS1 PPMIS1L. PPMIS2 PPMIS2L. PPMIS3 PPMIS3L. PPMIS4 PPMIS4L. PPMIS5 PPMIS5L. RRP RRP. AGE AGE. SEX SEX. RACE RACE. MS MS. PNSP PNSP. PNPT PNPT. HIGRADE HIGRADE. GRDCMPL GRDCMPL. ETHNICTY ETHNICTY. TM9610 TM9610L. TM9612 TM9612L. TM9614 TM9614L. TM9616 TM9616L. TM9618 TM9618L. TM9620 TM9620L. TM9622 TM9622L. TM9624 TM9624L. TM9626 TM9626L. TM9628 TM9628L. TM9632 TM9632L. TM9636 TM9636L. TM9640 TM9640L. TM9644 TM9644L. TM9648 TM9648L. TM9652 TM9652L. TM9656 TM9656L. TM9660 TM9660L. TM9664 TM9664L. TM9668 TM9668L. TM9672 TM9672L. IMP9612 IMP9612L. IMP9616 IMP9616L. IMP9618 IMP9618L. IMP9620 IMP9620L. IMP9622 IMP9622L. IMP9624 IMP9624L. IMP9630 IMP9630L. IMP9634 IMP9634L. IMP9638 IMP9638L. IMP9642 IMP9642L. IMP9646 IMP9646L. IMP9650 IMP9650L. IMP9654 IMP9654L. IMP9658 IMP9658L. IMP9662 IMP9662L. IMP9666 IMP9666L. IMP9670 IMP9670L. IMP9674 IMP9674L. TMTEDFIN TMTEDFIN. ; proc contents data=library.sip93t5; /* Copyright 2004 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. */