SAS Setup File

Page Contents:
  [1] PROC FORMAT
  [2] DATA
  [3] INFILE
  [4] INPUT
  [5] LABEL
  [6] FORMAT
  [7] MISSING VALUE RECODES



* SAS PROC FORMAT;

[1]PROC FORMAT;
   VALUE V1FT (MAX=40)
   6512 = "ICPSR Study Number";
   VALUE V2FT (MAX=40)
   1 = "July 1995 release";
   VALUE V3FT (MAX=40)
   1 = "Part one";
   VALUE V8FT (MAX=40)
   1 = "Male"
   2 = "Female";
  VALUE V9FT (MAX=40)
   1 = "White"
   2 = "Black"
   3 = "American Indian or Alaskan Native"
   4 = "Asian or Pacific Islander"
   5 = "Other";
   VALUE V10FT (MAX=40)
   1 = "Hispanic"
   2 = "Non-Hispanic"
   3 = "Not known"
   9 = "Unknown";
   VALUE V11FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Unknown";
VALUE V13FT (MAX=40)
   1 = "Murder"
   5 = "Kidnapping or abduction"
   6 = "Forcible or attempted rape"
   10 = "Robbery"
   12 = "Aggravated assault"
   17 = "Hit and run driving with bodily injury"
   21 = "Burglary"
   22 = "Arson"
   29 = "Stolen property"
   99 = "No 3rd capital offense";
   VALUE V14FT (MAX=40)
   1 = "Murder"
   5 = "Kidnapping or abduction"
   6 = "Forcible or attempted rape"
   10 = "Robbery"
   12 = "Aggravated assault"
   17 = "Hit and run driving with bodily injury"
   21 = "Burglary"
   22 = "Arson"
   29 = "Stolen property"
   99 = "No 2nd capital offense";
   VALUE V15FT (MAX=40)
   1 = "Murder"
   5 = "Kidnapping or abduction"
   6 = "Forcible or attempted rape"
   10 = "Robbery"
   12 = "Aggravated assault"
   17 = "Hit and run driving with bodily injury"
   21 = "Burglary"
   22 = "Arson"
   29 = "Stolen property";
   VALUE V16FT (MAX=40)
   1 = "Married"
   2 = "Divorced or separated"
   3 = "Widowed"
   4 = "Never married"
   9 = "Unknown";
   VALUE V17FT (MAX=40)
   1 = "7th grade or less"
   2 = "8th grade"
   3 = "9th grade"
   4 = "10th grade"
   5 = "11th grade"
   6 = "12th grade (GED included)"
   7 = "1st year of college"
   8 = "2nd year"
   9 = "3rd year"
   10 = "4th year"
   11 = "More than 4 years of college"
   12 = "Not known"
   99 = "Unknown";
   VALUE V18FT (MAX=40)
   1 = "Not under sent - no charges pending"
   2 = "Not under sentence - charges pending"
   3 = "Under sentence - on probation"
   4 = "Under sentence - on parole"
   5 = "Under sentence - on escape"
   6 = "Under sentence - imprisoned" 
   7 = "Under sentence - other"
   8 = "Unknown(from questionnaire"
   9 = "Unknown";
   VALUE V19FT (MAX=40)
   1 = "Yes - Continue with item 10b"
   2 = "No - Skip to item 11"
   3 = "Unknown"
   9 = "Unknown - Skip to item 11";
   VALUE V20FT (MAX=40)
   1 = "Yes - Murder"
   2 = "Yes - Involuntary manslaughter"
   3 = "Yes - Vehicular manslaughter"
   4 = "Yes - Attempted murder"
   5 = "Yes - Other"
   6 = "No"
   7 = "Unknown"
   8 = "Yes - Manslaughter"
   9 = "Yes - Voluntary manslaughter" 
   99 = "Inapplicable";
   VALUE V21FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Unknown";
   VALUE V22FT (MAX=40)
   99 = "Unknown";
   VALUE V23FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Unknown";
   VALUE V24FT (MAX=40)
   99 = "Unknown";
   VALUE V25FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Unknown";
   VALUE V26FT (MAX=40)
   99 = "Unknown";
   VALUE V27FT (MAX=40)
   1 = "Under sent of death - cont with item b"
   2 = "Death sent removed - skip to items c &"
   9 = "Unknown";
   VALUE V28FT (MAX=40)
   1 = "Yes, on escape - cont with
   14b(2)"
   2 = "Yes, at a mental hosp - cont with 14b(2)"
   3 = "No - NO FURTHER INFO FOR THIS INMATE"
   9 = "Unknown";
   VALUE V29FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Not applicable or unknown";
   VALUE V30FT (MAX=40)
   99 = "Not applicable or unknown";
   VALUE V31FT (MAX=40)
   1 = "Executed - Enter date, skip to Q15"
   2 = "Other deceased - Enter date, skip to Q16"
   3 = "Capital sent declared unconstitutional"
   4 = "Sentence commuted"
   5 = "Conviction affirmed, sent overturned"
   6 = "Conviction and sentence overturned"
   7 = "Other"
   8 = "Info not available at this office"
   9 = "Unknown";
   VALUE V32FT (MAX=40)
   1 = "January"
   2 = "February"
   3 = "March"
   4 = "April"
   5 = "May"
   6 = "June"
   7 = "July"
   8 = "August"
   9 = "September"
   10 = "October"
   11 = "November"
   12 = "December"
   99 = "Not applicable or unknown";
   VALUE V33FT (MAX=40)
   99 = "Not applicable or unknown";
   VALUE V34FT (MAX=40)
   1 = "Under new sentence - Cont with Q.14d2"
   2 = "Awaiting retrial to determine guilt"
   3 = "Awaiting resent only (guilt affirmed)"
   4 = "Found not guilty in retrial"
   5 = "All charges on capital offense dropped"
   6 = "Other"
   7 = "No action since removal fr sent of death"
   8 = "Information not available at this office"
   9 = "Unknown";
   VALUE V35FT (MAX=40)
   900 = "Discharged by court order"
   901 = "Executed"
   902 = "Incompetent to stand trial"
   903 = "Killed attempting escape"
   904 = "Life sentence"
   905 = "Murdered by another inmate"
   906 = "Natural death"
   907 = "On death row in Nevada"
   908 = "Out on bond"
   909 = "On probation"
   910 = "Suicide"
   911 = "Writ"
   912 = "Immigration and Naturalization Service"
   999 = "Unknown";
   VALUE V36FT (MAX=40)
   1 = "Lethal injection"
   2 = "Electrocution"
   3 = "Lethal gas"
   4 = "Hanging"
   5 = "Firing squad"
   6 = "Other"
   9 = "Not applicable";
   VALUE V37FT (MAX=40)
   1 = "Natural causes"
   2 = "Suicide"
   3 = "Murdered by another inmate"
   4 = "Other"
   9 = "Not applicable or unknown";

