« Return to Thread: Save translate outfiles (excel) using a filter variable
Re: Save translate outfiles (excel) using a filter variable
by Francien Berndsen
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
About two months ago I
wrote an answer to a similar question:
It's possible to create a multiple sheet excelfile
by saving your data with the function ‘file’ -> 'export to
database'. You have the option to save the data in a sheet with a name you
choose. Unfortunately you have to do this for every sheet, so in your case you
have to do this for every country and you have to select the country first.
But it is possible to save those different sheets
in the same excel file.
Another member of SPSSX-L wrote an answer too, but
then you have to use Python.
Francien
Van: SPSSX(r)
Discussion [mailto:SPSSX-L@...] Namens
Brian Moore
Verzonden: woensdag 8 juli 2009
21:13
Aan: SPSSX-L@...
Onderwerp: Re: [SPSSX-L] Save
translate outfiles (excel) using a filter variable
My
preference would be separate sheets in one workbook, but either would be
helpful [though with separate files the filename would be where I’d need
country to be slugged in as the values].
From:
Oliver, Richard [mailto:roliver@...]
Sent: Wednesday, July 08, 2009
11:23 AM
To: Brian Moore;
SPSSX-L@...
Subject: RE: Save translate
outfiles (excel) using a filter variable
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@...] On Behalf Of Brian Moore
Sent: Wednesday, July 08, 2009
8:51 AM
To: SPSSX-L@...
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
Tel: 480-304-6832 Fax: 480-483-8352
E-mail: brian.moore@...
www.worldatwork.org
UPCOMING CONFERENCES:
Total
Rewards 2009 Asia Pacific
Oct. 7-9 |
Total
Rewards 2010
May 16-19 |
« Return to Thread: Save translate outfiles (excel) using a filter variable
| Free embeddable forum powered by Nabble | Forum Help |
