SPSSX Discussion

Multiple Regression Models

Classic

List

Threaded

13 messages Options

jimjohn

Multiple Regression Models

when you guys are building multiple regression models, if an independent variable on its own is not significant, but in a regression model with many other independent variables, adding this variable increases the strength of the model (higher Adjusted R^2). In this case, would you recommend keeping the model with the variable that on its own is not significant. Or, would you only consider variables that have significatn pairwise correlations with the dependent variable. Thanks!

SR Millis-3

Re: Multiple Regression Models

Adding any variable will increase R^2--even if it's worthless.

Variable selection is guided by several considerations:

--Theory
--Subject-to-variable ratio
--Study aims/hypotheses

among other things.

Parenthetically, using R^2 to judge models has limitations. You need to supplement R^2 with other indices, eg, BIC and AIC.

Scott R Millis, PhD, MEd, ABPP (CN,CL,RP), CStat
Professor & Director of Research
Dept of Physical Medicine & Rehabilitation
Wayne State University School of Medicine
261 Mack Blvd
Detroit, MI 48201
Email: [hidden email]
Tel: 313-993-8085
Fax: 313-966-7682

--- On Mon, 7/28/08, jimjohn <[hidden email]> wrote:

> From: jimjohn <[hidden email]>
> Subject: Multiple Regression Models
> To: [hidden email]
> Date: Monday, July 28, 2008, 4:20 PM
> when you guys are building multiple regression models, if an
> independent
> variable on its own is not significant, but in a regression
> model with many
> other independent variables, adding this variable increases
> the strength of
> the model (higher Adjusted R^2). In this case, would you
> recommend keeping
> the model with the variable that on its own is not
> significant. Or, would
> you only consider variables that have significatn pairwise
> correlations with
> the dependent variable. Thanks!
> --
> View this message in context:
> http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.html
> Sent from the SPSSX Discussion mailing list archive at
> Nabble.com.
>
> =====================
> 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

Swank, Paul R

Re: Multiple Regression Models

In reply to this post by jimjohn

The question is, is the increase significant. If so then there are at
least two possible reasons. One is power. If the other variables in the
model account for a large proportion of the DVs variance, then this
variable may become significant because of the increased sensitivity of
the F test when the overall R^2 is larger. The second possibility is a
suppressor variable. That is, this variable is unrelated to the DV but
is related to another IV and suppresses superfluous variance in the
other IV and making the model seem stronger.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Monday, July 28, 2008 3:21 PM
To: [hidden email]
Subject: Multiple Regression Models

when you guys are building multiple regression models, if an independent
variable on its own is not significant, but in a regression model with
many
other independent variables, adding this variable increases the strength
of
the model (higher Adjusted R^2). In this case, would you recommend
keeping
the model with the variable that on its own is not significant. Or,
would
you only consider variables that have significatn pairwise correlations
with
the dependent variable. Thanks!
--
View this message in context:
http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.htm
l
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

Thien Hop

Splitting banners to multiple sheets in Excel

Dear all,

I have posted my questions a few times but it might be not clear enough so
nobody responded.. I'm trying to make it clearer this time:

I want to ataumatically split different vairables on banner to different
worksheets in Excel ie. a Ctable of newspapers read by Age + Gender...I wish
to have 2 worksheets "newspaper read by Age" & "newspaper read by Gender"

Would much appreciate if anyone could help me out!

Thanks a lot,

Hop

=====================
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

Albert-Jan Roskam

Re: Splitting banners to multiple sheets in Excel

Hi,

Maybe you can let SPSS spit out single-sheet xls files (using SAVE TRANSLATE) and then use some tool to merge those individual files? I did something like that before. Maybe this one will work:
http://www.softinterface.com/Convert-XLS%5CFeatures%5CMerge-Excel-Files.htm

But if it's more than a one-time job, perhaps you could use the pyexcellerator Python module. I can send that module to you offlist, if you like.

Cheers!!
Albert-Jan

--- On Tue, 7/29/08, Thien Hop <[hidden email]> wrote:

> From: Thien Hop <[hidden email]>
> Subject: Splitting banners to multiple sheets in Excel
> To: [hidden email]
> Date: Tuesday, July 29, 2008, 8:10 AM
> Dear all,
>
> I have posted my questions a few times but it might be not
> clear enough so
> nobody responded.. I'm trying to make it clearer this
> time:
>
> I want to ataumatically split different vairables on banner
> to different
> worksheets in Excel ie. a Ctable of newspapers read by Age
> + Gender...I wish
> to have 2 worksheets "newspaper read by Age"
> & "newspaper read by Gender"
>
> Would much appreciate if anyone could help me out!
>
> Thanks a lot,
>
> Hop
>
> =====================
> 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

