Posted by
statisticsdoc on
Dec 29, 2011; 6:21pm
URL: http://spssx-discussion.165.s1.nabble.com/merge-multiple-excel-worksheets-tp5108097p5108333.html
Scott,
In a nutshell, open each sheet in spss, sort by the key variable(s) that you want to merge on, save each sheet in an sav fiile, merge the sav files by the key variables that you want to merge the files on. To get the syntax for opening a specific excel sheet, use open file, choose xls, and then choose the paste rather than the open option.
Best,
Stephen Brand
------Original Message------
From: Scott Roesch
Sender: SPSSX(r) Discussion
To:
[hidden email]
ReplyTo: Scott Roesch
Subject: merge multiple excel worksheets
Sent: Dec 29, 2011 11:42 AM
Hi all:
Is there a quick way to convert multiple worksheets in Excel into a
merged SPSS/PASW data file?
Scott
=====================
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
www.StatisticsDoc.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