seeking help with compute variable involving complex conditions

[thara vardhan-2]

Dear List members

We are trying to study the association between Intimidation/Stalking and
Assaults. I would be grateful if any member could help me with computing a
new variable category. For each category that I need to compute - I am
posting the sample records from my data file.

Compute category 1- where actual bodily harm/common assault/sexual assault
happened the same day as intimidation

PersonCNI    matchsequence      eventdate            IFC

ABC                       1                05 Feb2005          Assault
common
ABC                       2                                 05 Feb 2005  
Intimidation

Compute category 2 ? where actual bodily harm/common assault/sexual
assault happened before intimidation

PersonCNI       matchsequence               eventdate            IFC
 Mnop           1               06-MAR-2005    ACTUAL BODILY HARM  
Mnop            2               01-AUG-2005     ASSAULT COMMON
Mnop            3               29-NOV-2005     ASSAULT COMMON
Mnop                     4              29-NOV-2005     INTIMIDATION

this is where match seqence is important b'coz records 3 & 4 are on the
same date for person CNI mnop but I need to make it category 2 since this
person was a victim of assault and bodily harm before intimidation.

Compute category 3 - where actual bodily harm/common assault/sexual
assault happened after intimidation

PersonCNI   matchsequence              eventdate  IFC

XYZ             1               02-NOV-2003 INTIMIDATION  
2               04-NOV-2003                     Actual Bodily Harm
3              26-DEC-2003                      Assault Common
                                   4         06-APR-2006 ACTUAL BODILY
HARM
 
Compute category 4 ? where actual bodily harm/common assault/sexual
assault happened before and after intimidation
PersonCNI       matchsequence    eventdate IFC
JKL             1                22-JUL-2003    AGGRAVATED INDECENT
ASSAULT
 JKL            2              22-JUL-2003      AGGRAVATED SEXUAL ASSAULT  
 
JKL                     3            23-NOV-2003        ACTUAL BODILY HARM
 
JKL             4                27-NOV-2004            ASSAULT COMMON  
JKL             5                24-OCT-2005    INTIMIDATION
JKL             6             17-MAR-2006       ACTUAL BODILY HARM
JKL         7            17-MAR-2006    SEXUAL ASSAULT          
 
Compute category 6 ? where they had more than one intimidation incident on
diff dates

Person CNI     matchsequence       Eventdate                     IFC
GHI                                1           14-JUL-2005 INTIMIDATION    
 
GHI                        2           04-DEC-2005 INTIMIDATION  
 
I would be thankful if any member could help me with this problem.

looking forward to you reply.

regards
thara
 
                 
                                                 
 
 
 
 
 
 








 
 



 


Thara Vardhan
Senior Statistician
Planning & Results
Organisation Review and Support
NSW Police
Tel: [phone]


This message and any attachment is confidential and may
be privileged or otherwise protected from disclosure. If you
have received it by mistake, please let us know by reply
and then delete it from your system; you should not copy
the message or disclose its contents to anyone.