Excel pivot on SPSS sav file

[Christos Makrigeorgis]

Hello all, I am sure this question has been asked before simply because
one cannot find the answer on spss.com or google.com.

Q: I would like to create an Excel pivot table that will point to (read
from) an SPSS sav file. Is this possible? Essentially I would like to
generate my spss .sav file, then allow a user to open Excel and refresh
the pivot table within Excel. I do not want to be creating intermdiate
text files as for example sav --> txt --> Excel pivot.

I am using SPSS 15.0 and Excel 2003.

Thanks
-- Christos

=====================
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

[ViAnn Beadle]

You can save the spss data file directly as an Excel file in Excel 97 format
via the SAVE TRANSLATE command.

I'm not sure how you will be refresh it as a pivot table within Excel.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Christos Makrigeorgis
Sent: Saturday, November 10, 2007 12:03 PM
To: [hidden email]
Subject: Excel pivot on SPSS sav file

Hello all, I am sure this question has been asked before simply because
one cannot find the answer on spss.com or google.com.

Q: I would like to create an Excel pivot table that will point to (read
from) an SPSS sav file. Is this possible? Essentially I would like to
generate my spss .sav file, then allow a user to open Excel and refresh
the pivot table within Excel. I do not want to be creating intermdiate
text files as for example sav --> txt --> Excel pivot.

I am using SPSS 15.0 and Excel 2003.

Thanks
-- Christos

=====================
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

=====================
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

[Oliver, Richard]

I know that Excel pivot tables can get data from an external data source. If that data source can be a database table, it might be possible to read the SPSS data file as a database table using the SPSS ODBC driver.
 
Alternatively, if you don't mind an "intermediate" file that is a separate sheet in the same Excel file as the pivot table, you could use Save Translate Type=ODBC and the Excel ODBC driver to save the SPSS data file to a specified sheet name in the Excel file. You need to use Type=ODBC because Type=XLS doesn't support writing to specific sheet names.

________________________________

From: SPSSX(r) Discussion on behalf of ViAnn Beadle
Sent: Sat 11/10/2007 2:37 PM
To: [hidden email]
Subject: Re: Excel pivot on SPSS sav file



You can save the spss data file directly as an Excel file in Excel 97 format
via the SAVE TRANSLATE command.

I'm not sure how you will be refresh it as a pivot table within Excel.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Christos Makrigeorgis
Sent: Saturday, November 10, 2007 12:03 PM
To: [hidden email]
Subject: Excel pivot on SPSS sav file

Hello all, I am sure this question has been asked before simply because
one cannot find the answer on spss.com or google.com.

Q: I would like to create an Excel pivot table that will point to (read
from) an SPSS sav file. Is this possible? Essentially I would like to
generate my spss .sav file, then allow a user to open Excel and refresh
the pivot table within Excel. I do not want to be creating intermdiate
text files as for example sav --> txt --> Excel pivot.

I am using SPSS 15.0 and Excel 2003.

Thanks
-- Christos

=====================
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

=====================
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

====================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

[Daniel E. Martin, Ph.D.]

Folks,

My copy of SPSS will let me register, then state that the registration does
not work when I try to use it. Any help would be great.

Dan
Daniel E. Martin, Ph.D.

Assistant Professor, Department of Management
College of Business and Economics
California State University, East Bay
[hidden email]
[phone]

=====================
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

[Christos Makrigeorgis]

Oliver, thanks, I finally figured it out going through ODBC. It works
fine. Yes, the second option was also viable.
-- Christos


On Sat, 10 Nov 2007 16:44:31 -0600, Oliver, Richard <[hidden email]>
wrote:

>I know that Excel pivot tables can get data from an external data source.
If that data source can be a database table, it might be possible to read
the SPSS data file as a database table using the SPSS ODBC driver.
>
>Alternatively, if you don't mind an "intermediate" file that is a
separate sheet in the same Excel file as the pivot table, you could use
Save Translate Type=ODBC and the Excel ODBC driver to save the SPSS data
file to a specified sheet name in the Excel file. You need to use
Type=ODBC because Type=XLS doesn't support writing to specific sheet names.

>
>________________________________
>
>From: SPSSX(r) Discussion on behalf of ViAnn Beadle
>Sent: Sat 11/10/2007 2:37 PM
>To: [hidden email]
>Subject: Re: Excel pivot on SPSS sav file
>
>
>
>You can save the spss data file directly as an Excel file in Excel 97

format

>via the SAVE TRANSLATE command.
>
>I'm not sure how you will be refresh it as a pivot table within Excel.
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>Christos Makrigeorgis
>Sent: Saturday, November 10, 2007 12:03 PM
>To: [hidden email]
>Subject: Excel pivot on SPSS sav file
>
>Hello all, I am sure this question has been asked before simply because
>one cannot find the answer on spss.com or google.com.
>
>Q: I would like to create an Excel pivot table that will point to (read
>from) an SPSS sav file. Is this possible? Essentially I would like to
>generate my spss .sav file, then allow a user to open Excel and refresh
>the pivot table within Excel. I do not want to be creating intermdiate
>text files as for example sav --> txt --> Excel pivot.
>
>I am using SPSS 15.0 and Excel 2003.
>
>Thanks
>-- Christos
>
>=====================
>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
>
>=====================
>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
>
>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
>
>=====================
>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

=====================
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