Date:         Wed, 8 Jul 2009 13:22:49 -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: Save translate outfiles (excel) using a filter variable
Comments: To: Brian Moore <Brian.Moore@WORLDATWORK.ORG>
In-Reply-To:  A<40A4A53F5727324F8ADCDF4A219CF68106A075A6@mail5.worldatwork.org>
Content-Type: multipart/alternative;

What do you mean by "multiple Excel sheets"? Separate sheets in the same workbook/file or separate files?

 

________________________________

From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Brian Moore
Sent: Wednesday, July 08, 2009 8:51 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Save translate outfiles (excel) using a filter variable

 

Hi all-

I'm using SPSS 15 and hoping to save data from SPSS into multiple excel sheets.  The variable I want to split by is a string & named country.

And I'd like each sheet including only (and ideally named with the value of) a particular split of the full file.  

Thanks,

Brian

Brian Moore
Market Research Manager
WorldatWork

14040 N. Northsight Blvd.
Scottsdale, AZ. 85260 USA
Tel: 480-304-6832 Fax: 480-483-8352
E-mail: brian.moore@worldatwork.org
www.worldatwork.org <http://www.worldatwork.org> 

UPCOMING CONFERENCES:
Total Rewards 2009 Asia Pacific <http://www.worldatwork.org/waw/conference/html/conference-home.html> 
Oct. 7-9 | Hong Kong

Total Rewards 2010 <http://www.worldatwork.org/texas2010> 
May 16-19  |  Dallas / Ft.Worth, TX


[text/html]