|Date: ||Tue, 7 Sep 1999 09:56:39 EDT|
|Reply-To: ||PAULA P <PELLET@CCVM.SUNYSB.EDU>|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||PAULA P <PELLET@CCVM.SUNYSB.EDU>|
|Organization: ||State University of New York at Stony Brook|
|Subject: ||Output Tables to Excel|
|Content-Type: ||TEXT/PLAIN; charset=US-ASCII|
I routinely generate six fairly complex tables for a client using the
General Tables facility within SPSS 9.0. Now they would like these
same tables in Excel format, i.e., as sheets within an Excel workbook.
The tables are generated within a production setup. My question is:
how do I do this? Is there any way, without manual pointing and
clicking, to select each of the tables and plunk them into an Excel
spreadsheet? I suspect that a script program is what I need. I know
syntax inside and out, but the script language remains a mystery.
Can anyone give suggestions on my problem or a jump-start on
scripting? (I know I could aggregate the data and export to Excel
with Save Translate, but this seems archaic.) Thanks in advance.
Paula Pelletier * Institutional Research * SUNY at Stony Brook