Anders A
04-17-2008, 04:04 AM
Hi!:wave:
I have a problem in SPSS that seems to be unsolvable. I am working with crime data. I have a file with about 6000 reccords. It contains variables about crimes comitted and dates when crimes were comitted. The file also have variables about court decisions about penalties (i.e. verdicts) and time for onset of a penalty (for example: imprisonement). Now, for a ten year period there are up to 82 verdicts. Each verdict can contain up to 30 single crimes and dates of these crimes, like this (C = crime, TC = time of crime, P = date of penalty)
----- Verdict 1 ------- ------Verdict 2 ------- ---- Verdict N
c1 TC1 .. C30 TC30 P1| C1 TC1.. C30 TC30 P2| C1 TC1 .....PN.
Now I want to find out how many crimes that was comitted tvo year ahead and two year after a special penalty. So I want to sum all crimes comitted a special year across all verdicts.
How can this be done ?
Any answer would be appreciated.
/A.
I have a problem in SPSS that seems to be unsolvable. I am working with crime data. I have a file with about 6000 reccords. It contains variables about crimes comitted and dates when crimes were comitted. The file also have variables about court decisions about penalties (i.e. verdicts) and time for onset of a penalty (for example: imprisonement). Now, for a ten year period there are up to 82 verdicts. Each verdict can contain up to 30 single crimes and dates of these crimes, like this (C = crime, TC = time of crime, P = date of penalty)
----- Verdict 1 ------- ------Verdict 2 ------- ---- Verdict N
c1 TC1 .. C30 TC30 P1| C1 TC1.. C30 TC30 P2| C1 TC1 .....PN.
Now I want to find out how many crimes that was comitted tvo year ahead and two year after a special penalty. So I want to sum all crimes comitted a special year across all verdicts.
How can this be done ?
Any answer would be appreciated.
/A.