Hi Judy,
Have you looked at the OUTPUT EXPORT commands, or through the GUI
File>Export... Here is an example that might assist (assuming you have
Version 17.0 or later)
Regards,
Jason
GET FILE='C:\Program
Files\SPSSInc\Statistics17\Samples\English\Employee data.sav'.
DATASET NAME hr WINDOW=FRONT.
CTABLES
/VLABELS VARIABLES=jobcat bdate DISPLAY=LABEL
/TABLE jobcat BY bdate [MINIMUM, MAXIMUM]
/CATEGORIES VARIABLES=jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE.
* NOTE: you can choose from the following keywords CREATEFILE,
CREATESHEET or MODIFYSHEET for the OPERATION subcommand ..
OUTPUT EXPORT
/CONTENTS EXPORT=ALL LAYERS=PRINTSETTING MODELVIEWS=PRINTSETTING
/XLS DOCUMENTFILE='R:\Summary.xls'
OPERATION=CREATEFILE SHEET='25March2008'
LOCATION=LASTCOLUMN NOTESCAPTIONS=YES.
On Wed, Mar 25, 2009 at 8:50 AM, Judy Harmon <
[hidden email]> wrote:
> I'm having trouble exporting output from SPSS into Excel. Do you have to
> create a new Excel spread sheet each time? And if I try to paste my data
> from the output into excel, the date field is not correct. How do I fix
> the date field if I just want to copy and paste the output into Excel? I
> know SPSS's date is based on something from 1600 or something like that.
> Thanks!
>
> =====================
> 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
Locked