Arthur Kramer

Re: Multiple Regression Models

In reply to this post by Swank, Paul R

I think I would look at the "R^2 change" of this variable in the complete
model, and then consider the cost/benefit of keeping this model in regard to
my theory and what I would be using the model to support.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Swank, Paul R
Sent: Monday, July 28, 2008 5:42 PM
To: [hidden email]
Subject: Re: Multiple Regression Models

The question is, is the increase significant. If so then there are at
least two possible reasons. One is power. If the other variables in the
model account for a large proportion of the DVs variance, then this
variable may become significant because of the increased sensitivity of
the F test when the overall R^2 is larger. The second possibility is a
suppressor variable. That is, this variable is unrelated to the DV but
is related to another IV and suppresses superfluous variance in the
other IV and making the model seem stronger.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Monday, July 28, 2008 3:21 PM
To: [hidden email]
Subject: Multiple Regression Models

when you guys are building multiple regression models, if an independent
variable on its own is not significant, but in a regression model with
many
other independent variables, adding this variable increases the strength
of
the model (higher Adjusted R^2). In this case, would you recommend
keeping
the model with the variable that on its own is not significant. Or,
would
you only consider variables that have significatn pairwise correlations
with
the dependent variable. Thanks!
--
View this message in context:
http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.htm
l
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

Art Kendall

Re: Splitting banners to multiple sheets in Excel

In reply to this post by Thien Hop

What about doing 2 custom tables?

Or doing the split within Excel?

Art Kendall
Social Research Consultants

Thien Hop wrote:

> Dear all,
>
> I have posted my questions a few times but it might be not clear
> enough so
> nobody responded.. I'm trying to make it clearer this time:
>
> I want to ataumatically split different vairables on banner to different
> worksheets in Excel ie. a Ctable of newspapers read by Age +
> Gender...I wish
> to have 2 worksheets "newspaper read by Age" & "newspaper read by Gender"
>
> Would much appreciate if anyone could help me out!
>
> Thanks a lot,
>
> Hop
>
> =====================
> 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
>
>

Art Kendall
Social Research Consultants

Swank, Paul R

Re: Multiple Regression Models

In reply to this post by Arthur Kramer