* SAS DATA, INFILE, INPUT STATEMENTS;

[2]DATA;
[3]INFILE "physical-filename" LRECL=67;
[4]INPUT
   V1 1-4                   V2 5-5                   V3 6-6
   V4 7-10                  V5 11-12                 V6 13-16
   V7 17-18                 V8 19-19                 V9 20-20
   V10 21-21                V11 22-23                V12 24-25
   V13 26-27                V14 28-29                V15 30-31
   V16 32-32                V17 33-34                V18 35-35
   V19 36-36                V20 37-38                V21 39-40
   V22 41-42                V23 43-44                V24 45-46
   V25 47-48                V26 49-50                V27 51-51
   V28 52-52                V29 53-54                V30 55-56
   V31 57-57                V32 58-59                V33 60-61
   V34 62-62                V35 63-65                V36 66-66
   V37 67-67;

* SAS LABEL STATEMENT;

[5]LABEL
   V1 = "ICPSR STUDY NUMBER-6512"
   V2 = "ICPSR EDITION NUMBER-1"
   V3 = "ICPSR PART NUMBER"
   V4 = "ICPSR SEQUENTIAL ID"
   V5 = "REPORT YEAR"
   V6 = "INMATE ID" V7 = "STATE"
   V8 = "Q3 SEX"
   V9 = "Q4A RACE"
   V10 = "Q4B HISPANIC ORIGIN"
   V11 = "Q5A DATE OF BIRTH-MO"
   V12 = "Q5B DATE OF BIRTH-YR"
   V13 = "Q6A 3RD CAPITAL OFF"
   V14 = "Q6B 2ND CAPITAL OFF"
   V15 = "Q6C 1ST CAPITAL OFF"
   V16 = "Q7 MARITAL STATUS"
   V17 = "Q8 EDUCATION"
   V18 = "Q9 LEGAL STATUS"
   V19 = "Q10A PRI FELONY CONVICT."
   V20 = "Q10B PRI FEL CONV-HOMIC"
   V21 = "Q11A DATE OF ARREST-MO"
   V22 = "Q11B DATE OF ARREST-YR"
   V23 = "Q12A DATE OF CONVCT-MO"
   V24 = "Q12B DATE OF CONVCT-YR"
   V25 = "Q13A DATE SENT DEATH-MO"
   V26 = "Q13B DATE SENT DEATH-YR"
   V27 = "Q14A STILL ON DEATH ROW"
   V28 = "Q14B1 INMATE ESC OR MENT"
   V29 = "Q14B2 MONTH ESC/MENT HOS"
   V30 = "Q14B3 YEAR ESC/MENT HOSP"
   V31 = "Q14C1 REASON/REM DEATH R"
   V32 = "Q14C2 MONTH REMV FROM DR"
   V33 = "Q14C3 YEAR REMOV FROM DR"
   V34 = "Q14D1 CURRENT STATUS"
    V35 = "Q14D2 NEW SENTENCE OF"
   V36 = "Q15 METHOD OF EXECUTION"
   V37 = "Q16 OTHER CAUSE OF DEATH";
   
