*-------------------------------------------------------------------------* | | SAS SETUP FILE FOR ICPSR 04431 | TREATMENT EPISODE DATA SET (TEDS), 2004 | | | SAS setup sections are provided for the ASCII version of this data | collection. These sections are listed below: | | PROC FORMAT: creates user-defined formats for the variables. Formats | replace original value codes with value code descriptions. Only | variables with user-defined formats are included in this section. | | DATA: begins a SAS data step and names an output SAS data set. | | INFILE: identifies the input file to be read with the input statement. | Users must replace the "data-filename" with a filename specifying the | directory on the user's computer system in which the downloaded and | unzipped data file is physically located (e.g., | "c:\temp\04431-0001-data.txt"). | | INPUT: assigns the name, type, decimal specification (if any), and | specifies the beginning and ending column locations for each variable | in the data file. | | LABEL: assigns descriptive labels to all variables. Variable labels | and variable names may be identical for some variables. | | MISSING VALUE RECODES: sets user-defined numeric missing values to | missing as interpreted by the SAS system. Only variables with | user-defined missing values are included in this section. | | FORMAT: associates the formats created by the PROC FORMAT step with | the variables named in the INPUT statement. | | NOTE: Users should modify this setup file to suit their specific needs. | Sections for PROC FORMAT, FORMAT, and MISSING VALUE RECODES have been | commented out (i.e., '/*'). To include these sections in the final SAS | setup, users should remove the SAS comment indicators from the desired | section(s). | *------------------------------------------------------------------------; * SAS PROC FORMAT; /* PROC FORMAT; VALUE YEARffff -9='MISSING/UNKNOWN/NOT COLLECTED/INVALID' ; VALUE STATE -9='MISSING/UNKNOWN/NOT COLLECTED/INVALID' 1='(1) ALASKA' 2='(2) ALABAMA' 3='(3) ARKANSAS' 4='(4) ARIZONA' 5='(5) CALIFORNIA' 6='(6) COLORADO' 7='(7) CONNECTICUT' 8='(8) DIST OF COLUMBIA' 9='(9) DELAWARE' 10='(10) FLORIDA' 11='(11) GEORGIA' 12='(12) HAWAII' 13='(13) IOWA' 14='(14) IDAHO' 15='(15) ILLINOIS' 16='(16) INDIANA' 17='(17) KANSAS' 18='(18) KENTUCKY' 19='(19) LOUISIANA' 20='(20) MASSACHUSETTS' 21='(21) MARYLAND' 22='(22) MAINE' 23='(23) MICHIGAN' 24='(24) MINNESOTA' 25='(25) MISSOURI' 26='(26) MISSISSIPPI' 27='(27) MONTANA' 28='(28) NORTH CAROLINA' 29='(29) NORTH DAKOTA' 30='(30) NEBRASKA' 31='(31) NEW HAMPSHIRE' 32='(32) NEW JERSEY' 33='(33) NEW MEXICO' 34='(34) NEVADA' 35='(35) NEW YORK' 36='(36) OHIO' 37='(37) OKLAHOMA' 38='(38) OREGON' 39='(39) PENNSYLVANIA' 40='(40) PUERTO RICO' 41='(41) RHODE ISLAND' 42='(42) SOUTH CAROLINA' 43='(43) SOUTH DAKOTA' 44='(44) TENNESSEE' 45='(45) TEXAS' 46='(46) UTAH' 47='(47) VIRGINIA' 48='(48) VERMONT' 49='(49) WASHINGTON' 50='(50) WISCONSIN' 51='(51) WEST VIRGINIA' 52='(52) WYOMING' ; . . . . VALUE FRSTUS1f -9='MISSING/UNKNOWN/NOT COLLECTED/INVALID' 1='(1) 11 AND UNDER' 2='(2) 12-14' 3='(3) 15-17' 4='(4) 18-20' 5='(5) 21-24' 6='(6) 25-29' 7='(7) 30-34' 8='(8) 35-39' 9='(9) 40-44' 10='(10) 45-49' 11='(11) 50-54' 12='(12) 55 AND OVER' ; VALUE IDU -9='DRUGS USED; NO ROUTES REPORTED' -8='NO SUBSTANCES REPORTED' 0='(0) NO IDU REPORTED' 1='(1) IDU REPORTED' ; VALUE ALCFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE COKEFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE MARFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE HERFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE METHFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE OPSYNFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE PCPFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE HALLFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE MTHAMFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE AMPHFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE STIMFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE BENZFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE TRNQFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE BARBFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE SEDHPFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE INHFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE OTCFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE OTHERFLG 0='(0) SUBSTANCE NOT REPORTED' 1='(1) SUBSTANCE REPORTED' ; VALUE ALCDRUG 0='(0) NONE' 1='(1) ALCOHOL ONLY' 2='(2) OTHER DRUGS ONLY' 3='(3) ALCOHOL AND OTHER DRUGS' ; */ * SAS DATA, INFILE, INPUT STATEMENTS; DATA; INFILE "data-filename" LRECL=122; INPUT CASEID 1-8 YEAR 9-12 STATE 13-14 STFIPS 15-16 PMSA 17-20 CBSA 21-25 REGION 26-27 DIVISION 28-29 SERVSET 30-31 NOPRIOR 32-33 PSOURCE 34-35 GENDER 36-37 AGE 38-39 RACE 40-41 ETHNIC 42-43 EDUC 44-45 EMPLOY 46-47 METHUSE 48-49 PSYPROB 50-51 DSMCRIT 52-53 PREG 54-55 VET 56-57 LIVARAG 58-59 PRIMINC 60-61 HLTHINS 62-63 PRIMPAY 64-65 DETNLF 66-67 DETCRIM 68-69 MARSTAT 70-71 DAYWAIT 72-74 SUB1 75-76 ROUTE1 77-78 FREQ1 79-80 FRSTUSE1 81-82 SUB2 83-84 ROUTE2 85-86 FREQ2 87-88 FRSTUSE2 89-90 SUB3 91-92 ROUTE3 93-94 FREQ3 95-96 FRSTUSE3 97-98 NUMSUBS 99-100 IDU 101-102 ALCFLG 103 COKEFLG 104 MARFLG 105 HERFLG 106 METHFLG 107 OPSYNFLG 108 PCPFLG 109 HALLFLG 110 MTHAMFLG 111 AMPHFLG 112 STIMFLG 113 BENZFLG 114 TRNQFLG 115 BARBFLG 116 SEDHPFLG 117 INHFLG 118 OTCFLG 119 OTHERFLG 120 ALCDRUG 121-122 ; * SAS LABEL STATEMENT; LABEL CASEID = 'CASE IDENTIFICATION NUMBER' YEAR = 'YEAR OF ADMISSION' STATE = 'TEDS STATE CODE' STFIPS = 'CENSUS STATE FIPS CODE' PMSA = 'FIPS 1990 MSA CODE' CBSA = 'FIPS 2000 CBSA CODE' REGION = 'CENSUS REGION' DIVISION= 'CENSUS DIVISION' SERVSET = 'SERVICE SETTING' NOPRIOR = 'NUMBER OF PRIOR TREATMENT EPISODES' PSOURCE = 'PRINCIPAL SOURCE OF REFERRAL' GENDER = 'SEX' AGE = 'AGE RECODE' RACE = 'RACE' ETHNIC = 'ETHNICITY (HISPANIC ORIGIN)' EDUC = 'EDUCATION' EMPLOY = 'EMPLOYMENT STATUS' METHUSE = 'USE OF METHADONE PLANNED' PSYPROB = 'PSYCHIATRIC PROB IN ADDITION TO ALC/DRUG PROB' DSMCRIT = 'DSM DIAGNOSIS' PREG = 'PREGNANT AT TIME OF ADMISSION' VET = 'VETERAN STATUS' LIVARAG = 'LIVING ARRANGEMENT' PRIMINC = 'SOURCE OF INCOME/SUPPORT' HLTHINS = 'HEALTH INSURANCE' PRIMPAY = 'EXPECTED/ACTUAL SOURCE OF PAYMENT' DETNLF = 'DETAILED ''NOT IN LABOR FORCE'' CATEGORY' DETCRIM = 'DETAILED CRIMINAL JUSTICE REFERRAL' MARSTAT = 'MARITAL STATUS' DAYWAIT = 'DAYS WAITING TO ENTER TREATMENT' SUB1 = 'PRIMARY SUBSTANCE PROBLEM CODE' ROUTE1 = 'USUAL ROUTE OF ADMINISTRATION (PRIMARY)' FREQ1 = 'FREQUENCY OF USE (PRIMARY)' FRSTUSE1= 'AGE AT FIRST USE (PRIMARY)' SUB2 = 'SECONDARY SUBSTANCE PROBLEM CODE' ROUTE2 = 'USUAL ROUTE OF ADMINISTRATION (SECONDARY)' FREQ2 = 'FREQUENCY OF USE (SECONDARY)' FRSTUSE2= 'AGE AT FIRST USE (SECONDARY)' SUB3 = 'TERTIARY SUBSTANCE PROBLEM CODE' ROUTE3 = 'USUAL ROUTE OF ADMINISTRATION (TERTIARY)' FREQ3 = 'FREQUENCY OF USE (TERTIARY)' FRSTUSE3= 'AGE AT FIRST USE (TERTIARY)' NUMSUBS = 'NUMBER OF SUBSTANCES REPORTED AT ADM.' IDU = 'CURRENT IV DRUG USE REPORTED AT ADM.' ALCFLG = 'ALCOHOL REPORTED AT ADM.' COKEFLG = 'COCAINE/CRACK REPORTED AT ADM.' MARFLG = 'MARIJUANA/HASHISH REPORTED AT ADM.' HERFLG = 'HEROIN REPORTED AT ADM.' METHFLG = 'NON-RX METHADONE REPORTED AT ADM.' OPSYNFLG= 'OTHER OPIATES/SYNTHETICS REPORTED AT ADM.' PCPFLG = 'PCP REPORTED AT ADM.' HALLFLG = 'HALLUCINOGENS REPORTED AT ADM.' MTHAMFLG= 'METHAMPHETAMINE REPORTED AT ADM.' AMPHFLG = 'OTHER AMPHETAMINES REPORTED AT ADM.' STIMFLG = 'OTHER STIMULANTS REPORTED AT ADM.' BENZFLG = 'BENZODIAZEPINES REPORTED AT ADM.' TRNQFLG = 'OTHER TRANQUILIZERS REPORTED AT ADM.' BARBFLG = 'BARBITURATES REPORTED AT ADM.' SEDHPFLG= 'OTHER SEDATIVES/HYPNOTICS REPORTED AT ADM.' INHFLG = 'INHALANTS REPORTED AT ADM.' OTCFLG = 'OVER-THE-COUNTER MED REPORTED AT ADM.' OTHERFLG= 'OTHER DRUG REPORTED AT ADM.' ALCDRUG = 'SUBSTANCE ABUSE TYPE' ; * USER-DEFINED MISSING VALUES RECODE TO SAS SYSMIS; /* IF (YEAR = -9) THEN YEAR = .; IF (STATE = -9) THEN STATE = .; IF (PMSA = -9) THEN PMSA = .; IF (CBSA = -9) THEN CBSA = .; IF (REGION = -9) THEN REGION = .; IF (DIVISION = -9) THEN DIVISION = .; IF (SERVSET = -9) THEN SERVSET = .; IF (NOPRIOR = -9) THEN NOPRIOR = .; IF (PSOURCE = -9) THEN PSOURCE = .; IF (GENDER = -9) THEN GENDER = .; IF (AGE = -9) THEN AGE = .; IF (RACE = -9) THEN RACE = .; IF (ETHNIC = -9) THEN ETHNIC = .; IF (EDUC = -9) THEN EDUC = .; IF (EMPLOY = -9) THEN EMPLOY = .; IF (METHUSE = -9) THEN METHUSE = .; IF (PSYPROB = -9) THEN PSYPROB = .; IF (DSMCRIT = -9) THEN DSMCRIT = .; IF (PREG = -9) THEN PREG = .; IF (VET = -9) THEN VET = .; IF (LIVARAG = -9) THEN LIVARAG = .; IF (PRIMINC = -9) THEN PRIMINC = .; IF (HLTHINS = -9) THEN HLTHINS = .; IF (PRIMPAY = -9) THEN PRIMPAY = .; IF (DETNLF = -9) THEN DETNLF = .; IF (DETCRIM = -9) THEN DETCRIM = .; IF (MARSTAT = -9) THEN MARSTAT = .; IF (DAYWAIT = -9) THEN DAYWAIT = .; IF (SUB1 = -9) THEN SUB1 = .; IF (ROUTE1 = -9) THEN ROUTE1 = .; IF (FREQ1 = -9) THEN FREQ1 = .; IF (FRSTUSE1 = -9) THEN FRSTUSE1 = .; IF (SUB2 = -9) THEN SUB2 = .; IF (ROUTE2 = -9) THEN ROUTE2 = .; IF (FREQ2 = -9) THEN FREQ2 = .; IF (FRSTUSE2 = -9) THEN FRSTUSE2 = .; IF (SUB3 = -9) THEN SUB3 = .; IF (ROUTE3 = -9) THEN ROUTE3 = .; IF (FREQ3 = -9) THEN FREQ3 = .; IF (FRSTUSE3 = -9) THEN FRSTUSE3 = .; IF (IDU <= -8) THEN IDU = .; IF (ALCDRUG <= -9) THEN ALCDRUG = .; */ * SAS FORMAT STATEMENT; /* FORMAT YEAR YEARffff. STATE STATE. STFIPS STFIPS. PMSA PMSA. CBSA CBSA. REGION REGION. DIVISION DIVISION. SERVSET SERVSET. NOPRIOR NOPRIOR. PSOURCE PSOURCE. GENDER GENDER. AGE AGE. RACE RACE. ETHNIC ETHNIC. EDUC EDUC. EMPLOY EMPLOY. METHUSE METHUSE. PSYPROB PSYPROB. DSMCRIT DSMCRIT. PREG PREG. VET VET. LIVARAG LIVARAG. PRIMINC PRIMINC. HLTHINS HLTHINS. PRIMPAY PRIMPAY. DETNLF DETNLF. DETCRIM DETCRIM. MARSTAT MARSTAT. DAYWAIT DAYWAIT. SUB1 SUB1ffff. ROUTE1 ROUTE1ff. FREQ1 FREQ1fff. FRSTUSE1 FRSTUSEf. SUB2 SUB2ffff. ROUTE2 ROUTE2ff. FREQ2 FREQ2fff. FRSTUSE2 FRSTUS0f. SUB3 SUB3ffff. ROUTE3 ROUTE3ff. FREQ3 FREQ3fff. FRSTUSE3 FRSTUS1f. IDU IDU. ALCFLG ALCFLG. COKEFLG COKEFLG. MARFLG MARFLG. HERFLG HERFLG. METHFLG METHFLG. OPSYNFLG OPSYNFLG. PCPFLG PCPFLG. HALLFLG HALLFLG. MTHAMFLG MTHAMFLG. AMPHFLG AMPHFLG. STIMFLG STIMFLG. BENZFLG BENZFLG. TRNQFLG TRNQFLG. BARBFLG BARBFLG. SEDHPFLG SEDHPFLG. INHFLG INHFLG. OTCFLG OTCFLG. OTHERFLG OTHERFLG. ALCDRUG ALCDRUG. ; */ RUN ;