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 2003)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sat, 29 Mar 2003 22:13:11 -0500
Reply-To:     Art@DrKendall.org
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Arthur J. Kendall" <Art@DrKendall.org>
Organization: Social Research Consultants
Subject:      Re: Merging Files
Comments: To: jeff_hayes@stratalys.com
Content-Type: text/plain; charset=us-ascii; format=flowed

If the following does not address your problem, please post the syntax and a small amount of data demonstrating the problem.

new file. data list fixed /TYPE 1-9 (a) ASSETS 10-12. begin data Ibm 150 Sun 200 end data. save outfile = 'c:\temp\orgs.sav'.

new file. data list fixed /NAME (a8) ADDRESS(a11) TYPE(a9). begin data John Chicago Ibm Steve NYC Ibm Ann NYC Ibm Jack Austin Sun Paul NYC Sun Tim Chicago Xerox end data. list. match file file=* /table= 'c:\temp\orgs.sav' by type. list.

Hope this helps.

Art Art@DrKendall.org Social Research Consultants University Park, MD USA (301) 864-5570

Jeff Hayes, Ph.D. wrote: > I have two files - organizations (ORGS) and individuals (INDS). The files > share one variable - TYPE. I would like to merge the two files so as to add > variables from ORGS to INDS, matching on TYPE. So, for instance ... > > ORGS has ... > > TYPE ASSETS > Ibm 150 > Sun 200 > > INDS has ... > > NAME ADDRESS TYPE > John Chicago Ibm > Steve NYC Ibm > Ann NYC Ibm > Jack Austin Sun > Paul NYC Sun > Tim Chicago Xerox > > The problem arises when I Merge -> Add Variables -> Match on TYPE with Both > Files Provide Cases. SPSS will create ASSETS in the INDS file, but only > populate the first TYPE record with the proper value. So, John has ASSETS of > 150, but Steve and Ann show no data. Matching on External File (ORGS) deletes > all INDS records with no TYPE value in ORGS (i.e., Tim). Is there a workaround > for this? > > Thanks! > > Cheers, > Jeff > > ===== > ======================================= > Jeff Hayes, Ph.D. > Stratalys Research > Washington, DC > jeff_hayes@stratalys.com > (tel1)202.234.7219 (tel2)202.468.7219 > (fax)202.234.7852 > > __________________________________________________ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! > http://platinum.yahoo.com >


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