Dear list members

I have a data file which with variables personcni and Involvement Type and the file is structured as follows:

Sample dummy data:

PersonCNI InvolvementType 123 VICTIM 330 VICTIM 330 PERSON OF INTEREST 330 PERSON OF INTEREST 451 PERSON OF INTEREST 555 PERSON OF INTEREST 555 PERSON OF INTEREST 666 PERSON OF INTEREST 777 PERSON OF INTEREST 777 PERSON OF INTEREST 888 PERSON OF INTEREST 888 VICTIM 888 VICTIM 888 VICTIM 888 VICTIM 888 VICTIM 9999 VICTIM 9999 VICTIM 9999 PERSON OF INTEREST 9999 VICTIM

How do I select records where the person is a

a) victim only b) POI only c) Both a victim and poi

In the first instance i am keeping it very simple with just these two variables without taking into account any date variables. All involvements were over 1 year period.

I would be grateful if somebody could help select these records.

many thanks regards thara _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s) only. It may contain private, confidential, copyright or legally privileged information. If you are not the intended recipient or you have received this email by mistake, please reply to the author and delete this email immediately. You must not copy, print, forward or distribute this email, nor place reliance on its contents. This email and any attachment have been virus scanned. However, you are requested to conduct a virus scan as well. No liability is accepted for any loss or damage resulting from a computer virus, or resulting from a delay or defect in transmission of this email or any attached file. This email does not constitute a representation by the NSW Police Force unless the author is legally entitled to do so.