SPSS v. 21 STAR JOIN

20 pts.
Tags:
MERGE statement
star join statement
version 21
I have just started with version 21 and I have run into a major issue. Merge is no longer the MATCH CASES command. It is now STAR JOIN. There is something different that this command is doing. When merging, the command just stops when it runs into a keyed variable that has no match in the other data set. It should just show up as missing since there is no match in the other file but it stops the process and doesn't match anything else. Does anyone know what STAR JOIN is actually doing and why it does not complete the command? Thanks.

Software/Hardware used:
SPSS version 21

Answer Wiki

Thanks. We'll let you know when a new response is added.

Match Files is alive and well, but it requires pre-sorted data. If you
use the dialog interface to perform your merges, make sure you select
“Cases are sorted in order of key variables in both datasets”, and the
dialog will generate Match Cases syntax (make sure your data file are
sorted by the key variables).

Star Join will only include cases that are present in the first file.
Any cases in the second file that are not also present in the first file
(based on the key variable values) will not be included. This is like a
SQL outer join, and unlike Match Files, which will include all cases
from both files. But it shouldn’t just “stop” when it encounters the first unmatched case.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • IRspecialist
    Thanks, this is very helpful!Do you know what STAR JOIN is actually doing? I tried reading the IBM explanations but they are not helping much. What is the difference between match files and star join besides that fact that match files needs presorted data?
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following