/*------------------------------------------------------------------------------------*/ /*by Jean Roth Mon Jun 7 18:25:53 EDT 2004 This program reads the 1991 SIPP Wave 6 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.fsp91t6; /* The PROC FORMAT statement will store the formats in a sas data set called fsip91t6 To use the stored formats in a subsequent program, include something like this: proc format cntlin=library.fsp91t6; 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 = "Interview D" 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" ; 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" 30 = "Another group not listed" 39 = "Don't know" ; VALUE TM8000L (default=32) 1 = "Yes" 2 = "No" ; VALUE TM8148L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8150L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8152L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8154L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8156L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8158L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Very safe" 2 = "Fairly safe" 3 = "Fairly unsafe" 4 = "Very unsafe" ; VALUE TM8160L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Very safe" 2 = "Fairly safe" 3 = "Fairly unsafe" 4 = "Very unsafe" ; VALUE TM8162L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8184L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8204L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8300L (default=32) -1 = "Don't know" 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8304L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8306L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8310L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8312L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8316L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8318L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8322L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8324L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8328L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8330L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8334L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8336L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8340L (default=32) 0 = "Not applicable" 1 = "Yes" 2 = "No" ; VALUE TM8342L (default=32) -1 = "Don't know" 0 = "Not applicable" ; VALUE TM8344L (default=32) -3 = "Not applicable" -1 = "Don't know" 0 = "Not in sample" 1 = "All of the help I/we need" 2 = "Most of the help I/we need" 3 = "Very little of the help I/we" 4 = "No help" ; VALUE TM8346L (default=32) -3 = "Not applicable" -1 = "Don't know" 0 = "Not in sample" 1 = "All of the help I/we need" 2 = "Most of the help I/we need" 3 = "Very little of the help I/we" 4 = "No help" ; VALUE TM8348L (default=32) -3 = "Not applicable" -1 = "Don't know" 0 = "Not in sample" 1 = "All of the help I/we need" 2 = "Most of the help I/we need" 3 = "Very little of the help I/we" 4 = "No help" ; VALUE TM8350L (default=32) -1 = "Don't know - skip to Check" 0 = "Not applicable" 1 = "Enough of the kinds of food we" 2 = "Enough but not always the kinds" 3 = "Sometimes not enough to eat" 4 = "Often not enough to eat" ; VALUE TM8368L (default=32) -3 = "None - skip to Check Item C1" ; VALUE TM8370L (default=32) -1 = "Don't know" 0 = "Not applicable" ; filename raw pipe "unzip -p /homes/data/sipp/1991/sipp91t6.zip "; data library.sip91t6; 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/sipp91t6.dat' LRECL=20000 PAD END=EOF; *LENGTH SUSEQNUM $5 ID $9 ADDID $2 PP_MIS 4 ENTRY $2 FINALWGT 8 TMENTRY $2 TM8370 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. @66 TMENTRY $2. @68 TMHHPNUM $3. @73 TM8000 1. @74 TM8002 2. @76 TM8006 2. @78 TM8010 2. @80 TM8014 2. @82 TM8018 2. @84 TM8022 2. @86 TM8026 2. @88 TM8030 2. @90 TM8034 2. @92 TM8038 2. @94 TM8042 2. @96 TM8046 2. @98 TM8100 2. @100 TM8102 2. @102 TM8106 2. @104 TM8110 2. @106 TM8114 2. @108 TM8118 2. @110 TM8122 2. @112 TM8126 2. @114 TM8130 2. @116 TM8132 2. @118 TM8134 2. @120 TM8136 2. @122 TM8138 2. @124 TM8140 2. @126 TM8142 2. @128 TM8144 2. @130 TM8146 2. @132 TM8148 2. @134 TM8150 2. @136 TM8152 2. @138 TM8154 2. @140 TM8156 1. @141 TM8158 2. @143 TM8160 2. @145 TM8162 2. @147 TM8170 2. @149 TM8172 2. @151 TM8174 2. @153 TM8176 2. @155 TM8178 2. @157 TM8180 2. @159 TM8182 2. @161 TM8184 2. @163 TM8186 2. @165 TM8188 2. @167 TM8190 2. @169 TM8192 2. @171 TM8194 2. @173 TM8196 2. @175 TM8198 2. @177 TM8200 2. @179 TM8202 2. @181 TM8204 2. @183 TM8300 2. @185 TM8302 2. @187 TM8304 1. @188 TM8306 2. @190 TM8308 2. @192 TM8310 1. @193 TM8312 2. @195 TM8314 2. @197 TM8316 1. @198 TM8318 2. @200 TM8320 2. @202 TM8322 1. @203 TM8324 2. @205 TM8326 2. @207 TM8328 1. @208 TM8330 2. @210 TM8332 2. @212 TM8334 1. @213 TM8336 2. @215 TM8338 2. @217 TM8340 1. @218 TM8342 2. @220 TM8344 2. @222 TM8346 2. @224 TM8348 2. @226 TM8350 2. @228 TM8352 1. @229 TM8354 1. @230 TM8356 1. @231 TM8358 1. @232 TM8360 2. @234 TM8362 2. @236 TM8364 2. @238 TM8366 2. @240 TM8368 2. @242 TM8370 6. ; 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" 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 within Panel year" TMENTRY = "Respondent's entry address ID" TMHHPNUM = "Person number" TM8000 = "Check item T1" TM8002 = "Washing machine" TM8006 = "Clothes dryer" TM8010 = "Dishwasher" TM8014 = "Refrigerator" TM8018 = "Food freezer (separate from" TM8022 = "Color television" TM8026 = "Gas or electric stove (with or" TM8030 = "Microwave oven" TM8034 = "Videocassette recorder (VCR)" TM8038 = "Air conditioner (central or room)" TM8042 = "Personal computer" TM8046 = "Telephone" TM8100 = "How many rooms are there in your home?" TM8102 = "Leaking roof or ceiling?" TM8106 = "A toilet, hot water heater, or other" TM8110 = "Broken windows?" TM8114 = "Exposed electrical wires?" TM8118 = "Rats, mice, roaches, or other insects?" TM8122 = "Holes in the floor (large enough to" TM8126 = "Open cracks or holes in the walls" TM8130 = "The general state of repair of your ho" TM8132 = "The amount of room or space your home" TM8134 = "The furnishings in your home?" TM8136 = "The warmth of your home in winter?" TM8138 = "The coolness of your home in summer?" TM8140 = "The amount of privacy your home offers" TM8142 = "The security or safety of your home?" TM8144 = "The convenience of your home to stores" TM8146 = "Your relationship with neighbors?" TM8148 = "Do you feel that the conditions in thi" TM8150 = "On a scale of 1 to 10, how would you" TM8152 = "On a scale of 1 to 10, how would you" TM8154 = "In the past month, have there been any" TM8156 = "When you go out, do you ever carry" TM8158 = "Do you consider your neighborhood" TM8160 = "How about your home? Do you consider i" TM8162 = "We are interested in finding out if" TM8170 = "Street noise or heavy street traffic?" TM8172 = "Streets in need of repair?" TM8174 = "Crime?" TM8176 = "Trash, litter, or garbage in the" TM8178 = "Rundown or abandoned houses or buildin" TM8180 = "Industries, businesses, or other" TM8182 = "Odors, smoke, or gas fumes?" TM8184 = "Do you feel that neighborhood conditio" TM8186 = "Hospitals, health clinics, and doctors" TM8188 = "Parks and recreational facilities?" TM8190 = "Public transportation?" TM8192 = "Police services?" TM8194 = "Fire department services" TM8196 = "Neighborhood stores?" TM8198 = "Quality of education in local" TM8200 = "Safety in local schools?" TM8202 = "Education or training opportunities" TM8204 = "Do you feel that the services in your" TM8300 = "During the past 12 months, has there b" TM8302 = "Did not pay the full amount of the" TM8304 = "Did any person or organization help?" TM8306 = "Who helped?" TM8308 = "Was evicted from your home/apartment" TM8310 = "Did any person or organization help?" TM8312 = "Who helped?" TM8314 = "Did not pay the full amount of the" TM8316 = "Did any person or organization help?" TM8318 = "Who helped?" TM8320 = "Had service turned off by the gas" TM8322 = "Did any person or organization help?" TM8324 = "Who helped?" TM8326 = "Had service disconnected by the" TM8328 = "Did any person or organization help?" TM8330 = "Who helped?" TM8332 = "Had someone in your household who" TM8334 = "Did any person or organization help?" TM8336 = "Who helped?" TM8338 = "Had someone who needed to see a" TM8340 = "Did any person or organization help?" TM8342 = "Who helped?" TM8344 = "If your household had a problem with" TM8346 = "If your household had a problem with" TM8348 = "If your household had a problem with" TM8350 = "Which of these statements best describ" TM8352 = "Last month" TM8354 = "Two months ago" TM8356 = "Three months ago" TM8358 = "Four months ago" TM8360 = "Did not have enough money, food" TM8362 = "Did not have working appliances for" TM8364 = "Did not have transportation" TM8366 = "Some other reason" TM8368 = "Thinking about the past month, how man" TM8370 = "Short on its food budget last month?" ; proc print data=library.sip91t6 (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. TM8000 TM8000L. TM8148 TM8148L. TM8150 TM8150L. TM8152 TM8152L. TM8154 TM8154L. TM8156 TM8156L. TM8158 TM8158L. TM8160 TM8160L. TM8162 TM8162L. TM8184 TM8184L. TM8204 TM8204L. TM8300 TM8300L. TM8304 TM8304L. TM8306 TM8306L. TM8310 TM8310L. TM8312 TM8312L. TM8316 TM8316L. TM8318 TM8318L. TM8322 TM8322L. TM8324 TM8324L. TM8328 TM8328L. TM8330 TM8330L. TM8334 TM8334L. TM8336 TM8336L. TM8340 TM8340L. TM8342 TM8342L. TM8344 TM8344L. TM8346 TM8346L. TM8348 TM8348L. TM8350 TM8350L. TM8368 TM8368L. TM8370 TM8370L. ; proc contents data=library.sip91t6; /* 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. */