seeking help with matching two files- reply to clive

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

seeking help with matching two files- reply to clive

thara vardhan-2
Hi Clive

Thanks for your reply. I was trying to create a single file with both
organisation and person victims. I need the records in a single file
because I need to identify records that have both an organisation and
person victims (there are many of those in my file). The incident ref
number is the key variable.

What I realised after sending my question to the list is that i need to
add the cases rather than match the two files. Richard Ristow was kind
enough to point this out in his reply to my question.

thanks
regards
Thara Vardhan
Senior Statistician
Planning & Results
Organisation Review and Support
NSW Police
Tel: (02) 8835-8526
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

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.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: seeking help with matching two files- reply to clive

Richard Ristow
At 07:38 PM 5/12/2008, Thara Vardhan wrote:

>I need to identify records that have both an organisation and person
>victims (there are many of those in my file). The incident ref
>number is the key variable.

Are you OK with that, after the two files have been merged? You'd do it with

AGGREGATE/OUTFILE=* MODE=ADDVARIABLES

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD