Date:         Thu, 10 Apr 2008 20:49:24 -0500
Reply-To:     "Oliver, Richard" <roliver@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Oliver, Richard" <roliver@spss.com>
Subject:      Re: exporting selected variables from spss to Excel
Comments: To: John Amora <bayesian2001@yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

save translate outfile='/folderpath/filename.xls'
  /type=xls
  /replace /*if the file already exists*/
  /fieldnames /*if you want variable names in the first row*/
  /keep varlist. /*or drop if the list of variables to not include is shorter*/.

________________________________

From: SPSSX(r) Discussion on behalf of John Amora
Sent: Thu 4/10/2008 7:46 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: exporting selected variables from spss to Excel



Hello listers,

Some selected variables from spss datafile will be
exported to MS Excel.  The resulting excel datafile
should be saved to a specified folder using a
specified filename.  Do you know the syntax?

Thank you in advance.

John



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com/> 

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
LISTSERV@LISTSERV.UGA.EDU (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