Merge Files->Add Variables by Key Issue

Greetings,

 

I cannot seem to get SPSS 22.0.0.2 to perform a “one-to-many” merge files task on a key variable. I’ve never had a problem with this before. I’ve tried several ways (see below), but it will not match each individual case.  Is there a new process with V 22?

 

MATCH FILES /FILE=*

  /FILE='DataSet2'

  /BY BIRN.

EXECUTE.

 

MATCH FILES /FILE=*

  /TABLE='DataSet2'

  /BY BIRN.

LIST.

 

STAR JOIN

  /SELECT t0.SchoolYear, t0.EnrollmentEconDisadvantaged, t0.PctTotalEnrollmentEconDisadvantged,

    t1.County, t1.BZIP, t1.ORG_TYPE, t1.CLASS_TYPE

  /FROM * AS t0

  /JOIN 'DataSet2' AS t1

    ON t0.BIRN=t1.BIRN

  /OUTFILE FILE=*.

 

Thanks in advance. Hope it’s a simple fix.

 

Regards,

 

Chip Partridge

 

Columbus, Ohio

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

[David Marso]

Well you really don't provide sufficient information to apply to your specific situation.
Perhaps you would care to elaborate and provide an example of the issue?
Meanwhile this works just fine:

DATA LIST FREE / x y.
BEGIN DATA
1 11  2 22  3 33  4 44
END DATA.
DATASET NAME keytable.

DATA LIST FREE / x z .
BEGIN DATA
1 11  1 12  1 13  2 21  2  22  2 23  3 31  3 32  4 41  4 42
END DATA.
DATASET NAME multi.

MATCH FILES / FILE multi /TABLE keytable BY x.
LIST.
 
       x        z        y
 
    1.00    11.00    11.00
    1.00    12.00    11.00
    1.00    13.00    11.00
    2.00    21.00    22.00
    2.00    22.00    22.00
    2.00    23.00    22.00
    3.00    31.00    33.00
    3.00    32.00    33.00
    4.00    41.00    44.00
    4.00    42.00    44.00
 
 
Number of cases read:  10    Number of cases listed:  10

Partridge, Charles R wrote

Greetings,

I cannot seem to get SPSS 22.0.0.2 to perform a "one-to-many" merge files task on a key variable. I've never had a problem with this before. I've tried several ways (see below), but it will not match each individual case.  Is there a new process with V 22?

MATCH FILES /FILE=*
  /FILE='DataSet2'
  /BY BIRN.
EXECUTE.

MATCH FILES /FILE=*
  /TABLE='DataSet2'
  /BY BIRN.
LIST.

STAR JOIN
  /SELECT t0.SchoolYear, t0.EnrollmentEconDisadvantaged, t0.PctTotalEnrollmentEconDisadvantged,
    t1.County, t1.BZIP, t1.ORG_TYPE, t1.CLASS_TYPE
  /FROM * AS t0
  /JOIN 'DataSet2' AS t1
    ON t0.BIRN=t1.BIRN
  /OUTFILE FILE=*.

Thanks in advance. Hope it's a simple fix.

Regards,

Chip Partridge

Columbus, Ohio

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