| Date: | Mon, 31 Jan 2005 12:06:54 -0600 |
|---|
| Reply-To: | gornykm@comnetcom.net |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | Karen Gorny <gornykm@comnetcom.net> |
|---|
| Subject: | Re: SPSS to Excel |
|---|
| In-Reply-To: | <3A9E375AF395774E8BF7211238D97A402CFAF6@fsmail.SHEEOPRIV.local> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
SPSS has an Export_to_Excel script that is available on their
Scripting Library web site. You have to log in to the Technical
Support web site, select Utilities->SPSS Scripting Library->Export.
Karen
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Tara Bisel
Sent: Monday, January 31, 2005 11:23 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: SPSS to Excel
I have a data set of all 50 states for years 1978-2004. I want to run a
report in SPSS that I can then import to Excel in 50 separate
worksheets. I can get the output to separate into one per state (using
split file option) but does anyone know of a way to then import into
Excel into separate worksheets (one per state)? My old method was to
cut and paste each table from SPSS output into a separate worksheet.
Any way to automate this?
Tara Bisel
Data Analyst
SHEEO
700 Broadway Suite 1200
Denver, CO 80203
303-299-3682
303-299-9016 (fax)
tbisel@sheeo.org
| 
