Re: Compare two data files

[John Darrington]

One way to do this is as follows:

MATCH FILES
        /FILE='f1.sav' /IN=file1 /SORT
        /FILE='f2.sav' /IN=file2 /SORT
        /BY ALL
        .

SELECT IF file2=0 OR file1=0.


LIST.

This will show a list of all the cases which don't match.  And you get two extra
variables file1 and file2 showing where those cases came from.

J'


On Mon, Jul 19, 2010 at 02:09:42PM +1000, Michelle Parker wrote:
     Hi Michel
     
     Thanks for getting back to me.
     
     The files have 730 variables, types and lengths are identical.
     There are 13 cases in each file.
     
     Some of the cases may have different values (eg date/times) but in general 
they should be the same between files. Specifically I need to know if there are 
any differences.
     
     thanks!
     mich
     
     
     
     
     
     On 19/07/2010, at 12:48 PM, Michel Boaventura wrote:
     
     > Hello Michelle,
     > 
     > Would you like to compare the variables or the cases on the files? If 
the variables,
     > it matters if they have the same name but diverge on type, length, etc?
     > 
     > Regards,
     > 
     > Michel
     > 
     > _______________________________________________
     > Pspp-users mailing list
     > address@hidden
     > http://lists.gnu.org/mailman/listinfo/pspp-users
     
     ---------------------------------------
     Michelle Parker
     Web Objectives Pty Ltd
     33 Ridge St
     Gordon, NSW, 2072
     Australia 
     Phone: (02) 9499 3166
     Fax: (02) 9499 3166
     Mobile : 0412 064 123
     address@hidden
     ---------------------------------------
     
     
     

     _______________________________________________
     Pspp-users mailing list
     address@hidden
     http://lists.gnu.org/mailman/listinfo/pspp-users


-- 
PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://pgp.mit.edu or any PGP keyserver for public key.

signature.asc
Description: Digital signature