Error Message

[Pettitt-Morris Caroline]

Hello all,

I have been trying to clean and update an old syntax we use, but have
been unable to get rid of the following error messages:

>MATCH FILES /FILE=*
> /TABLE='C:\Crime Desk\Force Gazetteer.sav'
> /RENAME  LOCATION=LOCATION2.

>Error # 5123
>The TABLE subcommand is specified without a BY subcommand.  A BY
subcommand is
>required with TABLE subcommands.
>This command not executed.

>Note # 5145
>The working file has been restored, and subsequent commands may access
the
>working file.
 /BY LOCATION2 .

>Error # 1.  Command name: /BY
>The first word in the line is not recognized as an SPSS command.
>This command not executed.
EXECUTE.

This section compares addresses attached to cases to a 'Gazetteer' which
contains co-ordinates for mapping these addresses. If the full address
is not found, it then compares street,and then town, so all cases should
have a match at some level.

I am new to SPSS and the LIST so if I need to provide more data etc. or
if this is not what the list is for then please let me know!

Many thanks

Caroline

Caroline PETTITT-MORRIS
Intelligence Analyst
E-mail: [hidden email]


PS the syntax run is as follows:

STRING LOCATION (A255).
COMPUTE LOCATION = LTRIM(CONCAT(RTRIM(off_locn_house_no),"
",RTRIM(off_locn_house_name)," ",RTRIM(off_locn_street_no),"
",RTRIM(off_locn_street_name)," "
 ,RTRIM(off_locn_town))) .
STRING LOCATION1 (A255).
COMPUTE LOCATION1 = LTRIM(CONCAT(RTRIM(off_locn_street_name),"
",RTRIM(off_locn_town))) .
STRING LOCATION2 (A255).
COMPUTE LOCATION2 = off_locn_town .
EXECUTE.

SORT CASES BY
  LOCATION2 (A) .
EXECUTE.

MATCH FILES /FILE=*
 /TABLE='C:\Crime Desk\Force Gazetteer.sav'
 /RENAME  LOCATION=LOCATION2.
 /BY LOCATION2 .
EXECUTE.

SORT CASES BY
  LOCATION1 (A) .

MATCH FILES /FILE=*
 /TABLE='C:\Crime Desk\Force Gazetteer.sav'
 /RENAME  analyst_ea=analyst_ea1 analyst_no=analyst_no1
LOCATION=LOCATION1 ILNA_New=ILNA_New1
 /BY LOCATION1.
EXECUTE.

SORT CASES BY
  LOCATION (A) .

MATCH FILES /FILE=*
 /TABLE='C:\Crime Desk\Force Gazetteer.sav'
 /RENAME  analyst_ea=analyst_ea2 analyst_no=analyst_no2
ILNA_New=ILNA_New2
 /BY LOCATION.
EXECUTE.

COMPUTE new_easting = analyst_ea2 .
COMPUTE new_northing = analyst_no2 .
EXECUTE .

IF (SYSMIS(analyst_ea2)) new_easting = analyst_ea1 .
IF (SYSMIS(analyst_no2)) new_northing = analyst_no1 .
IF (SYSMIS(new_easting)) new_easting = analyst_ea .
IF (SYSMIS(new_northing)) new_northing = analyst_no .
EXECUTE .


**********************************************************************
'Bedfordshire police are now recruiting - visit www.bedfordshire.police.uk for more information

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept for the presence of computer viruses.
********************************************************************************
Internet email is not to be treated as a secure means of communication.
Bedfordshire Police monitors all Internet email activity and content.
********************************************************************************


=====================
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

[Marta Garcia-Granero]

Pettitt-Morris Caroline wrote:

>
> I have been trying to clean and update an old syntax we use, but have
> been unable to get rid of the following error messages:
>
>
>> MATCH FILES /FILE=*
>> /TABLE='C:\Crime Desk\Force Gazetteer.sav'
>> /RENAME  LOCATION=LOCATION2.
>>
> You need to remove the period at the end of LOCATION2. The command should be:
>

MATCH FILES /FILE=*
 /TABLE='C:\Crime Desk\Force Gazetteer.sav'
 /RENAME  LOCATION=LOCATION2
 /BY LOCATION2 .


HTH,
Marta García-Granero


--
For miscellaneous statistical stuff, visit:
http://gjyp.nl/marta/

=====================
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