Try something like this syntax:
OMS
/SELECT TABLES
/IF COMMANDS = ['Crosstabs'] SUBTYPES = ['Crosstabulation']
/DESTINATION FORMAT = SAV
OUTFILE = 'path/SPSSfilename.sav'
VIEWER = NO .
CROSSTABS
/TABLES= Var1 BY Var2
/FORMAT= AVALUE TABLES
/CELLS= COUNT
/COUNT ROUND CELL .
OMSEND .
GET FILE 'path/SPSSfilename.sav' .
DELETE VARIABLES Command_ Subtype_ Label_ Var8 Var9 .
RENAME VARIABLES (Var2=Category).
SAVE OUTFILE = 'path/SPSSfilename.sav' .
SAVE TRANSLATE OUTFILE='path/ExcelFilename.xls' /FIELDNAMES /REPLACE .
Meredith (Bud) Bliss
Crime Analyst - Beaverton Police Dept.
4755 SW Griffith Drive
Beaverton, OR 97005
503-526-2294 - Fax: 503-526-2541
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of sauce
Sent: Tuesday, November 30, 2010 3:04 AM
To:
[hidden email]
Subject: Export table excel
Hi all.
I would like to know if there is a script or a syntaxe to export crosstabs
in a excel file (.xls).
Thank in advance for your reply.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Export-table-excel-tp3285908p3285908.htmlSent from the SPSSX Discussion mailing list archive at Nabble.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
======================================================================
PUBLIC RECORDS LAW DISCLOSURE
This e-mail is a public record of the City of Beaverton and is subject to public disclosure unless exempt from disclosure under Oregon Public Records Law. This email is subject to the State Retention Schedule.
=====================
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
Locked
