|
|
Hi David
Thank you so much for your prompt reply.
You were spot on in identifying the problem. Indeed in my masterlist file
'final premise' had duplicates records and also should be the table dataset.
Once I corrected it - it works like
whiz.
You have saved me heaps of time - otherwise
I would have done it the long way - that is write recode syntax for every
incident data file ( and I have so many !).
For the benefit of all members I am
posting the correct syntax
DATASET ACTIVATE DataSet4.
------- (masterlist premise file)
MATCH FILES /TABLE=*
/FILE='DataSet7'
---------------- (my work file)
/BY finalpremise.
EXECUTE.
thanks
regards
Thara Vardhan
Senior Statistician
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
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.
|
|
Locked
