merge files differences between SPSS20 and SPSS21?

[GFJ van Meurs]

CONTENTS DELETED

The author has deleted this message.

[Art Kendall]

what syntax is created in each version?


exit a menu via <paste>
On 4/19/2013 1:18 PM, Meurs, van, Gerard (Intomart GfK) [via SPSSX Discussion] wrote:

Dear SPSS-users,

 

While exploring differences between SPSS20 and SPSS21 I run into a difference in merging files. If I use the same menu-instructions to merge two files, the result in SPSS20 is different from the result in SPSS21.

 

More specific:

 

Big.sav contains:

recnr v1 v2

1        1  2

2        1  1

3        2  4

4        3  2

5        1  4

 

Small.sav contains:

Recnr  v3

5         4

6         1

7         3

 

After first loading Big.sav I choose: Data > Merge Files > Add Variables

An external SPSS statistics data file (small.sav)

Mark: Match cases on key variables in sorted files

Mark: both files provide cases

Move recnr to the Key Variables part

 

In SPSS20 this give me the following data:

recnr v1 v2 v3

1        1  2  .

2        1  1  .

3        2  4  .

4        3  2  .

5        1  4  4

6        .  .   1

7        .  .   3

 

Just as I expected. But in SPSS21 this gives:

recnr v1 v2 v3

1        1  2  .

2        1  1  .

3        2  4  .

4        3  2  .

5        1  4  .

 

A bug?

 

By pasting the syntax I noticed that the old MATCH FILES syntax is replaced by new sql-like syntax STAR-JOIN.

 

I know that I can still use the MATCH FILES syntax in SPSS21, but a lot of our users rather use the GUI to match files.

 

Any suggestions?

 

 

Kind regards, Gerard van Meurs

 

 

 

--

Gerard van Meurs

Methodoloog | Media & Marketing Research

Intomart GfK | Postbus 10004 | 1201 DA Hilversum | The Netherlands

[phone] | [phone] (The Netherlands)

www.intomartgfk.nl

 

---

This e-mail (and any attachment) contains confidential and / or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the contents of this e-mail is strictly forbidden.

Dit bericht kan vertrouwelijke informatie bevatten. Indien u niet de geadresseerde van dit bericht bent, verzoeken wij u dit bericht te vernietigen zonder van de inhoud kennis te nemen en de inhoud er van niet te gebruiken, niet te kopieren en niet onder derden te verspreiden.

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/merge-files-differences-between-SPSS20-and-SPSS21-tp5719566.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML

[David Marso]

Gerard,
I never use dialogs for merging and rarely for anything else.
*BUT*  I recall that there were a number of 'features' in STAR-JOIN that were un-discombulated with the fix pack from about a month or so ago.  Seek out the patch within the IBM Labyrinth.  Other than that?
Anyone have any words as to why I would use STAR-JOIN rather than ADD FILES?
I know nothing of the function but if there are advantages (performance wise or other) I would love to get the 411.
HTH, David
 --

Meurs, van, Gerard (Intomart GfK) wrote

Dear SPSS-users,

While exploring differences between SPSS20 and SPSS21 I run into a difference in merging files. If I use the same menu-instructions to merge two files, the result in SPSS20 is different from the result in SPSS21.

More specific:

Big.sav contains:
recnr v1 v2
1        1  2
2        1  1
3        2  4
4        3  2
5        1  4

Small.sav contains:
Recnr  v3
5         4
6         1
7         3

After first loading Big.sav I choose: Data > Merge Files > Add Variables
An external SPSS statistics data file (small.sav)
Mark: Match cases on key variables in sorted files
Mark: both files provide cases
Move recnr to the Key Variables part

In SPSS20 this give me the following data:
recnr v1 v2 v3
1        1  2  .
2        1  1  .
3        2  4  .
4        3  2  .
5        1  4  4
6        .  .   1
7        .  .   3

Just as I expected. But in SPSS21 this gives:
recnr v1 v2 v3
1        1  2  .
2        1  1  .
3        2  4  .
4        3  2  .
5        1  4  .

A bug?

By pasting the syntax I noticed that the old MATCH FILES syntax is replaced by new sql-like syntax STAR-JOIN.

I know that I can still use the MATCH FILES syntax in SPSS21, but a lot of our users rather use the GUI to match files.

Any suggestions?


Kind regards, Gerard van Meurs



--
Gerard van Meurs
Methodoloog | Media & Marketing Research
Intomart GfK | Postbus 10004 | 1201 DA Hilversum | The Netherlands
[phone] | [phone] (The Netherlands)
www.intomartgfk.nl<http://www.intomartgfk.nl/>


________________________________

This e-mail (and any attachment) contains confidential and / or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the contents of this e-mail is strictly forbidden.

Dit bericht kan vertrouwelijke informatie bevatten. Indien u niet de geadresseerde van dit bericht bent, verzoeken wij u dit bericht te vernietigen zonder van de inhoud kennis te nemen en de inhoud er van niet te gebruiken, niet te kopieren en niet onder derden te verspreiden.

[GFJ van Meurs]

CONTENTS DELETED

The author has deleted this message.

[GFJ van Meurs]

CONTENTS DELETED

The author has deleted this message.