/*------------------------------------------------------------------------------------*/ /*by Jean Roth Mon Jun 7 17:36:42 EDT 2004 This program reads the 1990 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.fsp90t5; /* The PROC FORMAT statement will store the formats in a sas data set called fsip90t5 To use the stored formats in a subsequent program, include something like this: proc format cntlin=library.fsp90t5; PROC freq; tables pesex ; format pesex P135L.; For more information, consult the SAS Procedures Guide section of PROC FORMAT */ ; VALUE ITEM36B (default=32) 1 = "Interviewed" 2 = "No one home" 3 = "Temporarily absent" 4 = "Refused" 5 = "Unable to locate" 6 = "Other Type A" 9 = "Vacant" 10 = "Occupied by persons with URE" 11 = "Unfit or to be demolished" 12 = "Under construction, not ready" 13 = "Converted to temporary business" 14 = "Unoccupied site for mobile home," 15 = "Permit granted, construction not" 17 = "Demolished" 18 = "House or trailer moved" 19 = "Converted to permanent business" 20 = "Merged" 21 = "Condemned" 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 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 a sample person in this" 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 GRD_CMPL (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 (Black or Negro)" 30 = "Another group not listed" 39 = "Don't know" ; VALUE TM9610L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - End of interview" ; 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 DK" ; 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 interview" 2 = "No" ; VALUE TM9618L (default=32) 4500 = "Amount from $4000 to $4999" 5500 = "Amount from $5000 to $5999" 07000 = "Amount from $6000 or more" ; VALUE TM9620L (default=32) 0 = "Not applicable" -1 = "Dk" -3 = "None" ; VALUE TM9622L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - skip to 9626" ; VALUE TM9624L (default=32) 0 = "Not applicable" ; VALUE TM9626L (default=32) 0 = "Not applicable" -3 = "None - End of interview" ; 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 TM_IFC1L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC2L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC3L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC4L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC5L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC6L (default=32) 0 = "Not imputed" 1 = "Imputed" ; VALUE TM_IFC7L (default=32) 0 = "Not imputed" 1 = "Imputed TM9630" ; VALUE TM_IFC8L (default=32) 0 = "Not imputed" 1 = "Imputed TM9634" ; VALUE TM_IFC9L (default=32) 0 = "Not imputed" 1 = "Imputed TM9638" ; VALUE TM_IFC1Y (default=32) 0 = "Not imputed" 1 = "Imputed TM9642" ; VALUE TM_IFC1K (default=32) 0 = "Not imputed" 1 = "Imputed TM9646" ; VALUE TM_IFC1M (default=32) 0 = "Not imputed" 1 = "Imputed TM9650" ; VALUE TM_IFC1N (default=32) 0 = "Not imputed" 1 = "Imputed TM9654" ; VALUE TM_IFC1O (default=32) 0 = "Not imputed" 1 = "Imputed TM9658" ; VALUE TM_IFC1P (default=32) 0 = "Not imputed" 1 = "Imputed TM9662" ; VALUE TM_IFC1Q (default=32) 0 = "Not imputed" 1 = "Imputed TM9666" ; VALUE TM_IFC1R (default=32) 0 = "Not imputed" 1 = "Imputed TM9670" ; VALUE TM_IFC1S (default=32) 0 = "Not imputed" 1 = "Imputed TM9674" ; VALUE TMTEDFIN (default=32) 4500 = "Amount from $4000 - $4999" 5500 = "Amount from $5000 - $5999" 7000 = "Amount $6000 or more" ; filename raw pipe "unzip -p /homes/data/sipp/1990/sipp90t5.zip "; data library.sip90t5; 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/1990/sipp90t5.dat' LRECL=20000 PAD END=EOF; *LENGTH SUSEQNUM $5 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 ENTRY $2. @27 PNUM $3. @30 FINALWGT 12.4 @42 RRP 1. @43 AGE 3. @46 SEX 1. @47 Race 1. @48 MS 1. @49 PNSP 3. @52 PNPT 3. @55 HIGRADE 2. @57 GRD_CMPL 1. @58 ETHNICTY 2. @60 WAVE 1. @61 TM9610 1. @62 TM9612 2. @64 TM9614 1. @65 TM9616 1. @66 TM9618 5. @71 TM9620 4. @75 TM9622 1. @76 TM9624 5. @81 TM9626 2. @83 TM9628 1. @84 TM9630 4. @88 TM9632 1. @89 TM9634 5. @94 TM9636 1. @95 TM9638 4. @99 TM9640 1. @100 TM9642 4. @104 TM9644 1. @105 TM9646 4. @109 TM9648 1. @110 TM9650 4. @114 TM9652 1. @115 TM9654 5. @120 TM9656 1. @121 TM9658 4. @125 TM9660 1. @126 TM9662 5. @131 TM9664 1. @132 TM9666 5. @137 TM9668 1. @138 TM9670 4. @142 TM9672 1. @143 TM9674 5. @148 TMETCNT 2. @150 TM_IFC1 1. @151 TM_IFC2 1. @152 TM_IFC3 1. @153 TM_IFC4 1. @154 TM_IFC5 1. @155 TM_IFC6 1. @156 TM_IFC7 1. @157 TM_IFC8 1. @158 TM_IFC9 1. @159 TM_IFC10 1. @160 TM_IFC11 1. @161 TM_IFC12 1. @162 TM_IFC13 1. @163 TM_IFC14 1. @164 TM_IFC15 1. @165 TM_IFC16 1. @166 TM_IFC17 1. @167 TM_IFC18 1. @168 TMTEDFIN 4. ; LABEL SUSEQNUM = "Sequence number of sample unit" ID = "Sample unit identifier" ROTATION = "Rotation" STATE = "FIPS state code from the MST/GRIN file" PINX = "Person index from core" ADDID = "Address ID - This field differentiates" ITEM36B = "Control card item 36B -" INTVW = "Person's interview status" ENTRY = "Edited entry address ID" PNUM = "Edited person number" FINALWGT = "'STAGE1WT' second stage factor." RRP = "Edited relationship to reference perso" AGE = "Edited and imputed age as of last" SEX = "Sex of this person" Race = "Race of this person" MS = "Marital status" PNSP = "Person number of spouse" PNPT = "Prson number of parent" HIGRADE = "What is the highest grade or year of" GRD_CMPL = "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 T37" TM9616 = "Was...enrolled in a public school?" TM9618 = "During the past year what was the" TM9620 = "What was the total cost of...'s" TM9622 = "Did...live away from home while" TM9624 = "What was the total cost for room and" TM9626 = "Any type of educational assistance" TM9628 = "The GI bill?" TM9630 = "Amount received from GI bill" TM9632 = "Other veteran's educational assis-" TM9634 = "Amount received from veteran's" TM9636 = "College work study program?" TM9638 = "Amount received from college work" TM9640 = "A Pell grant?" TM9642 = "Amount received from Pell grant" TM9644 = "A Supplemental Educational" TM9646 = "Amount received from SEOG" TM9648 = "A national direct student loan?" TM9650 = "Amount received from a national" TM9652 = "A guaranteed student loan" TM9654 = "Amount received from a guaranteed" TM9656 = "A JTPA training program" TM9658 = "Amount received from JTPA" TM9660 = "Employer assistance" TM9662 = "Amount of employer assistance" TM9664 = "A fellowship or scholarship?" TM9666 = "Amount of fellowship or scholarship" TM9668 = "A tuition reduction?" TM9670 = "Amount received from tuition" TM9672 = "Anything else (other than assistance" TM9674 = "Amount of educational assistance" TMETCNT = "Number of items with data on" TM_IFC1 = "Part C imputation flag #01" TM_IFC2 = "Part C imputation flag #02" TM_IFC3 = "Part C imputation flag #03" TM_IFC4 = "Part C imputation flag #04" TM_IFC5 = "Part C imputation flag #05" TM_IFC6 = "Part C imputation flag #06" TM_IFC7 = "Part C imputation flag #07" TM_IFC8 = "Part C imputation flag #08" TM_IFC9 = "Part C imputation flag #09" TM_IFC10 = "Part C imputation flag #10" TM_IFC11 = "Part C imputation flag #11" TM_IFC12 = "Part C imputation flag #12" TM_IFC13 = "Part C imputation flag #13" TM_IFC14 = "Part C imputation flag #14" TM_IFC15 = "Part C imputation flag #15" TM_IFC16 = "Part C imputation flag #16" TM_IFC17 = "Part C imputation flag #17" TM_IFC18 = "Part C imputation flag #18" TMTEDFIN = "Total amount of educational assistance" ; proc print data=library.sip90t5 (obs=6); FORMAT ITEM36B ITEM36B. INTVW INTVW. RRP RRP. AGE AGE. SEX SEX. Race Race. MS MS. PNSP PNSP. PNPT PNPT. HIGRADE HIGRADE. GRD_CMPL GRD_CMPL. 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. TM_IFC1 TM_IFC1L. TM_IFC2 TM_IFC2L. TM_IFC3 TM_IFC3L. TM_IFC4 TM_IFC4L. TM_IFC5 TM_IFC5L. TM_IFC6 TM_IFC6L. TM_IFC7 TM_IFC7L. TM_IFC8 TM_IFC8L. TM_IFC9 TM_IFC9L. TM_IFC10 TM_IFC1Y. TM_IFC11 TM_IFC1K. TM_IFC12 TM_IFC1M. TM_IFC13 TM_IFC1N. TM_IFC14 TM_IFC1O. TM_IFC15 TM_IFC1P. TM_IFC16 TM_IFC1Q. TM_IFC17 TM_IFC1R. TM_IFC18 TM_IFC1S. TMTEDFIN TMTEDFIN. ; proc contents data=library.sip90t5; /* 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. */