If I have a significant variable in a model, I try to understand why
it's there before I discard it just because it doesn't fit my theory.
Sometimes serendipity happens.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: Arthur Kramer [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 7:56 AM
To: Swank, Paul R; [hidden email]
Subject: RE: Multiple Regression Models

I think I would look at the "R^2 change" of this variable in the
complete
model, and then consider the cost/benefit of keeping this model in
regard to
my theory and what I would be using the model to support.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Swank, Paul R
Sent: Monday, July 28, 2008 5:42 PM
To: [hidden email]
Subject: Re: Multiple Regression Models

The question is, is the increase significant. If so then there are at
least two possible reasons. One is power. If the other variables in the
model account for a large proportion of the DVs variance, then this
variable may become significant because of the increased sensitivity of
the F test when the overall R^2 is larger. The second possibility is a
suppressor variable. That is, this variable is unrelated to the DV but
is related to another IV and suppresses superfluous variance in the
other IV and making the model seem stronger.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Monday, July 28, 2008 3:21 PM
To: [hidden email]
Subject: Multiple Regression Models

when you guys are building multiple regression models, if an independent
variable on its own is not significant, but in a regression model with
many
other independent variables, adding this variable increases the strength
of
the model (higher Adjusted R^2). In this case, would you recommend
keeping
the model with the variable that on its own is not significant. Or,
would
you only consider variables that have significatn pairwise correlations
with
the dependent variable. Thanks!
--
View this message in context:
http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.htm
l
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

Peck, Jon

Re: Splitting banners to multiple sheets in Excel

In reply to this post by Thien Hop

This is fairly complicated to do. You would have to extract different subtables and distribute them to different sheets.

Why don't you just run separate tables for each variable and export them to different Excel sheets if you want separate results anyway? If you are worried about data passes, note that you can have many TABLE subcommands in the same Ctables command.

The SaxBasic code Export Tables to Excel available from SPSS Developer Central (www.spss.com/devcentral) downloads section provides a script that will export a set of tables to different sheets in the same Excel file. It works with SPSS 15 and later (and probably works with earlier versions, too.)

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Thien Hop
Sent: Tuesday, July 29, 2008 12:10 AM
To: [hidden email]
Subject: [SPSSX-L] Splitting banners to multiple sheets in Excel

Dear all,

I have posted my questions a few times but it might be not clear enough so
nobody responded.. I'm trying to make it clearer this time:

I want to ataumatically split different vairables on banner to different
worksheets in Excel ie. a Ctable of newspapers read by Age + Gender...I wish
to have 2 worksheets "newspaper read by Age" & "newspaper read by Gender"

Would much appreciate if anyone could help me out!

Thanks a lot,

Hop

=====================
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

Arthur Kramer

Re: Multiple Regression Models

In reply to this post by Swank, Paul R

True enough. However, in an applied situation one may have to decide if the
cost of keeping a variable is worth the cost--financial or otherwise--of
inclusion. Parsimony may take precedence.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong

-----Original Message-----
From: Swank, Paul R [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 12:06 PM
To: Arthur Kramer; [hidden email]
Subject: RE: Multiple Regression Models

If I have a significant variable in a model, I try to understand why
it's there before I discard it just because it doesn't fit my theory.
Sometimes serendipity happens.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: Arthur Kramer [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 7:56 AM
To: Swank, Paul R; [hidden email]
Subject: RE: Multiple Regression Models

I think I would look at the "R^2 change" of this variable in the
complete
model, and then consider the cost/benefit of keeping this model in
regard to
my theory and what I would be using the model to support.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Swank, Paul R
Sent: Monday, July 28, 2008 5:42 PM
To: [hidden email]
Subject: Re: Multiple Regression Models

The question is, is the increase significant. If so then there are at
least two possible reasons. One is power. If the other variables in the
model account for a large proportion of the DVs variance, then this
variable may become significant because of the increased sensitivity of
the F test when the overall R^2 is larger. The second possibility is a
suppressor variable. That is, this variable is unrelated to the DV but
is related to another IV and suppresses superfluous variance in the
other IV and making the model seem stronger.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Monday, July 28, 2008 3:21 PM
To: [hidden email]
Subject: Multiple Regression Models

when you guys are building multiple regression models, if an independent
variable on its own is not significant, but in a regression model with
many
other independent variables, adding this variable increases the strength
of
the model (higher Adjusted R^2). In this case, would you recommend
keeping
the model with the variable that on its own is not significant. Or,
would
you only consider variables that have significatn pairwise correlations
with
the dependent variable. Thanks!
--
View this message in context:
http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.htm
l
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

Swank, Paul R

Re: Multiple Regression Models

Either way, a decision has to be made. It cannot be automated, it must
be done considering the theory and the potential for new knowledge.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: Arthur Kramer [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 2:36 PM
To: Swank, Paul R; [hidden email]
Subject: RE: Multiple Regression Models

True enough. However, in an applied situation one may have to decide if
the
cost of keeping a variable is worth the cost--financial or otherwise--of
inclusion. Parsimony may take precedence.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong

-----Original Message-----
From: Swank, Paul R [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 12:06 PM
To: Arthur Kramer; [hidden email]
Subject: RE: Multiple Regression Models

If I have a significant variable in a model, I try to understand why
it's there before I discard it just because it doesn't fit my theory.
Sometimes serendipity happens.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: Arthur Kramer [mailto:[hidden email]]
Sent: Tuesday, July 29, 2008 7:56 AM
To: Swank, Paul R; [hidden email]
Subject: RE: Multiple Regression Models

I think I would look at the "R^2 change" of this variable in the
complete
model, and then consider the cost/benefit of keeping this model in
regard to
my theory and what I would be using the model to support.

Arthur Kramer, Ph.D.
Director of Institutional Research
New Jersey City University
Phone: 201-200-3073
Fax: 201-200-3288

"...believe half of what you see and none of what you hear."
N.Whitfield and B.Strong
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Swank, Paul R
Sent: Monday, July 28, 2008 5:42 PM
To: [hidden email]
Subject: Re: Multiple Regression Models

The question is, is the increase significant. If so then there are at
least two possible reasons. One is power. If the other variables in the
model account for a large proportion of the DVs variance, then this
variable may become significant because of the increased sensitivity of
the F test when the overall R^2 is larger. The second possibility is a
suppressor variable. That is, this variable is unrelated to the DV but
is related to another IV and suppresses superfluous variance in the
other IV and making the model seem stronger.

Paul R. Swank, Ph.D.
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center - Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Monday, July 28, 2008 3:21 PM
To: [hidden email]
Subject: Multiple Regression Models

when you guys are building multiple regression models, if an independent
variable on its own is not significant, but in a regression model with
many
other independent variables, adding this variable increases the strength
of
the model (higher Adjusted R^2). In this case, would you recommend
keeping
the model with the variable that on its own is not significant. Or,
would
you only consider variables that have significatn pairwise correlations
with
the dependent variable. Thanks!
--
View this message in context:
http://www.nabble.com/Multiple-Regression-Models-tp18698762p18698762.htm
l
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

Thien Hop

Re: Splitting banners to multiple sheets in Excel

In reply to this post by Albert-Jan Roskam

Dear Albert-Jan, Art Kendall and Jon Peck,

Thank you so much for spending your time on my issue and sharing opinions! I
will try out all your suggestions.

But the problem is that I normally have to run a number of Tabs with many
variables on banners. Hence if I take turn to manually run all the tabs with
each variables on banner (cross-break) it will be very time consuming.
Moreover when the tabs are exported to Excel, some formatting is also needed
so the job becomes much more tedious.

If you have any work-around way to this please advise.

Thank

----- Original Message -----
From: "Albert-jan Roskam" <[hidden email]>
To: <[hidden email]>; "Thien Hop" <[hidden email]>
Sent: Tuesday, July 29, 2008 8:38 PM
Subject: Re: Splitting banners to multiple sheets in Excel

> Hi,
>
> Maybe you can let SPSS spit out single-sheet xls files (using SAVE
> TRANSLATE) and then use some tool to merge those individual files? I did
> something like that before. Maybe this one will work:
> http://www.softinterface.com/Convert-XLS%5CFeatures%5CMerge-Excel-Files.htm
>
> But if it's more than a one-time job, perhaps you could use the
> pyexcellerator Python module. I can send that module to you offlist, if
> you like.
>
> Cheers!!
> Albert-Jan
>
>
> --- On Tue, 7/29/08, Thien Hop <[hidden email]> wrote:
>
>> From: Thien Hop <[hidden email]>
>> Subject: Splitting banners to multiple sheets in Excel
>> To: [hidden email]
>> Date: Tuesday, July 29, 2008, 8:10 AM
>> Dear all,
>>
>> I have posted my questions a few times but it might be not
>> clear enough so
>> nobody responded.. I'm trying to make it clearer this
>> time:
>>
>> I want to ataumatically split different vairables on banner
>> to different
>> worksheets in Excel ie. a Ctable of newspapers read by Age
>> + Gender...I wish
>> to have 2 worksheets "newspaper read by Age"
>> & "newspaper read by Gender"
>>
>> Would much appreciate if anyone could help me out!
>>
>> Thanks a lot,
>>
>> Hop
>>
>> =====================
>> 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
>
>
>

Peck, Jon

Re: Splitting banners to multiple sheets in Excel

If you need both types, why not just run the Ctables commands both ways? You could generate the syntax for this programmatically so there wouldn't need to be any manual part. You could even direct the two versions to different output windows (SPSS 15 or later).

As for manual formatting, that could probably be programmed also, depending on the details, on either the SPSS or Excel side.

Not knowing the details, it's hard to be more specific.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Thien Hop
Sent: Tuesday, July 29, 2008 10:05 PM
To: [hidden email]
Subject: Re: [SPSSX-L] Splitting banners to multiple sheets in Excel

Dear Albert-Jan, Art Kendall and Jon Peck,

Thank you so much for spending your time on my issue and sharing opinions! I
will try out all your suggestions.

But the problem is that I normally have to run a number of Tabs with many
variables on banners. Hence if I take turn to manually run all the tabs with
each variables on banner (cross-break) it will be very time consuming.
Moreover when the tabs are exported to Excel, some formatting is also needed
so the job becomes much more tedious.

If you have any work-around way to this please advise.

Thank

----- Original Message -----
From: "Albert-jan Roskam" <[hidden email]>
To: <[hidden email]>; "Thien Hop" <[hidden email]>
Sent: Tuesday, July 29, 2008 8:38 PM
Subject: Re: Splitting banners to multiple sheets in Excel

=====================
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