problem with UPDATE syntax?

[Tanya Temkin]

Dear SPSS experts, learners, and experts-to-be:

A question from a relative syntax newbie:
I am trying to execute the UPDATE command (my first time) - I've followed
the SPSS syntax reference and data management manuals and this still isn't
working. The syntax is so simple; I have no idea what is wrong.

I'm using v. 14

I have two files: CAD cohort v3.sav, which I want to be my master file.
and CAD dx post-call.sav, which is my transaction file. Both are open and
the first is activated. I want MRN to be my key variable, which is sorted
in ascending order in both files.

* update the cohort file with the data on 1st CAD dx following 1st call.
UPDATE FILE=*
  /FILE=CAD dx post-call
  /IN=flag
  /BY=MRN.
exe.

And I keep getting this message:
>Error # 5101 in column 13.  Text: dx
>Invalid subcommand for this command.  Check for missing slashes.  Syntax
>checking begins with the next slash.
>This command not executed.

Well as far as I can tell all the needed slashes are there. What's my
problem?

Thanks for the input.


NOTICE TO RECIPIENT:  If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents.  If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them.  Thank you.

[Melissa Ives]

Looks to me like it is not liking your transaction file name.  Is that a
'DATASET NAME' or the actual file name?
DATASET names cannot contain spaces, so you should rename it
CAD_dx_post-call or CADdxpost-call.
Actual file names generally require quotes and the drive, path and
extension such as:
        /FILE='C:\myfolder\CAD dx post-call.sav'

Melissa
The bubbling brook would lose its song if you removed the rocks.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Tanya Temkin
Sent: Friday, January 26, 2007 3:50 PM
To: [hidden email]
Subject: [SPSSX-L] problem with UPDATE syntax?

Dear SPSS experts, learners, and experts-to-be:

A question from a relative syntax newbie:
I am trying to execute the UPDATE command (my first time) - I've
followed the SPSS syntax reference and data management manuals and this
still isn't working. The syntax is so simple; I have no idea what is
wrong.

I'm using v. 14

I have two files: CAD cohort v3.sav, which I want to be my master file.
and CAD dx post-call.sav, which is my transaction file. Both are open
and the first is activated. I want MRN to be my key variable, which is
sorted in ascending order in both files.

* update the cohort file with the data on 1st CAD dx following 1st call.
UPDATE FILE=*
  /FILE=CAD dx post-call
  /IN=flag
  /BY=MRN.
exe.

And I keep getting this message:
>Error # 5101 in column 13.  Text: dx
>Invalid subcommand for this command.  Check for missing slashes.
>Syntax checking begins with the next slash.
>This command not executed.

Well as far as I can tell all the needed slashes are there. What's my
problem?

Thanks for the input.


NOTICE TO RECIPIENT:  If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents.  If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them.  Thank you.



PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

[Oliver, Richard]

Either enclose the second file specification in quotes (and probably include a path), as in:

/FILE="c:\somedir\CAD dx post-call.sav"

Or refer to it by its dataset name in the current session, as in:

/FILE=dataset2

You said both files are open. If you opened them via the dialog UI, then they have default dataset names such Dataset1, Dataset2, etc.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Tanya Temkin
Sent: Friday, January 26, 2007 3:50 PM
To: [hidden email]
Subject: problem with UPDATE syntax?

Dear SPSS experts, learners, and experts-to-be:

A question from a relative syntax newbie:
I am trying to execute the UPDATE command (my first time) - I've followed
the SPSS syntax reference and data management manuals and this still isn't
working. The syntax is so simple; I have no idea what is wrong.

I'm using v. 14

I have two files: CAD cohort v3.sav, which I want to be my master file.
and CAD dx post-call.sav, which is my transaction file. Both are open and
the first is activated. I want MRN to be my key variable, which is sorted
in ascending order in both files.

* update the cohort file with the data on 1st CAD dx following 1st call.
UPDATE FILE=*
  /FILE=CAD dx post-call
  /IN=flag
  /BY=MRN.
exe.

And I keep getting this message:
>Error # 5101 in column 13.  Text: dx
>Invalid subcommand for this command.  Check for missing slashes.  Syntax
>checking begins with the next slash.
>This command not executed.

Well as far as I can tell all the needed slashes are there. What's my
problem?

Thanks for the input.


NOTICE TO RECIPIENT:  If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents.  If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them.  Thank you.