LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2001)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 27 Mar 2001 13:11:11 -0000
Reply-To:     Shail Dobson <dobson_shail@HOTMAIL.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Shail Dobson <dobson_shail@HOTMAIL.COM>
Subject:      Re: Merging Files and Aggregating Data
Comments: To: Rjohnson@AAMC.ORG
Content-Type: text/html

<html><DIV> <P> </P> <P class=MsoNormal>Rebecca,</P> <P class=MsoNormal>&nbsp;In your case, I suggest you to use Access.</P> <P class=MsoNormal>&nbsp;Shail</P></DIV>&gt;From: Rebecca Johnson <RJOHNSON@AAMC.ORG> <DIV></DIV>&gt;Reply-To: Rebecca Johnson <RJOHNSON@AAMC.ORG> <DIV></DIV>&gt;To: SPSSX-L@LISTSERV.UGA.EDU <DIV></DIV>&gt;Subject: Merging Files and Aggregating Data <DIV></DIV>&gt;Date: Mon, 26 Mar 2001 11:28:42 -0500 <DIV></DIV>&gt; <DIV></DIV>&gt;Hello- <DIV></DIV>&gt; <DIV></DIV>&gt;I have two large databases which I am trying to merge. Both have SSN, so I can merge the files using SSN as the key variable. There are multiple cases in each file with the same SSN, but not necessarily the same number of cases in the two different databases. I have a few questions. <DIV></DIV>&gt; <DIV></DIV>&gt;1) When I merge files, does it matter which file is the working data file and which is the external file? Does SPSS keep all the matching cases from one file, but drop the cases from the other? For example, if in one file there are 5 cases with the same SSN and in the other file there are 3 cases with the same SSN, what does SPSS do with the extra 2 cases with matching SSNs but not a corresponding case in the other file? <DIV></DIV>&gt; <DIV></DIV>&gt;2) Dealing with this same data with duplicate SSNs, aggregating the data into one case per SSN, is there a way to list the data, to keep all values, instead of summarizing it? Could this maybe be done before I aggregate the data, maybe by recoding the variables...? <DIV></DIV>&gt; <DIV></DIV>&gt;Thats enough for now. <DIV></DIV>&gt; <DIV></DIV>&gt;Rebecca E. Johnson <DIV></DIV>&gt;Research Associate <DIV></DIV>&gt;Section for the Medical College Admission Test <DIV></DIV>&gt;Association of American Medical Colleges <DIV></DIV>&gt;2450 N St., NW <DIV></DIV>&gt;Washington, DC 20037 <DIV></DIV>&gt;202-828-0625 <DIV></DIV>&gt;RJohnson@aamc.org <DIV></DIV>&gt; <DIV></DIV>&gt;Rebecca E. Johnson <DIV></DIV>&gt;Research Associate <DIV></DIV>&gt;Section for the Medical College Admission Test <DIV></DIV>&gt;Association of American Medical Colleges <DIV></DIV>&gt;2450 N St., NW <DIV></DIV>&gt;Washington, DC 20037 <DIV></DIV>&gt;202-828-0625 <DIV></DIV>&gt;RJohnson@aamc.org <DIV></DIV><br clear=all><hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>


Back to: Top of message | Previous page | Main SPSSX-L page