SPSS16, merge files, and "hidden" variables

[Mark Palmberg]

Using SPSS16, I'm trying to add a variable using two files created in v15.
When I used to merge them in the old version, I'd notice in the output file
that there'd be a number of dropped variables that didn't show up in either
SPSS file (like d0 d1 d2, etc.), but the merge went through anyway, and the
variable(s) I needed were added.  Now, though, it appears the merge is
hanging with errors on all these variables, like so:

*>Error # 5241 in column 10.  Text: d0
*>Undefined variable name.  Check spelling, verify the existence of this
*>variable.  Has it been dropped or renamed in this command?

I did a Save As... on each file in the new version of SPSS, thinking maybe
that would help, but it doesn't.  This is a fully-patched copy of SPSS 16
Base, BTW.  Clearly I've missed something in the transition to the new
version.

Thanks for any thoughts you might have.

Mark

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

[Marks, Jim]

Mark:

The default behavior for SPSS is use d0 d1 etc when you use the GUI to
merge and specify variables to drop. Something like:

MATCH FILES file = a /rename (nogood nogood2 = d0 d1)
      /file = b
  /drop do d1
.

I guess that the rename has been omitted. You might set up the merge
through the GUI and use "paste" to see the code.

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Mark Palmberg
Sent: Wednesday, April 16, 2008 11:45 AM
To: [hidden email]
Subject: SPSS16, merge files, and "hidden" variables

Using SPSS16, I'm trying to add a variable using two files created in
v15.
When I used to merge them in the old version, I'd notice in the output
file that there'd be a number of dropped variables that didn't show up
in either SPSS file (like d0 d1 d2, etc.), but the merge went through
anyway, and the
variable(s) I needed were added.  Now, though, it appears the merge is
hanging with errors on all these variables, like so:

*>Error # 5241 in column 10.  Text: d0
*>Undefined variable name.  Check spelling, verify the existence of this
*>variable.  Has it been dropped or renamed in this command?

I did a Save As... on each file in the new version of SPSS, thinking
maybe that would help, but it doesn't.  This is a fully-patched copy of
SPSS 16 Base, BTW.  Clearly I've missed something in the transition to
the new version.

Thanks for any thoughts you might have.

Mark

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

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

[Mark Palmberg]

Nope.  /RENAME is in there:

GET
 FILE='C:\Documents and Settings\palmberg\My Documents\Datamine\FILE1.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.
GET
 FILE='C:\Documents and Settings\palmberg\My Documents\Datamine\FILE2.sav'.
DATASET NAME DataSet2 WINDOW=FRONT.
DATASET ACTIVATE DataSet1.
MATCH FILES /FILE=*
 /TABLE='DataSet2'
 /RENAME (LOTS OF VARS...)
 /BY  ID
 /DROP= d0 d1 d2....

On Wed, Apr 16, 2008 at 12:15 PM, Marks, Jim <[hidden email]> wrote:

> Mark:
>
> The default behavior for SPSS is use d0 d1 etc when you use the GUI to
> merge and specify variables to drop. Something like:
>
> MATCH FILES file = a /rename (nogood nogood2 = d0 d1)
>      /file = b
>  /drop do d1
> .
>
> I guess that the rename has been omitted. You might set up the merge
> through the GUI and use "paste" to see the code.
>
> --jim
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Mark Palmberg
> Sent: Wednesday, April 16, 2008 11:45 AM
> To: [hidden email]
> Subject: SPSS16, merge files, and "hidden" variables
>
> Using SPSS16, I'm trying to add a variable using two files created in
> v15.
> When I used to merge them in the old version, I'd notice in the output
> file that there'd be a number of dropped variables that didn't show up
> in either SPSS file (like d0 d1 d2, etc.), but the merge went through
> anyway, and the
> variable(s) I needed were added.  Now, though, it appears the merge is
> hanging with errors on all these variables, like so:
>
> *>Error # 5241 in column 10.  Text: d0
> *>Undefined variable name.  Check spelling, verify the existence of this
> *>variable.  Has it been dropped or renamed in this command?
>
> I did a Save As... on each file in the new version of SPSS, thinking
> maybe that would help, but it doesn't.  This is a fully-patched copy of
> SPSS 16 Base, BTW.  Clearly I've missed something in the transition to
> the new version.
>
> Thanks for any thoughts you might have.
>
> Mark
>
> =====================
> 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
>
> =====================
> 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
>

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

[Marks, Jim]

Mark:
 
Are the variables named on the /RENAME also present?
 

--jim


________________________________

From: Mark Palmberg [mailto:[hidden email]]
Sent: Wednesday, April 16, 2008 12:22 PM
To: Marks, Jim
Cc: [hidden email]
Subject: Re: SPSS16, merge files, and "hidden" variables


Nope.  /RENAME is in there:

GET
 FILE='C:\Documents and Settings\palmberg\My
Documents\Datamine\FILE1.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.
GET
 FILE='C:\Documents and Settings\palmberg\My
Documents\Datamine\FILE2.sav'.
DATASET NAME DataSet2 WINDOW=FRONT.
DATASET ACTIVATE DataSet1.
MATCH FILES /FILE=*
 /TABLE='DataSet2'
 /RENAME (LOTS OF VARS...)
 /BY  ID
 /DROP= d0 d1 d2....


On Wed, Apr 16, 2008 at 12:15 PM, Marks, Jim <[hidden email]>
wrote:


        Mark:
       
        The default behavior for SPSS is use d0 d1 etc when you use the
GUI to
        merge and specify variables to drop. Something like:
       
        MATCH FILES file = a /rename (nogood nogood2 = d0 d1)
             /file = b
         /drop do d1
        .
       
        I guess that the rename has been omitted. You might set up the
merge
        through the GUI and use "paste" to see the code.
       
        --jim
       

        -----Original Message-----
        From: SPSSX(r) Discussion [mailto:[hidden email]] On
Behalf Of
        Mark Palmberg
        Sent: Wednesday, April 16, 2008 11:45 AM
        To: [hidden email]
        Subject: SPSS16, merge files, and "hidden" variables
       
        Using SPSS16, I'm trying to add a variable using two files
created in
        v15.
        When I used to merge them in the old version, I'd notice in the
output
        file that there'd be a number of dropped variables that didn't
show up
        in either SPSS file (like d0 d1 d2, etc.), but the merge went
through
        anyway, and the
        variable(s) I needed were added.  Now, though, it appears the
merge is
        hanging with errors on all these variables, like so:
       
        *>Error # 5241 in column 10.  Text: d0
        *>Undefined variable name.  Check spelling, verify the existence
of this
        *>variable.  Has it been dropped or renamed in this command?
       
        I did a Save As... on each file in the new version of SPSS,
thinking
        maybe that would help, but it doesn't.  This is a fully-patched
copy of
        SPSS 16 Base, BTW.  Clearly I've missed something in the
transition to
        the new version.
       
        Thanks for any thoughts you might have.
       
        Mark
       
       
        =====================
        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
       
        =====================
        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
       

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