Exporting to Separate Excel Sheets

[Hughes, John]

I need to be able to save subsets of my file into separate sheets within
a single excel file (i.e. one worksheet per county). I cannot see how to
do this using the save translate command. Does anyone have a suggestion?

 

Thanks,

John Hughes

Agency for Workforce Innovation, Florida.

[Siraj Ur-rehman]

I copied my syntax which I am using by the help of Richard.

Siraj

GET FILE='K:\Data\SPSS\dbo_tb_survey_information-SPSS.sav'.

select if (quarter=1).

SAVE TRANSLATE
 /CONNECT='DSN=Excel Files;DBQ=C:\Documents and Settings\Desktop\SPSS
Testing\Avaya.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;'
 /TABLE="Quarter1"
 /TYPE=ODBC
 /REPLACE.
exe.

*******************Richard's email****************************.

From: Oliver, Richard [mailto:[hidden email]]
Sent: Tuesday, March 28, 2006 3:21 PM
To: Siraj Ur-rehman; [hidden email]
Subject: RE: Different Excel file in one Master file

If by "master file" you mean a single workbook with multiple worksheets,
Ray Levesque just showed me how to do this using SAVE TRANSLATE
TYPE=ODBC, specifying the sheet names on the TABLE subcommand. The only
really tricky part is figuring out the correct connect string --
although you can obtain this by using the Database Wizard to read any
Excel file, paste the syntax, and then copy the connect string, changing
the Excel file specification to whatever you want. Everything but the
worksheet name specified on the TABLE subcommand should be the same for
each Save Translate command.

************************************************************************
********




-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Hughes, John
Sent: Monday, June 19, 2006 3:03 PM
To: [hidden email]
Subject: Exporting to Separate Excel Sheets

I need to be able to save subsets of my file into separate sheets within
a single excel file (i.e. one worksheet per county). I cannot see how to
do this using the save translate command. Does anyone have a suggestion?



Thanks,

John Hughes

Agency for Workforce Innovation, Florida.

[Steve Powell]

Dear list members
This one is driving me nuts - I often have to create a series of charts for
a set of variables which are all measured on the same scale - 0 to 5 for
example. But the GRAPH routine sets auto maxima and minima for the y-axis
which may vary according to the data. Is there any way to force fixed maxima
and minima? This doesn't seem to be available via the GRAPH command and
doesn't seem to be "stick" when using a template.
Any thoughts?
Thanks
Steve Powell

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Siraj Ur-rehman
Sent: 19 June 2006 21:16
To: [hidden email]
Subject: Re: Exporting to Separate Excel Sheets

I copied my syntax which I am using by the help of Richard.

Siraj

GET FILE='K:\Data\SPSS\dbo_tb_survey_information-SPSS.sav'.

select if (quarter=1).

SAVE TRANSLATE
 /CONNECT='DSN=Excel Files;DBQ=C:\Documents and Settings\Desktop\SPSS
Testing\Avaya.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;'
 /TABLE="Quarter1"
 /TYPE=ODBC
 /REPLACE.
exe.

*******************Richard's email****************************.

From: Oliver, Richard [mailto:[hidden email]]
Sent: Tuesday, March 28, 2006 3:21 PM
To: Siraj Ur-rehman; [hidden email]
Subject: RE: Different Excel file in one Master file

If by "master file" you mean a single workbook with multiple worksheets,
Ray Levesque just showed me how to do this using SAVE TRANSLATE
TYPE=ODBC, specifying the sheet names on the TABLE subcommand. The only
really tricky part is figuring out the correct connect string --
although you can obtain this by using the Database Wizard to read any
Excel file, paste the syntax, and then copy the connect string, changing
the Excel file specification to whatever you want. Everything but the
worksheet name specified on the TABLE subcommand should be the same for
each Save Translate command.

************************************************************************
********




-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Hughes, John
Sent: Monday, June 19, 2006 3:03 PM
To: [hidden email]
Subject: Exporting to Separate Excel Sheets

I need to be able to save subsets of my file into separate sheets within
a single excel file (i.e. one worksheet per county). I cannot see how to
do this using the save translate command. Does anyone have a suggestion?



Thanks,

John Hughes

Agency for Workforce Innovation, Florida.

[Keith McCormick]

Hi Steve,

There are ways to handle this with templates in recent versions, but
the easiest way is to use GPL which can be pasted from the "Chart
Builder".  Make the changes on the line below, which I pasted from
help. {A minimum is possible too} I hope you are using 14.0 as Chart
Builder is new.  Build the chart, paste the syntax and change the
SCALE line.

SCALE: linear(dim(2), max(50000))

HTH

Keith
keithmccormick.com

On 6/22/06, Steve Powell <[hidden email]> wrote:

> Dear list members
> This one is driving me nuts - I often have to create a series of charts for
> a set of variables which are all measured on the same scale - 0 to 5 for
> example. But the GRAPH routine sets auto maxima and minima for the y-axis
> which may vary according to the data. Is there any way to force fixed maxima
> and minima? This doesn't seem to be available via the GRAPH command and
> doesn't seem to be "stick" when using a template.
> Any thoughts?
> Thanks
> Steve Powell
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Siraj Ur-rehman
> Sent: 19 June 2006 21:16
> To: [hidden email]
> Subject: Re: Exporting to Separate Excel Sheets
>
> I copied my syntax which I am using by the help of Richard.
>
> Siraj
>
> GET FILE='K:\Data\SPSS\dbo_tb_survey_information-SPSS.sav'.
>
> select if (quarter=1).
>
> SAVE TRANSLATE
>  /CONNECT='DSN=Excel Files;DBQ=C:\Documents and Settings\Desktop\SPSS
> Testing\Avaya.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;'
>  /TABLE="Quarter1"
>  /TYPE=ODBC
>  /REPLACE.
> exe.
>
> *******************Richard's email****************************.
>
> From: Oliver, Richard [mailto:[hidden email]]
> Sent: Tuesday, March 28, 2006 3:21 PM
> To: Siraj Ur-rehman; [hidden email]
> Subject: RE: Different Excel file in one Master file
>
> If by "master file" you mean a single workbook with multiple worksheets,
> Ray Levesque just showed me how to do this using SAVE TRANSLATE
> TYPE=ODBC, specifying the sheet names on the TABLE subcommand. The only
> really tricky part is figuring out the correct connect string --
> although you can obtain this by using the Database Wizard to read any
> Excel file, paste the syntax, and then copy the connect string, changing
> the Excel file specification to whatever you want. Everything but the
> worksheet name specified on the TABLE subcommand should be the same for
> each Save Translate command.
>
> ************************************************************************
> ********
>
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Hughes, John
> Sent: Monday, June 19, 2006 3:03 PM
> To: [hidden email]
> Subject: Exporting to Separate Excel Sheets
>
> I need to be able to save subsets of my file into separate sheets within
> a single excel file (i.e. one worksheet per county). I cannot see how to
> do this using the save translate command. Does anyone have a suggestion?
>
>
>
> Thanks,
>
> John Hughes
>
> Agency for Workforce Innovation, Florida.
>