Script difference between 2 versions of a dataset.

[ivar klung]

Hi,

I need to find a solution to script/syntax the difference between 2
versions of a dataset.

We have an ”original” file – let us call it dataOrig.sav and another file
called dataEdited.sav., which is a heavily edited version of dataOrig.sav.

Now, unfortunately the person doing all of these edits, did all of these
edits directly in SPSS data editor, and did not save the syntax session
log file etc while doing his edits. So a lot of edits, that are probably
valid, but not documented through i.e. a syntax or script file.

Further, a new version of dataOrig.sav has been created, let us call it
dataOrig2.sav, which contains some updates to dataOrig.sav

I’m now faced with the challenge of merging all of the edits made through
dataEdited.sav into the new dataOrig2.sav file.

What I need to find a solution for is.
  1. Create a syntax or script file that properly depicts the changes from
dataOrig.sav to dataEdited.sav
  2. Run this syntax/script on the new dataOrig2.sav

I have looked at SPSS data entry etc, but that can not create a syntax
file that can update the new dataOrig2.sav file.

Each record has a unique ID, and this id must be used to identify cases,
while only updates should be included in the script. I.e. if only
variables C,D,R,Q and X for case A1098X has been edited the syntax should
only update those fields for that case (and not the others, as they may
have been updated in the dataOrig2.sav file.

I hope this makes sense!

Any help, pointers or directions are highly appreciated!

Thank you! (:=

Best regards,

Ivar klung

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

[Peck, Jon]

There is an extension command for SPSS that will compare two datasets.  It can compare the variable dictionary, the data, or both.  For case comparisons, it uses an id variable to match them up.  There is a version called COMPDS that will work with SPSS 16 and a newer version SPSSINC COMPARE DATASETS for SPSS Statistics 17 that is essentially the same functionality but has a dialog box interface as well as syntax.

The output includes a short summary report in the Viewer and, optionally, case and/or variable difference variables created in the primary dataset.

Both of these can be downloaded from SPSS Developer Central (www.spss.com/devcentral).  They require the Python programmability plug-in.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ivar klung
Sent: Monday, November 24, 2008 1:17 PM
To: [hidden email]
Subject: [SPSSX-L] Script difference between 2 versions of a dataset.

Hi,

I need to find a solution to script/syntax the difference between 2
versions of a dataset.

We have an ”original” file – let us call it dataOrig.sav and another file
called dataEdited.sav., which is a heavily edited version of dataOrig.sav.

Now, unfortunately the person doing all of these edits, did all of these
edits directly in SPSS data editor, and did not save the syntax session
log file etc while doing his edits. So a lot of edits, that are probably
valid, but not documented through i.e. a syntax or script file.

Further, a new version of dataOrig.sav has been created, let us call it
dataOrig2.sav, which contains some updates to dataOrig.sav

I’m now faced with the challenge of merging all of the edits made through
dataEdited.sav into the new dataOrig2.sav file.

What I need to find a solution for is.
  1. Create a syntax or script file that properly depicts the changes from
dataOrig.sav to dataEdited.sav
  2. Run this syntax/script on the new dataOrig2.sav

I have looked at SPSS data entry etc, but that can not create a syntax
file that can update the new dataOrig2.sav file.

Each record has a unique ID, and this id must be used to identify cases,
while only updates should be included in the script. I.e. if only
variables C,D,R,Q and X for case A1098X has been edited the syntax should
only update those fields for that case (and not the others, as they may
have been updated in the dataOrig2.sav file.

I hope this makes sense!

Any help, pointers or directions are highly appreciated!

Thank you! (:=

Best regards,

Ivar klung

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

[Johnny Amora]

Hi all,

I apologize for cross posting.

I am pleased and thankful if you could email me offlist the Job Descriptions for any/both of the following Director positions:

1. Director for Institutional Research
2. Director for Planning and Assessment
3. Director for Testing and Research
4. Director for Research
5. Director for Educational Research

Any Director position related to research will do.  I will just use it for reference purposes.

Thank you.
Johnny Amora


      How can I fight insomnia? Discover how on Yahoo! Answers

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

[Khaneja, Gurvinder]

Johnny
Go to following site:  www.airweb.org and you will get many many job descriptions for all of the listed positions.

Gurvinder Khaneja

________________________________

From: SPSSX(r) Discussion on behalf of Johnny Amora
Sent: Mon 11/24/2008 8:48 PM
To: [hidden email]
Subject: Job Descriptions for a Research Director Position



Hi all,

I apologize for cross posting.

I am pleased and thankful if you could email me offlist the Job Descriptions for any/both of the following Director positions:

1. Director for Institutional Research
2. Director for Planning and Assessment
3. Director for Testing and Research
4. Director for Research
5. Director for Educational Research

Any Director position related to research will do.  I will just use it for reference purposes.

Thank you.
Johnny Amora


      How can I fight insomnia? Discover how on Yahoo! Answers

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

[Johnny Amora]

Hi Bruno, thank you for your suggestion and offer.  I don't need to spend money because hundreds are available for free at www.airweb.org. :)

Thank you so much, Gurvinder Khaneja, for providing the website.

All the best,
Johnny



__

--- On Tue, 11/25/08, bruno rodrigues <[hidden email]> wrote:
From: bruno rodrigues <[hidden email]>
Subject: Re: Job Descriptions for a Research Director Position
To: [hidden email]
Date: Tuesday, 25 November, 2008, 11:39 AM

Dear Jonny,

I suggest that you read Malhotra´s marketing reseach book (2005),
there is a role chapter discussing job description in a research institute.

Otherwise,
you can always wire me some money to send you a complete report on that.
:D

Best Regards,

Bruno

2008/11/24 Johnny Amora <[hidden email]>:
> Hi all,
>
> I apologize for cross posting.
>
> I am pleased and thankful if you could email me offlist the Job
Descriptions

> for any/both of the following Director positions:
>
> 1. Director for Institutional Research
> 2. Director for Planning and Assessment
> 3. Director for Testing and Research
> 4. Director for Research
> 5. Director for Educational Research
>
> Any Director position related to research will do.  I will just use it for
> reference purposes.
>
> Thank you.
> Johnny Amora
>
> ________________________________
> Get your preferred Email name!
> Now you can @ymail.com and @rocketmail.com.
> -------------------------------------------------------------- To
> unsubscribe from SEMNET, send email to [hidden email] with the body

of
> the message as: SIGNOFF SEMNET Search the archives at
> http://bama.ua.edu/archives/semnet.html

--------------------------------------------------------------
To unsubscribe from SEMNET, send email to [hidden email]
        with the body of the message as: SIGNOFF SEMNET
Search the archives at http://bama.ua.edu/archives/semnet.html



      Try cool new emoticons, skins, plus more space for friends.
Download Yahoo! Messenger Philippines now!
http://ph.messenger.yahoo.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