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 (October 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 31 Oct 2002 07:20:21 -0500
Reply-To:     Raynald Levesque <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Raynald Levesque <>
Subject:      Re: Combining data files
In-Reply-To:  <>
Content-type: text/plain; charset=us-ascii


* Create 2 data files to illustrate solution.

DATA LIST LIST /id idsup rating. BEGIN DATA 1 1 4 2 1 5 3 1 5 4 2 2 5 2 3 6 3 4 END DATA. LIST. SAVE OUTFILE='c:\temp\employees.sav'.

DATA LIST LIST /idsup sales. BEGIN DATA 1 100 2 150 3 112 4 200 END DATA. LIST.

* file must be sorted to do the MATCH below. SORT CASES BY idsup. SAVE OUTFILE='c:\temp\supervisors.sav'.

*** Start job. GET FILE='c:\temp\employees.sav'.

AGGREGATE OUTFILE=* /BREAK=idsup /rating=MEAN(rating).

MATCH FILES TABLE=* /FILE='c:\temp\supervisors.sav' /BY=idsup. EXECUTE.


Raynald Levesque Visit my SPSS Pages

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of Keefer, Robert P. Sent: October 30, 2002 10:21 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Combining data files


I have two data files. The first is responses from employees (about 200), and includes comments about their supervisors. There are 16 different supervisors. In a second file, other information about the 16 supervisors (16 lines of data). I would like to take the summary information about the supervisors from the first file and merge it with the second file. I looked over Raynald's site, but couldn't decided if any of those were appropriate. Thanks for any help.

bob k.

PS: I'm on Digest; a CC: to my address appreciated.

----------------------- ------------------------- Robert Keefer Associate Professor Psychology Department Office Phone: Mt. St. Mary's College (301) 447-5394, Ext. 4251 Emmitsburg, MD 21727 e-mail: [Speaking for myself.] fax: 301-447-5021 ----------------------- -------------------------

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