* SAS FORMAT STATEMENT;

[6]FORMAT
   V1 V1FT.               V2 V2FT.               V3 V3FT.
   V8 V8FT.               V9 V9FT.               V10 V10FT.
   V11 V11FT.             V13 V13FT.             V14 V14FT.
   V15 V15FT.             V16 V16FT.             V17 V17FT.
   V18 V18FT.             V19 V19FT.             V20 V20FT.
   V21 V21FT.             V22 V22FT.             V23 V23FT.
   V24 V24FT.             V25 V25FT.             V26 V26FT.
   V27 V27FT.             V28 V28FT.             V29 V29FT.
   V30 V30FT.             V31 V31FT.             V32 V32FT.
   V33 V33FT.             V34 V34FT.             V35 V35FT.
   V36 V36FT.             V37 V37FT.;


[7]* USER-DEFINED MISSING VALUE RECODE TO SAS SYSMIS;


   IF V5=0 THEN V5=.;                  IF V10=9 THEN V10=.;
   IF V11=99 THEN V11=.;               IF V13=99 THEN V13=.;
   IF V14=99 THEN V14=.;               IF V16=9 THEN V16=.;
   IF V17=99 THEN V17=.;               IF V18=9 THEN V18=.;
   IF V19=9 THEN V19=.;                IF V20=99 THEN V20=.;
   IF V21=99 THEN V21=.;               IF V22=99 THEN V22=.;
   IF V23=99 THEN V23=.;               IF V24=99 THEN V24=.;
   IF V25=99 THEN V25=.;               IF V26=99 THEN V26=.;
   IF V27=9 THEN V27=.;                IF V28=9 THEN V28=.;
   IF V29=99 THEN V29=.;               IF V30=99 THEN V30=.;
   IF V31=9 THEN V31=.;                IF V32=99 THEN V32=.;
   IF V33=99 THEN V33=.;               IF V34=9 THEN V34=.;
   IF V35=999 THEN V35=.;              IF V36=9 THEN V36=.;
   IF V37=9 THEN V37=.;