Star join : SPSS 21 vs SPSS 20

[Rajeshms]

Dear all,

I have to merge two data sets. dataset 1 has thousands of cases and dataset 2 has 30 cases. I now want to merge the 30 cases data set to dataset1 of respective primary keyed variable. I acheived this using SPSS21 but, I coulnt do the same with SPSS 20. Star join is not there in SPSS 20. So, In this case how to merge this using SPSS 20. 

Thank u all in advance....

--

Regards,

Rajesh M S

[David Marso]

MATCH FILES has not evolved much in say 25 years!
See TABLE subcommand!

Rajeshms wrote

Dear all,


I have to merge two data sets. dataset 1 has thousands of cases and dataset
2 has 30 cases. I now want to merge the 30 cases data set to dataset1 of
respective primary keyed variable. I acheived this using SPSS21 but, I
coulnt do the same with SPSS 20. Star join is not there in SPSS 20. So, In
this case how to merge this using SPSS 20.

Thank u all in advance....

--
Regards,

Rajesh M S

[Li Cao]

Thanks for your email. I am off today, Jan 15th, Tuesday.

 

For ARF, please contact ARF Sample [hidden email]

For SBA, Please contact Springboard US Sample [hidden email]

For SBUK, please contact Springboard UK Sample [hidden email]

 

Thanks!

Li Cao

Sample Analyst | National Panels | Vision Critical 

direct   778.373.0459 

 

[Rick Oliver-3]

MATCH FILES FILE=file1 /TABLE=file2 /BY keyvars

Note that both files must be sorted by key values.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        Rajeshms <[hidden email]>
To:        [hidden email],
Date:        01/15/2013 10:49 AM
Subject:        Star join : SPSS 21 vs SPSS 20
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,


I have to merge two data sets. dataset 1 has thousands of cases and dataset 2 has 30 cases. I now want to merge the 30 cases data set to dataset1 of respective primary keyed variable. I acheived this using SPSS21 but, I coulnt do the same with SPSS 20. Star join is not there in SPSS 20. So, In this case how to merge this using SPSS 20. 

Thank u all in advance....

--
Regards,

Rajesh M S

[Rajeshms]

Dear all,

I really surprised with star join. sometimes it works and sometimes it wont. can anyone know how to work using star join,while merging two datasets of different total number of cases.

thank u,

On Tue, Jan 15, 2013 at 10:37 PM, Rick Oliver <[hidden email]> wrote:

MATCH FILES FILE=file1 /TABLE=file2 /BY keyvars

Note that both files must be sorted by key values.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        Rajeshms <[hidden email]>
To:        [hidden email],
Date:        01/15/2013 10:49 AM
Subject:        Star join : SPSS 21 vs SPSS 20
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,


I have to merge two data sets. dataset 1 has thousands of cases and dataset 2 has 30 cases. I now want to merge the 30 cases data set to dataset1 of respective primary keyed variable. I acheived this using SPSS21 but, I coulnt do the same with SPSS 20. Star join is not there in SPSS 20. So, In this case how to merge this using SPSS 20. 

Thank u all in advance....

--
Regards,

Rajesh M S

--

Regards,

Rajesh M S

[David Marso]

DEFINE: "sometimes it works and sometimes it wont"...
Rick Oliver gave you the basic syntax.
Are the two files SORTED?
Are the keys in the 'TABLE" UNIQUE?
Are there ERROR MESSAGES?
---
The terms 'works' and "won't" are not useful.
You need to provide context and info!
There is also the mostly neglected FM to edify yourself!

Rajeshms wrote

Dear all,

I really surprised with star join. sometimes it works and sometimes it
wont. can anyone know how to work using star join,while merging two
datasets of different total number of cases.

thank u,


On Tue, Jan 15, 2013 at 10:37 PM, Rick Oliver <[hidden email]> wrote:

> MATCH FILES FILE=file1 /TABLE=file2 /BY keyvars
>
> Note that both files must be sorted by key values.
>
> Rick Oliver
> Senior Information Developer
> IBM Business Analytics (SPSS)
> E-mail: [hidden email]
>
>
>
> From:        Rajeshms <[hidden email]>
> To:        [hidden email],
> Date:        01/15/2013 10:49 AM
> Subject:        Star join : SPSS 21 vs SPSS 20
> Sent by:        "SPSSX(r) Discussion" <[hidden email]>
> ------------------------------
>
>
>
> Dear all,
>
>
> I have to merge two data sets. dataset 1 has thousands of cases and
> dataset 2 has 30 cases. I now want to merge the 30 cases data set to
> dataset1 of respective primary keyed variable. I acheived this using SPSS21
> but, I coulnt do the same with SPSS 20. Star join is not there in SPSS 20.
> So, In this case how to merge this using SPSS 20.
>
> Thank u all in advance....
>
> --
> Regards,
>
> Rajesh M S
>
>
>


--
Regards,

Rajesh M S