|
|
|
SPSS Incident Level Flat File
This snapshot illustrates the large flat file in SPSS that results from the creating of
the
new variables and the assignment of values for the purpose of counting occurrences
in incidents. These new variables (V_AGE through INC_LOC) are appended to the
existing flat file. Due to the size of the file, the illustration below excludes all of
the
existing variables other than the record number, incident number, and incident date.
| IBR_REC |
INC_NUM |
INC_DATE |
V_AGE |
VAGE65 |
VAGE1017 |
VAGE1524 |
VLT18 |
VADULT |
VMALE |
VFEMALE |
OFF1017 |
OFF1524 |
OFFADULT |
OFFMALE |
OFFEMALE |
ARR1017 |
ARR1524 |
ARRADULT |
ARRMALE |
ARFEMALE |
INDIVL |
ARROFF |
OFFENSE |
VOFF1 |
VOFF2 |
MSVOFF |
MUR |
RAP |
ROB |
AGGASL |
BUR |
LAR |
MVT |
OTH_ASL |
V_INJ |
CLR_EXCP |
INC_LOC |
| 01 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 02 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
140 |
. |
. |
. |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
. |
20 |
| 03 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 03 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 03 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 04 |
Inc A |
19960110 |
35 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
1 |
. |
. |
140 |
. |
140 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 05 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 05 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 06 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
0 |
140 |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 06 |
Inc A |
19960110 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
0 |
140 |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 01 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 02 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
120 |
. |
. |
. |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
7 |
| 02 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
150 |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
. |
7 |
| 03 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 03 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 04 |
Inc B |
19961024 |
26 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
1 |
. |
. |
120 |
150 |
120 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
. |
. |
| 04 |
Inc B |
19961024 |
17 |
0 |
1 |
1 |
1 |
0 |
1 |
0 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
1 |
. |
. |
120 |
. |
120 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 05 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 05 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 05 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
. |
. |
. |
. |
. |
0 |
. |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 06 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
0 |
120 |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
| 06 |
Inc B |
19961024 |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
. |
0 |
0 |
1 |
1 |
0 |
0 |
120 |
. |
. |
. |
. |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
. |
. |
|