/*------------------------------------------------------------------------------------*/ /*by Jean Roth Mon Jun 7 18:28:02 EDT 2004 This program reads the 1991 SIPP Wave 8 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.fsp91t8; /* The PROC FORMAT statement will store the formats in a sas data set called fsip91t8 To use the stored formats in a subsequent program, include something like this: proc format cntlin=library.fsp91t8; PROC freq; tables pesex ; format pesex P135L.; For more information, consult the SAS Procedures Guide section of PROC FORMAT */ ; 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" 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, moved" 24 = "Moved, address unknown" 25 = "Moved within country beyond" 26 = "All sample persons relisted on" 28 = "Merged HHLDS across panels" ; 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 PP_MIS (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 etc." ; 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) 0 = "Not applicable" 4500 = "$4000 - 4999" 5500 = "$5000 - 5999" 6500 = "$6000 - 6999" 07000 = "$7000 +" ; VALUE TM9620L (default=32) -1 = "DK" -3 = "None" 0 = "Not applicable" ; VALUE TM9622L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No - skip to TM9626" ; VALUE TM9624L (default=32) -1 = "DK" 0 = "Not applicable" ; VALUE TM9626L (default=32) -3 = "None - End of interview" 0 = "Not applicable" ; 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 +" ; filename raw pipe "unzip -p /homes/data/sipp/1991/sipp91t8.zip "; data library.sip91t8; 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/1991/sipp91t8.dat' LRECL=20000 PAD END=EOF; *LENGTH SUSEQNUM $5 ID $9 ADDID $2 PP_MIS 4 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 PP_MIS 5. @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 GRD_CMPL 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" STATE = "FIPS state code from the MST/GRIN file" PINX = "Person index from core" ADDID = "Address ID - This field" ITEM36B = "Control card item 36B - Interview stat" INTVW = "Person's interview status" PP_MIS = "Monthly 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 = "Person 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 of the 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 = "Percent received from GI bill" TM9632 = "Other veteran's educational assis-" TM9634 = "Percent received from veteran's" TM9636 = "College work study program?" TM9638 = "Percent received from college work" TM9640 = "A Pell grant?" TM9642 = "Percent received from Pell grant" TM9644 = "A supplemental educational" TM9646 = "Percent received from SEOG" TM9648 = "A national direct student loan?" TM9650 = "Percent received from a national" TM9652 = "A guaranteed student loan" TM9654 = "Percent received from a guaranteed" TM9656 = "A JTPA training program" TM9658 = "Percent received from JTPA" TM9660 = "Employer assistance" TM9662 = "Percent of employer assistance" TM9664 = "A fellowship or scholarship?" TM9666 = "Percent of fellowship or scholarship" TM9668 = "A tuition reduction?" TM9670 = "Percent received from tuition" TM9672 = "Anything else (other than assistance" TM9674 = "Percent of educational assistance" TMETCNT = "Number of items with data on this reco" IMP9612 = "Part C imputation flag #01" IMP9616 = "Part C imputation flag #02" IMP9618 = "Part C imputation flag #03" IMP9620 = "Part C imputation flag #04" IMP9622 = "Part C imputation flag #05" IMP9624 = "Part C imputation flag #06" IMP9630 = "Part C imputation flag #07" IMP9634 = "Part C imputation flag #08" IMP9638 = "Part C imputation flag #09" IMP9642 = "Part C imputation flag #10" IMP9646 = "Part C imputation flag #11" IMP9650 = "Part C imputation flag #12" IMP9654 = "Part C imputation flag #13" IMP9658 = "Part C imputation flag #14" IMP9662 = "Part C imputation flag #15" IMP9666 = "Part C imputation flag #16" IMP9670 = "Part C imputation flag #17" IMP9674 = "Part C imputation flag #18" TMTEDFIN = "Total amount of educational assistance" ; proc print data=library.sip91t8 (obs=6); FORMAT STATE STATE. ITEM36B ITEM36B. INTVW INTVW. PP_MIS PP_MIS. 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. 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.sip91t8; /* 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. */