Re: merge multiple excel worksheets

Posted by Jon K Peck on Dec 29, 2011; 6:38pm
URL: http://spssx-discussion.165.s1.nabble.com/merge-multiple-excel-worksheets-tp5108097p5108353.html

One shortcut: you can just open each Excel file in Statistics and then use it in the merge step (after sorting if needed).  There is no need to save each Excel file as a sav file first.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Statisticsdoc Consulting <[hidden email]>
To:        [hidden email]
Date:        12/29/2011 11:26 AM
Subject:        Re: [SPSSX-L] merge multiple excel worksheets
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

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