|Date: ||Sat, 29 May 2004 10:24:53 -0400|
|Reply-To: ||Raynald Levesque <firstname.lastname@example.org>|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||Raynald Levesque <email@example.com>|
|Subject: ||Re: Spss 12 Layered Pivot to Separate Worksheets|
|Content-type: ||text/plain; charset=iso-8859-1|
Personnally I prefer to export data to a single excel sheet. The script I
use groups lines related to a single table, charts or IGRAPH and collapses
them to a single line in the Excel sheet (using the Group and Outline
feature of Excel). Clicking on the + (-) in the left margin displays (hides)
the table.I find this method very convenient to go from one table to the
next when I have hundreds of tables / charts. It is easier than having to
locate the appropriate sheet.
Take a look, this might be useful to you.
The version that exports all Layers of a Pivot Table is version 4 (see file
#5 of the Excel section of
Raynald Levesque firstname.lastname@example.org
Visit my SPSS site: http://pages.infinit.net/rlevesqu/
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Sent: May 28, 2004 4:42 PM
Subject: Spss 12 Layered Pivot to Separate Worksheets
We generate several pivot tables with 3 to 57 layers in SPSS-12.
We would like to be able to export these pivot tables to Excel 2000 through
syntax or vb/macros. Ideally, we would like each layer to populate a
separate worksheet/tab, using the layer value as the tab name.
The code we have found will only export/copy the current layer to Excel.
This necessitates editing the pivot to get next layer and running the code
again. We are trying to get this into a production type mode and eliminate
as much human interaction as possible.
Thanks in advance