comparing spss datasets

[progster]

Hi I would like to compare two (or may be more) datasets, in order to have a report of differencies about, variable names, labels and value labels.

Probably I am misunderstanding something of the synthax, because I don't see the desired report


data list list / area target.
begin data
1 1
2 0
end data.

val lab area
1 'north'
2 'south'.

dataset name BBDD1.


data list list / area .
begin data
3
4
end data.

val lab area
3 'east'
4 'ovest'.

dataset name BBDD2.


SPSSINC COMPARE DATASETS   DS1=BBDD1 DS2=BBDD2  /DICTIONARY ATTRIBUTES FORMAT INDEX MEASLEVEL MISSINGVALUES TYPE VARLABEL VALUELABELS.

[Jon Peck]

The SPSSINC COMPARE DATASETS extension command can show you detailed case differences, but it only shows summaries for the variable dictionary differences.

However, since V21 there is a built-in command, COMPARE DATASETS, that will give you more details about differences in the metadata.

On Tue, Jul 12, 2016 at 6:51 AM, progster <[hidden email]> wrote:

Hi I would like to compare two (or may be more) datasets, in order to have a
report of differencies about, variable names, labels and value labels.

Probably I am misunderstanding something of the synthax, because I don't see
the desired report


data list list / area target.
begin data
1 1
2 0
end data.

val lab area
1 'north'
2 'south'.

dataset name BBDD1.


data list list / area .
begin data
3
4
end data.

val lab area
3 'east'
4 'ovest'.

dataset name BBDD2.


SPSSINC COMPARE DATASETS   DS1=BBDD1 DS2=BBDD2  /DICTIONARY ATTRIBUTES
FORMAT INDEX MEASLEVEL MISSINGVALUES TYPE VARLABEL VALUELABELS.




--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/comparing-spss-datasets-tp5732694.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

--

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

[progster]

Thanks but one thing is still unclear, if I go to DATA > COMPARE DATASETS the synthax generated is still as
SPSSINC COMPARE DATASETS.

It pastes this:


DATASET ACTIVATE BBDD1.
SPSSINC COMPARE DATASETS  DS1=BBDD1 DS2=BBDD2 VARIABLES=all/DATA LOGFILE="C:\Users\ME\Desktop\LOG"
/DICTIONARY  VARLABEL  VALUELABELS  .

I added manually the logfile option because in the GUI it allows to do it only if a CASE ID variable is indicated.

My real datasets normally have different IDs since they change every month.

[Jon Peck]

Look for the Compare Datasets item on the Data menu that does not have a white on blue "+" icon in order to use the built-in command.  Or in syntax just do COMPARE DATASETS.  The built-in menu item should be right after Identify Unusual Cases or Identify Duplicate Cases if you don't have the Data Validation option.  The logfile option is for case comparisons, where there might be a lot of output.  That's why, in the dialog, it is in the case comparison group.

As for comparing cases, you really cannot do that reliably if the IDs don't match.  How would you know which cases go together (unless the cases are actually the same every time even with different ids)?

On Tue, Jul 12, 2016 at 7:51 AM, progster <[hidden email]> wrote:

Thanks but one thing is still unclear, if I go to DATA > COMPARE DATASETS the
synthax generated is still as
SPSSINC COMPARE DATASETS.

It pastes this:


DATASET ACTIVATE BBDD1.
SPSSINC COMPARE DATASETS  DS1=BBDD1 DS2=BBDD2 VARIABLES=all/DATA
LOGFILE="C:\Users\ME\Desktop\LOG"
/DICTIONARY  VARLABEL  VALUELABELS  .

I added manually the logfile option because in the GUI it allows to do it
only if a CASE ID variable is indicated.

My real datasets normally have different IDs since they change every month.



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/comparing-spss-datasets-tp5732694p5732696.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

--

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