FILE COMPARISON SIMILAR AND / OR DIFFERENT

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

FILE COMPARISON SIMILAR AND / OR DIFFERENT

Javier Figueroa
Compare files

Hello experts SPSS

I hope that all their activities are performing with success, this time has touched me to compare different files in SPSS (.sav) the comparison is basically in structure, labels and values ​​that have done manually, would like to know if there is any method or command to do this comparison and thus make it automatically.

This is an example of two bases.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS GENERO
1 'Male'
2 'Female'.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS SEXO
1 'Female'
2 'Male'.

In the example we see that the last variable is called GENERO and has 2 codes that are in a different order, and to see this as I can do in SPSS.


Any suggestion will be welcome.

in advance thank you for your time and help this requirement

Sincerely,

--
Javier Figueroa
Procesamiento y Análisis de bases de datos
Cel: 5927-4748 / 4970-1940
Casa: 2289-0184

===================== 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
Reply | Threaded
Open this post in threaded view
|

Re: FILE COMPARISON SIMILAR AND / OR DIFFERENT

Jon Peck
Data > Compare Datasets (COMPARE DATASETS)

On Thu, May 19, 2016 at 11:06 AM, Javier Figueroa <[hidden email]> wrote:
Compare files

Hello experts SPSS

I hope that all their activities are performing with success, this time has touched me to compare different files in SPSS (.sav) the comparison is basically in structure, labels and values ​​that have done manually, would like to know if there is any method or command to do this comparison and thus make it automatically.

This is an example of two bases.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS GENERO
1 'Male'
2 'Female'.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS SEXO
1 'Female'
2 'Male'.

In the example we see that the last variable is called GENERO and has 2 codes that are in a different order, and to see this as I can do in SPSS.


Any suggestion will be welcome.

in advance thank you for your time and help this requirement

Sincerely,

--
Javier Figueroa
Procesamiento y Análisis de bases de datos
Cel: 5927-4748 / 4970-1940
Casa: 2289-0184

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



--
Jon K Peck
[hidden email]

===================== 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
Reply | Threaded
Open this post in threaded view
|

Re: FILE COMPARISON SIMILAR AND / OR DIFFERENT

Javier Figueroa
Jon thank you very much for responding so quickly. it is very helpful.

Sincerely,

2016-05-19 11:12 GMT-06:00 Jon Peck <[hidden email]>:
Data > Compare Datasets (COMPARE DATASETS)

On Thu, May 19, 2016 at 11:06 AM, Javier Figueroa <[hidden email]> wrote:
Compare files

Hello experts SPSS

I hope that all their activities are performing with success, this time has touched me to compare different files in SPSS (.sav) the comparison is basically in structure, labels and values ​​that have done manually, would like to know if there is any method or command to do this comparison and thus make it automatically.

This is an example of two bases.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS GENERO
1 'Male'
2 'Female'.

DATA LIST /XVAR 1 YVAR ZVAR 3-12 CVAR 14-22(A) JVAR 24 GENERO 26.
BEGIN DATA
1  3424  274 ABU DHABI 2 1
2 39932   86 AMSTERDAM 4 2
3  8889  232 ATHENS  2
4  3424  294 BOGOTA    3 1
5 11323  332 LONDON    3 1
6   323  232 MANILA    1 1
7  3234  899 CHICAGO   4 1
8 78998 2344 VIENNA    3 2
9  8870  983 ZURICH    5 2
END DATA.
VALUE LABELS SEXO
1 'Female'
2 'Male'.

In the example we see that the last variable is called GENERO and has 2 codes that are in a different order, and to see this as I can do in SPSS.


Any suggestion will be welcome.

in advance thank you for your time and help this requirement

Sincerely,

--
Javier Figueroa
Procesamiento y Análisis de bases de datos
Cel: 5927-4748 / 4970-1940
Casa: 2289-0184

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



--
Jon K Peck
[hidden email]




--
Javier Figueroa
Procesamiento y Análisis de bases de datos
Cel: 5927-4748 / 4970-1940
Casa: 2289-0184

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