File: "CROSTABS OUTPUT 1994 data" run after transfer from one unix to another computer and then copied to personal computer. This program was used for 1993-1994 national study with enghan94 and alc25714 among other data bases and is an example of an output. [Data from enghan94 are found in followwing spaces to identify variables}. 00s 10s 20s 30s 40s 50s 60s 70s 123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789* 20551211121k4215421312111355433545535553110112111221211212212112112111 5 121222112122212112222222 l001 20551211219j2111223343411345555545555535140202212221210010012112120101 5 201221112122211112211222 l002 20551211122l3314321352435111554534555433330120212121112212212212112111 5 111122112222211111121122 l003 20551211219e2311122553412114554524555355120500211220000010002210000100 5 000022102022212111111122 l004 20551211219j2313334542242222555545555555110212211221001112002100110101 5 000110111161212112111222 l005] K= knowledge test and V = Codependency (CODE) scale. **EXAMPLE OF SPSS RUN** 08 Jul 02 SPSS for Unix, Release 6.14 (SunOS) Page 1 13:47:54 steel SUN SPARC Solaris For Solaris steel SPSS ID 17076001 1 0 TITLE BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO 2 0 DATA LIST FILE= "../data/enghan94.dat" RECORDS=2 3 0 /1 REG 1 SCHOOL 2 NAME 3-4 COMM 5 SIZE 6 TYPE 7 DPT 8 SEX 9 4 0 AGE 10-11 MAJOR 12 (A) CLASS 13 GPA 14 RACE 15 RELIG 16 ROS 17 5 0 BEFREQ 18 BEAMT 19 WINE 20 WINAMT 21 LIQ 22 LIQAMT 23 6 0 HANGOR 24 VOMIT 25 DRIVCAR 26 DRCARK 27 DWDRIV 28 CLASSDR 29 CUTCLASD 30 7 0 MISHANG 31 DWI 32 CRITIC 33 LAW 34 JOBLOST 35 LOWGRADE 36 SCHADMIN 37 8 0 FIGHT 38 TINKPROB 39 DAMAGE 40 game 41 SMKf 42 SMKq 43-44 K1 TO K26 45-70 9 0 /2 TIME 1 K27 to k36 9-18 v1 to v11 19-29 ID 30 FRAT 31 RAPE 32 This command will read 2 records from ../data/enghan94.dat Variable Rec Start End Format REG 1 1 1 F1.0 SCHOOL 1 2 2 F1.0 NAME 1 3 4 F2.0 COMM 1 5 5 F1.0 SIZE 1 6 6 F1.0 TYPE 1 7 7 F1.0 DPT 1 8 8 F1.0 SEX 1 9 9 F1.0 AGE 1 10 11 F2.0 MAJOR 1 12 12 A1 CLASS 1 13 13 F1.0 GPA 1 14 14 F1.0 RACE 1 15 15 F1.0 RELIG 1 16 16 F1.0 ROS 1 17 17 F1.0 BEFREQ 1 18 18 F1.0 BEAMT 1 19 19 F1.0 WINE 1 20 20 F1.0 WINAMT 1 21 21 F1.0 LIQ 1 22 22 F1.0 LIQAMT 1 23 23 F1.0 HANGOR 1 24 24 F1.0 VOMIT 1 25 25 F1.0 DRIVCAR 1 26 26 F1.0 DRCARK 1 27 27 F1.0 DWDRIV 1 28 28 F1.0 CLASSDR 1 29 29 F1.0 CUTCLASD 1 30 30 F1.0 MISHANG 1 31 31 F1.0 DWI 1 32 32 F1.0 CRITIC 1 33 33 F1.0 LAW 1 34 34 F1.0 JOBLOST 1 35 35 F1.0 LOWGRADE 1 36 36 F1.0 SCHADMIN 1 37 37 F1.0 FIGHT 1 38 38 F1.0 TINKPROB 1 39 39 F1.0 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 2 13:47:54 steel SUN SPARC Solaris DAMAGE 1 40 40 F1.0 GAME 1 41 41 F1.0 SMKF 1 42 42 F1.0 SMKQ 1 43 44 F2.0 K1 1 45 45 F1.0 K2 1 46 46 F1.0 K3 1 47 47 F1.0 K4 1 48 48 F1.0 K5 1 49 49 F1.0 K6 1 50 50 F1.0 K7 1 51 51 F1.0 K8 1 52 52 F1.0 K9 1 53 53 F1.0 K10 1 54 54 F1.0 K11 1 55 55 F1.0 K12 1 56 56 F1.0 K13 1 57 57 F1.0 K14 1 58 58 F1.0 K15 1 59 59 F1.0 K16 1 60 60 F1.0 K17 1 61 61 F1.0 K18 1 62 62 F1.0 K19 1 63 63 F1.0 K20 1 64 64 F1.0 K21 1 65 65 F1.0 K22 1 66 66 F1.0 K23 1 67 67 F1.0 K24 1 68 68 F1.0 K25 1 69 69 F1.0 K26 1 70 70 F1.0 TIME 2 1 1 F1.0 **begins second line** K27 2 9 9 F1.0 K28 2 10 10 F1.0 K29 2 11 11 F1.0 K30 2 12 12 F1.0 K31 2 13 13 F1.0 K32 2 14 14 F1.0 K33 2 15 15 F1.0 K34 2 16 16 F1.0 K35 2 17 17 F1.0 K36 2 18 18 F1.0 V1 2 19 19 F1.0 V2 2 20 20 F1.0 V3 2 21 21 F1.0 V4 2 22 22 F1.0 V5 2 23 23 F1.0 V6 2 24 24 F1.0 V7 2 25 25 F1.0 V8 2 26 26 F1.0 V9 2 27 27 F1.0 V10 2 28 28 F1.0 V11 2 29 29 F1.0 ID 2 30 30 F1.0 FRAT 2 31 31 F1.0 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 3 13:47:54 steel SUN SPARC Solaris RAPE 2 32 32 F1.0 10 0 IF (AGE GT 16 OR AGE LE 20)AGE1=1 11 0 IF (AGE EQ 21)AGE1=3 12 0 IF (AGE GE 22)AGE1=2 13 0 IF (RACE EQ 1)RACE1=1 14 0 IF (RACE EQ 2)RACE1=2 15 0 IF (RACE EQ 3)RACE1=3 16 0 IF (RACE EQ 4)RACE1=4 17 0 IF (RACE EQ 5)RACE1=5 18 0 IF (RACE EQ 6)RACE1=6 19 0 IF (TIME EQ 5 AND RACE EQ 7 AND RELIG EQ 1)RACE1 =1 20 0 IF (TIME EQ 5 AND RACE EQ 7 AND RELIG EQ 3)RACE1=1 21 0 IF (TIME EQ 5 AND RACE EQ 7 AND RELIG EQ 4)RACE1=1 22 0 IF (TIME EQ 5 AND RACE EQ 8)RACE1=1 23 0 IF (TIME EQ 5 AND RACE EQ 9)RACE1=1 24 0 RECODE MAJOR ("A"=1)("B"=2)("C"=1)("D"=1)("E"=5)("F"=1) 25 0 ("G"=7)("H"=10)("I"=1)("J"=10)("K"=11)("L"=7) 26 0 ("M"=11)("N"=1)("O"=15)("P"=16)("Q"=1)("R"=15) 27 0 ("S"=11)("T"=11)("U"=16) INTO MAJORA 28 0 VALUE LABELS 29 0 ID TO RAPE 1 'YES' 2 'NO' 30 0 HANGOR TO GAME 5 'AT LEAST 1,1LST YR' >Warning # 4492 on line 30 in column 4. Text: HANGOR >Warning # 4492 on line 30 in column 4. Text: HANGOR >The (ADD) VALUE LABELS command included a symbol other than a value where a >The (ADD) VALUE LABELS command included a symbol other than a value where a >value (either numeric or string) was expected. For compatibility with >value (either numeric or string) was expected. For compatibility with >previous systems, a parenthesized value would have been acceptable. All >previous systems, a parenthesized value would have been acceptable. All >value labels up to the next slash will be ignored. >value labels up to the next slash will be ignored. 31 0 4 'AT LEAST 1,2M,NOT YR' 32 0 3 'NOT DUR 2M,1 LST YR' 33 0 2 'ONCE IN MY LIFE' 34 0 1 'NOT HAPPENED'/ 35 0 REGION 1 'NE' 2 'NC' 3 'S' 4 'W'/ 36 0 COMM 1 'LESS 10,000' 2 'BET 100-500 THOUS' 3 'GT 500,000'/ 37 0 SIZE 1 'LT 10,000' 2 'CT 10,000'/ 38 0 TYPE 1 'PUBLIC' 2 'PRIVATE'/ 39 0 SCHOOL 9 'CATHOLIC' 8 'PROT' 7 'BLACK' 6 'OTHER'/ 40 0 SEX 1 'MALE' 2 'FEMALE'/ 41 0 CLASS 1 'FRESH' 2 'SOPH' 3 'JUNIOR' 4 'SENIOR' 5 'OTHER'/ 42 0 GPA 1 '4' 2 '3.5' 3 '3.0' 4 '2.5' 5 '2.0' 6 'LT 2.0'/ 43 0 RACE1 1 'WHITE' 2 'BLACK' 3 'HISPANIC' 4 'ORIENTAL' 5 'IND' 6 'OTHER'/ 44 0 RELIG 1 'R.C.' 2 'JEW' 3 'PROT, ALLOW DRNK' 4 'PROT, NOT DRNK' 45 0 6 'OTHER'/ 46 0 BEAMT WINAMT LIQAMT 5 '6+ GLASSES' 4 '5-6 GLASSES' 3 '3-4 GLASSES' 47 0 2 '1-2 GLASSES' 1 'LESS THAN 1 GLASS'/ 48 0 MAJORA 1 'SOCIAL SCI' 2 'ARTS/HUM' 3 'PSYCH' 4 'PRE-SOCIAL' 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 4 13:47:54 steel SUN SPARC Solaris 49 0 5 'NURSING' 6 'PRE-LAW' 7 'EDUCATION' 8 'PRE-MED' 9 'FORENSICS' 50 0 10 'HEALTH SCI' 11 'PHYSICAL SCI' 12 'HPER' 13 'ENGINEERING' 51 0 14 'RELIGION' 15 'OTHER/UNDEC' 16 'BUSINESS' 17 'TELECOM' 52 0 18 'GENERAL STUDIES' 19 'COMPUTER SCI' 20 'BIOLOGY' 21 'ECON'/ 53 0 BEFREQ WINE LIQ 5 'EVERY DAT' 4 'AT LE 1ST WK NOT DAT' 54 0 3 'ONCE MO,LESS WK' 2 'ONCE A YR,LESS MO' 1 'ONCE A YR OR LESS' 55 0 0 'NOT AT ALL'/ 56 0 ROS 1 'VERY IMPT' 2 'NOT IMPT' 57 0 RECODE SCHOOL (0,1,2,3,4,5=6) 58 0 RECODE BEFREQ TO GAME (1=5)(2=4)(4=2)(5=1) 59 0 MISSING VALUES CLASS TO V11(9999) 60 0 MISSING VALUES MAJOR('9') 61 0 COMMENT KEEP MIS DAT 82 _ 71 DATA NOT 75.BLNK IS NO DRNK 62 0 IF (SEX GT 2 OR SEX LT 0)SEX=0 63 0 COMMENT CALCULATIONS TO GET ABS ALC FROM MOST FRQ DRUNK BEV 64 0 IF (BEFREQ LE 1 AND LIQ LE 1 AND WINE LE 1)TOTAL=1 65 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 2 AND BEAMT GE 2)TOTAL=2 66 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 2 AND BEAMT EQ 1)TOTAL=1 67 0 IF (LIQ GT BEFREQ AND LIQ EQ 2 AND LIQAMT EQ 1)TOTAL=1 68 0 IF (LIQ GT BEFREQ AND LIQ EQ 2 AND LIQAMT GE 2)TOTAL=2 69 0 IF (LIQ GT BEFREQ AND LIQ EQ 2 AND LIQAMT EQ 0)TOTAL=1 70 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 2 AND BEAMT EQ 0)TOTAL=1 71 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 3 AND BEAMT EQ 1)TOTAL=1 72 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 3 AND BEAMT EQ 2)TOTAL=3 73 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 3 AND BEAMT EQ 0)TOTAL=1 74 0 IF (LIQ GT BEFREQ AND LIQ EQ 3 AND LIQAMT EQ 2)TOTAL=3 75 0 IF (LIQ GT BEFREQ AND LIQ EQ 3 AND LIQAMT EQ 1)TOTAL=1 76 0 IF (LIQ GT BEFREQ AND LIQ EQ 3 AND LIQAMT EQ 0)TOTAL=1 77 0 IF (LIQ GT BEFREQ AND LIQ EQ 4 AND LIQAMT EQ 0)TOTAL=1 78 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 4 AND BEAMT EQ 0)TOTAL=1 79 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 4 AND BEAMT EQ 1)TOTAL=4 80 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 4 AND BEAMT EQ 2)TOTAL=4 81 0 IF (LIQ GT BEFREQ AND LIQ EQ 4 AND LIQAMT EQ 2)TOTAL=4 82 0 IF (LIQ GT BEFREQ AND LIQ EQ 4 AND LIQAMT EQ 1)TOTAL=4 83 0 IF (LIQ GT BEFREQ AND LIQ EQ 3 AND LIQAMT EQ 3)TOTAL=4 84 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 3 AND BEAMT EQ 3)TOTAL=4 85 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 5 AND BEAMT EQ 0)TOTAL=1 86 0 IF (LIQ GT BEFREQ AND LIQ EQ 5 AND LIQAMT EQ 0)TOTAL=1 87 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 5 AND BEAMT EQ 1)TOTAL=4 88 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 5 AND BEAMT EQ 2)TOTAL=5 89 0 IF (LIQ GT BEFREQ AND LIQ EQ 5 AND LIQAMT EQ 2)TOTAL=5 90 0 IF (LIQ GT BEFREQ AND LIQ EQ 5 AND LIQAMT EQ 1)TOTAL=4 91 0 IF (LIQ GT BEFREQ AND LIQ EQ 3 AND LIQAMT GE 4)TOTAL=5 92 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 3 AND BEAMT GE 4)TOTAL=5 93 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 4 AND BEAMT EQ 3)TOTAL=5 94 0 IF (LIQ GT BEFREQ AND LIQ EQ 4 AND LIQAMT EQ 3)TOTAL=5 95 0 IF (LIQ GT BEFREQ AND LIQ EQ 5 AND LIQAMT EQ 3)TOTAL=5 96 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 5 AND BEAMT EQ 3)TOTAL=5 97 0 IF (LIQ GT BEFREQ AND LIQ EQ 5 AND LIQAMT GE 4)TOTAL=6 98 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 5 AND BEAMT GE 4)TOTAL=6 99 0 IF (BEFREQ GE LIQ AND BEFREQ EQ 4 AND BEAMT GE 4)TOTAL=6 100 0 IF (LIQ GT BEFREQ AND LIQ EQ 4 AND LIQAMT GE 4)TOTAL=6 101 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 2 AND WINAMT GE 1) 102 0 TOTAL=1 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 5 13:47:54 steel SUN SPARC Solaris 103 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 2 AND WINAMT GE 0) 104 0 TOTAL=1 105 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 3 AND WINAMT EQ 1) 106 0 TOTAL=1 107 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 3 AND WINAMT EQ 2) 108 0 TOTAL=3 109 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 3 AND WINAMT EQ 0) 110 0 TOTAL=1 111 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 4 AND WINAMT EQ 0) 112 0 TOTAL=1 113 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 4 AND WINAMT EQ 1) 114 0 TOTAL=4 115 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 4 AND WINAMT EQ 2) 116 0 TOTAL=4 117 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 3 AND WINAMT EQ 3) 118 0 TOTAL=4 119 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 4 AND WINAMT EQ 3) 120 0 TOTAL=5 121 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 5 AND WINAMT EQ 0) 122 0 TOTAL=1 123 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 5 AND WINAMT EQ 1) 124 0 TOTAL=4 125 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 5 AND WINAMT EQ 2) 126 0 TOTAL=5 127 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 5 AND WINAMT GE 3) 128 0 TOTAL=5 129 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 4 AND WINAMT GE 4) 130 0 TOTAL=6 131 0 IF (WINE GT BEFREQ AND WINE GT LIQ AND WINE EQ 3 AND WINAMT GE 4) 132 0 TOTAL=5 133 0 COMMENT CALCULATIONS TO GET ABSOLUTE ALC FROM EACH DRINK 134 0 IF (BEFREQ LE 1 )TOTALB=1 135 0 IF (BEFREQ EQ 2 AND BEAMT GE 2)TOTALB=2 136 0 IF (BEFREQ EQ 2 AND BEAMT EQ 1)TOTALB=1 137 0 IF (LIQ EQ 2 AND LIQAMT EQ 1)TOTALL=1 138 0 IF (LIQ EQ 2 AND LIQAMT GE 2)TOTALL=2 139 0 IF (LIQ EQ 2 AND LIQAMT EQ 0)TOTALL=1 140 0 IF (BEFREQ EQ 2 AND BEAMT EQ 0)TOTALB=1 141 0 IF (BEFREQ EQ 3 AND BEAMT EQ 1)TOTALB=1 142 0 IF (BEFREQ EQ 3 AND BEAMT EQ 2)TOTALB=3 143 0 IF (BEFREQ EQ 3 AND BEAMT EQ 0)TOTALB=1 144 0 IF (LIQ EQ 3 AND LIQAMT EQ 2)TOTALL=3 145 0 IF (LIQ EQ 3 AND LIQAMT EQ 1)TOTALL=1 146 0 IF (LIQ EQ 3 AND LIQAMT EQ 0)TOTALL=1 147 0 IF (LIQ EQ 4 AND LIQAMT EQ 0)TOTALL=1 148 0 IF (BEFREQ EQ 4 AND BEAMT EQ 0)TOTALB=1 149 0 IF (BEFREQ EQ 4 AND BEAMT EQ 1)TOTALB=4 150 0 IF (BEFREQ EQ 4 AND BEAMT EQ 2)TOTALB=4 151 0 IF (LIQ EQ 4 AND LIQAMT EQ 2)TOTALL=4 152 0 IF (LIQ EQ 4 AND LIQAMT EQ 1)TOTALL=4 153 0 IF (LIQ EQ 3 AND LIQAMT EQ 3)TOTALL=4 154 0 IF (BEFREQ EQ 3 AND BEAMT EQ 3)TOTALB=4 155 0 IF (BEFREQ EQ 5 AND BEAMT EQ 0)TOTALB=1 156 0 IF (LIQ EQ 5 AND LIQAMT EQ 0)TOTALL=1 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 6 13:47:54 steel SUN SPARC Solaris 157 0 IF (BEFREQ EQ 5 AND BEAMT EQ 1)TOTALB=4 158 0 IF (BEFREQ EQ 5 AND BEAMT EQ 2)TOTALB=5 159 0 IF (LIQ EQ 5 AND LIQAMT EQ 2)TOTALL=5 160 0 IF (LIQ EQ 5 AND LIQAMT EQ 1)TOTALL=4 161 0 IF ( LIQ EQ 3 AND LIQAMT GE 4)TOTALL=5 162 0 IF (BEFREQ EQ 3 AND BEAMT GE 4)TOTALL=5 163 0 IF (BEFREQ EQ 4 AND BEAMT EQ 3)TOTALL=5 164 0 IF (LIQ EQ 4 AND LIQAMT EQ 3)TOTALL=5 165 0 IF (LIQ EQ 5 AND LIQAMT EQ 3)TOTALL=5 166 0 IF (BEFREQ EQ 5 AND BEAMT EQ 3)TOTALL=5 167 0 IF (LIQ EQ 5 AND LIQAMT GE 4)TOTALL=6 168 0 IF (BEFREQ EQ 5 AND BEAMT GE 4)TOTALB=6 169 0 IF (BEFREQ EQ 4 AND BEAMT GE 4)TOTALB=6 170 0 IF (LIQ EQ 4 AND LIQAMT GE 4)TOTALL=6 171 0 IF (WINE EQ 2 AND WINAMT GE 1) 172 0 TOTALW=1 173 0 IF (WINE EQ 2 AND WINAMT GE 0) 174 0 TOTALW=1 175 0 IF ( WINE EQ 3 AND WINAMT EQ 1) 176 0 TOTALW=1 177 0 IF (WINE EQ 3 AND WINAMT EQ 2) 178 0 TOTALW=3 179 0 IF (WINE EQ 3 AND WINAMT EQ 0) 180 0 TOTALW=1 181 0 IF (WINE EQ 4 AND WINAMT EQ 0) 182 0 TOTALW=1 183 0 IF (WINE EQ 4 AND WINAMT EQ 1) 184 0 TOTALW=4 185 0 IF (WINE EQ 4 AND WINAMT EQ 2) 186 0 TOTALW=4 187 0 IF (WINE EQ 3 AND WINAMT EQ 3) 188 0 TOTALW=4 189 0 IF (WINE EQ 4 AND WINAMT EQ 3) 190 0 TOTALW=5 191 0 IF (WINE EQ 5 AND WINAMT EQ 0) 192 0 TOTALW=1 193 0 IF (WINE EQ 5 AND WINAMT EQ 1) 194 0 TOTALW=4 195 0 IF (WINE EQ 5 AND WINAMT EQ 2) 196 0 TOTALW=5 197 0 IF (WINE EQ 5 AND WINAMT GE 3) 198 0 TOTALW=5 199 0 IF (WINE EQ 4 AND WINAMT GE 4) 200 0 TOTALW=6 201 0 IF (WINE EQ 3 AND WINAMT GE 4) 202 0 TOTALW=5 203 0 IF (RACE1 EQ 1)ETHNIC=1 204 0 IF (RACE1 EQ 2)ETHNIC=2 205 0 IF (RACE1 EQ 3)ETHNIC=3 206 0 IF (RACE1 EQ 4)ETHNIC=4 207 0 IF (RACE1 EQ 5)ETHNIC=5 208 0 IF (TOTAL EQ 1)COLAPS=1 209 0 IF (TOTAL EQ 2)COLAPS=1 210 0 IF (TOTAL EQ 3)COLAPS=1 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 7 13:47:54 steel SUN SPARC Solaris 211 0 IF (TOTAL EQ 4)COLAPS=1 212 0 IF (TOTAL EQ 5)COLAPS=1 213 0 IF (TOTAL EQ 6)COLAPS=2 214 0 VALUE LABELS TOTAL 1 'NEVER' 2 'INFREQ' 3 'LIGHT' 4 'MODER' 5 'HEAMOD' 215 0 6 'HEAV'/ 216 0 ETHNIC 1 'WHITE' 2 'BLACK'/ 217 0 COLAPS 1 'LIGHT' 2 'MEDIUM' 3 'HEAVY' 218 0 RECODE ROS (2=1) (3,4=2) 219 0 COMMENT RACE1 2=NONWHITE 220 0 RECODE RACE1(5,4,3=2) 221 0 RECODE HANGOR TO SMKf (5,4=3)(2=1) 222 0 223 0 CROSSTABS VARIABLES=SEX(1,2) HANGOR TO SMKf(1,3) ID TO RAPE(1,2) / 224 0 TABLES=SEX BY ID TO RAPE HANGOR TO SMKf/ 225 0 OPTIONS 1 18 226 0 STATISTICS ALL Integer CROSSTABS needs 1,128 bytes of memory. **THREE EXAMPLES FROM THE OUTPUT OF THIS RUN ARE FOUND BELOW** 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 10 13:48:11 steel SUN SPARC Solaris SEX by ID (**USING FAKE ID**) ID Page 1 of 1 Count | Exp Val | Row Pct | Col Pct | Tot Pct | Residual|YES NO Std Res | Row Adj Res | 1 | 2 | Total SEX --------+--------+--------+ 1 | 1001 | 3557 | 4558 MALE | 888.0 |3670.0 | 38.6% | 22.0% | 78.0% | | 43.5% | 37.4% | | 8.5% | 30.1% | | 113.0 |-113.0 | | 3.8 | -1.9 | | 5.4 | -5.4 | +--------+--------+ 2 | 1301 | 5957 | 7258 FEMALE |1414.0 |5844.0 | 61.4% | 17.9% | 82.1% | | 56.5% | 62.6% | | 11.0% | 50.4% | |-113.0 | 113.0 | | -3.0 | 1.5 | | -5.4 | 5.4 | +--------+--------+ Column 2302 9514 11816 Total 19.5% 80.5% 100.0% Chi-Square Value DF Significance -------------------- ----------- ---- ------------ Pearson 29.07826 1 .00000 Continuity Correction 28.82152 1 .00000 Likelihood Ratio 28.77730 1 .00000 Mantel-Haenszel test for 29.07580 1 .00000 linear association Minimum Expected Frequency - 887.992 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 11 13:48:11 steel SUN SPARC Solaris Approximate Statistic Value ASE1 Val/ASE0 Significance -------------------- --------- -------- -------- ------------ Phi .04961 .00000 *1 Cramer's V .04961 .00000 *1 Contingency Coefficient .04955 .00000 *1 Lambda : symmetric .00000 .00000 with SEX dependent .00000 .00000 with ID dependent .00000 .00000 Goodman & Kruskal Tau : with SEX dependent .00246 .00093 .00000 *2 with ID dependent .00246 .00093 .00000 *2 Uncertainty Coefficient : symmetric .00210 .00079 2.67016 .00000 *3 with SEX dependent .00183 .00068 2.67016 .00000 *3 with ID dependent .00247 .00092 2.67016 .00000 *3 Kappa .04446 .00837 5.39243 Kendall's Tau-b .04961 .00933 5.30450 Kendall's Tau-c .03826 .00721 5.30450 Gamma .12608 .02317 5.30450 Somers' D : symmetric .04857 .00914 5.30450 with SEX dependent .06097 .01146 5.30450 with ID dependent .04036 .00761 5.30450 Pearson's R .04961 .00933 5.39862 .00000 *4 Spearman Correlation .04961 .00933 5.39862 .00000 *4 Eta : with SEX dependent .04961 with ID dependent .04961 *1 Pearson chi-square probability *2 Based on chi-square approximation *3 Likelihood ratio chi-square probability *4 VAL/ASE0 is a t-value based on a normal approximation, as is the significance Statistic Value 95% Confidence Bounds -------------------- -------- ----------------------- Relative Risk Estimate (SEX 1 / SEX 2) : case control 1.28855 1.17496 1.41311 cohort (ID 1 Risk) 1.22518 1.13823 1.31876 cohort (ID 2 Risk) .95082 .93313 .96885 Number of Missing Observations: 202 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 12 SEX by HANGOR (**HANGOVER**) HANGOR Page 1 of 1 Count | Exp Val | Row Pct | Col Pct | Tot Pct | Residual| Std Res | Row Adj Res | 1| 3| Total SEX --------+------+------+ 1 | 1378| 2807| 4185 MALE |1664.2|2520.8| 39.1% | 32.9%| 67.1%| | 32.4%| 43.6%| | 12.9%| 26.2%| |-286.2| 286.2| | -7.0| 5.7| | -11.6| 11.6| +------+------+ 2 | 2875| 3635| 6510 FEMALE |2588.8|3921.2| 60.9% | 44.2%| 55.8%| | 67.6%| 56.4%| | 26.9%| 34.0%| | 286.2|-286.2| | 5.6| -4.6| | 11.6| -11.6| +------+------+ Column 4253 6442 10695 Total 39.8% 60.2% 100.0% Chi-Square Value DF Significance -------------------- ----------- ---- ------------ Pearson 134.25852 1 .00000 Continuity Correction 133.78985 1 .00000 Likelihood Ratio 135.60885 1 .00000 Mantel-Haenszel test for 134.24597 1 .00000 linear association Minimum Expected Frequency - 1664.217 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 17 13:48:11 steel SUN SPARC Solaris Approximate Statistic Value ASE1 Val/ASE0 Significance -------------------- --------- -------- -------- ------------ Phi -.11204 .00000 *1 Cramer's V .11204 .00000 *1 Contingency Coefficient .11135 .00000 *1 Lambda : symmetric .00000 .00000 with SEX dependent .00000 .00000 with HANGOR dependent .00000 .00000 Goodman & Kruskal Tau : with SEX dependent .01255 .00213 .00000 *2 with HANGOR dependent .01255 .00213 .00000 *2 Uncertainty Coefficient : symmetric .00945 .00161 5.86590 .00000 *3 with SEX dependent .00947 .00161 5.86590 .00000 *3 with HANGOR dependent .00943 .00161 5.86590 .00000 *3 Kendall's Tau-b -.11204 .00949 -11.7856 Kendall's Tau-c -.10705 .00908 -11.7856 Gamma -.23404 .01951 -11.7856 Somers' D : symmetric -.11204 .00949 -11.7856 with SEX dependent -.11173 .00947 -11.7856 with HANGOR dependent -.11236 .00952 -11.7856 Pearson's R -.11204 .00949 -11.6593 .00000 *4 Spearman Correlation -.11204 .00949 -11.6593 .00000 *4 Eta : with SEX dependent .11204 with HANGOR dependent .11204 >Warning # 10391 >Warning # 10391 >Kappa cannot be computed for this table because variable value ranges for >Kappa cannot be computed for this table because variable value ranges for >row and column variables are not the same. >row and column variables are not the same. *1 Pearson chi-square probability *2 Based on chi-square approximation *3 Likelihood ratio chi-square probability *4 VAL/ASE0 is a t-value based on a normal approximation, as is the significance 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 18 13:48:11 steel SUN SPARC Solaris Statistic Value 95% Confidence Bounds -------------------- -------- ----------------------- Relative Risk Estimate (SEX 1 / SEX 2) : case control .62069 .57244 .67301 cohort (HANGOR 1 Risk) .74558 .70841 .78471 cohort (HANGOR 3 Risk) 1.20122 1.16539 1.23816 Number of Missing Observations: 1323 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 19 13:48:11 steel SUN SPARC Solaris 13:48:11 steel SUN SPARC Solaris Number of Missing Observations: 1335 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 70 13:48:11 steel SUN SPARC Solaris SEX by SMKF (**FREQUENCY OF SMOKING**) SMKF Page 1 of 1 Count | Exp Val | Row Pct | Col Pct | Tot Pct | Residual| Std Res | Row Adj Res | 1| 3| Total SEX --------+------+------+ 1 | 733| 3729| 4462 MALE | 759.2|3702.8| 38.8% | 16.4%| 83.6%| | 37.4%| 39.0%| | 6.4%| 32.4%| | -26.2| 26.2| | -1.0| .4| | -1.3| 1.3| +------+------+ 2 | 1225| 5821| 7046 FEMALE |1198.8|5847.2| 61.2% | 17.4%| 82.6%| | 62.6%| 61.0%| | 10.6%| 50.6%| | 26.2| -26.2| | .8| -.3| | 1.3| -1.3| +------+------+ Column 1958 9550 11508 Total 17.0% 83.0% 100.0% Chi-Square Value DF Significance -------------------- ----------- ---- ------------ Pearson 1.77629 1 .18261 Continuity Correction 1.70908 1 .19111 Likelihood Ratio 1.78247 1 .18185 Mantel-Haenszel test for 1.77614 1 .18262 linear association Minimum Expected Frequency - 759.176 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 71 13:48:11 steel SUN SPARC Solaris Approximate Statistic Value ASE1 Val/ASE0 Significance -------------------- --------- -------- -------- ------------ Phi -.01242 .18261 *1 Cramer's V .01242 .18261 *1 Contingency Coefficient .01242 .18261 *1 Lambda : symmetric .00000 .00000 with SEX dependent .00000 .00000 with SMKF dependent .00000 .00000 Goodman & Kruskal Tau : with SEX dependent .00015 .00023 .18262 *2 with SMKF dependent .00015 .00023 .18262 *2 Uncertainty Coefficient : symmetric .00014 .00021 .66874 .18185 *3 with SEX dependent .00012 .00017 .66874 .18185 *3 with SMKF dependent .00017 .00025 .66874 .18185 *3 Kendall's Tau-b -.01242 .00927 -1.33963 Kendall's Tau-c -.00910 .00679 -1.33963 Gamma -.03410 .02557 -1.33963 Somers' D : symmetric -.01202 .00897 -1.33963 with SEX dependent -.01611 .01202 -1.33963 with SMKF dependent -.00958 .00715 -1.33963 Pearson's R -.01242 .00927 -1.33276 .18264 *4 Spearman Correlation -.01242 .00927 -1.33276 .18264 *4 Eta : with SEX dependent .01242 with SMKF dependent .01242 >Warning # 10391 >Warning # 10391 >Kappa cannot be computed for this table because variable value ranges for >Kappa cannot be computed for this table because variable value ranges for >row and column variables are not the same. >row and column variables are not the same. *1 Pearson chi-square probability *2 Based on chi-square approximation *3 Likelihood ratio chi-square probability *4 VAL/ASE0 is a t-value based on a normal approximation, as is the significance 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 72 13:48:11 steel SUN SPARC Solaris Statistic Value 95% Confidence Bounds -------------------- -------- ----------------------- Relative Risk Estimate (SEX 1 / SEX 2) : case control .93406 .84489 1.03264 cohort (SMKF 1 Risk) .94489 .86920 1.02716 cohort (SMKF 3 Risk) 1.01160 .99469 1.02879 Number of Missing Observations: 510 08 Jul 02 BOOZE INDIANA UNIVERSITY 1993 DRINKERS DEMO Page 73 13:48:11 steel SUN SPARC Solaris Preceding task required 16.09 seconds CPU time; 16.52 seconds elapsed. 227 0 finish 227 command lines read. 0 errors detected. 34 warnings issued. 16 seconds CPU time. 17 seconds elapsed time. End of job. End of job: 227 command lines 0 errors 34 warnings 16 CPU seconds