export multiple sheets based on split file to excel

[Brian Moore-7]

Hi all-

I know how to export a full SPSS file as an excel sheet (either new or
into existing workbook), but not sure how to do so while creating a
sheet for each split of a split file.

I'm using version 15 & not using Python, am indifferent to a new or
existing workbook solution, and am assuming file names would/could be
the name of values in the split variable (which is a 10 character string
named ccountrycode).

Any assistance greatly appreciated.
Regards,
Brian

Brian Moore
Market Research Manager
WorldatWork
14040 N. Northsight Blvd.
Scottsdale, AZ 85260 USA
Tel: [phone] Fax: [phone]
E-mail: [hidden email]
www.worldatwork.org

UPCOMING CONFERENCES:
Total Rewards Europe 2008
<http://www.totalrewardseurope.org/html/index.jsp>
Oct. 28-30 | Brussels

The GTA Rewards Association
2008 Canadian Total Rewards Conference
<http://www.worldatwork.org/toronto2008>
In partnership with the Ottawa Region Rewards Association and
WorldatWork
Nov. 17-19 | Toronto

Total Rewards 2009 <http://www.worldatwork.org/seattle2009>
May 31- June 3 | Seattle

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

[Valerie Guille-2]

Hi all,

I hope someone will be able to help me.

I have 3-way RM ANOVA with genotype, sex, limb as factors and week (6 in
total) as repeated measure.
Briefly, I have rodents running on a treadmill and I look at different
parameters of their gait. Each of these gait parameters will be analysed
separately.
I have 4 groups (male WT, female WT, male KO and female KO) and I want
to include their limbs (fore and hind) as factor.

I try to run the following syntax in SPSS 15:

MIXED
  Swing  BY Limb Sex Genotype
  /CRITERIA = CIN(95) MXITER(100) MXSTEP(5) SCORING(1)
  SINGULAR(0.000000000001) HCONVERGE(0, ABSOLUTE) LCONVERGE(0, ABSOLUTE)
  PCONVERGE(0.000001, ABSOLUTE)
  /FIXED = Limb Genotype Genotype*Limb*Sex  | SSTYPE(3)
  /METHOD = REML
  /PRINT = CORB COVB DESCRIPTIVES G R SOLUTION TESTCOV
 /RANDOM INTERCEPT  | SUBJECT(Genotype*Sex) COVTYPE(ID)
  /REPEATED = week | SUBJECT(AnimalID*Genotype*Sex) COVTYPE(UN)
  /EMMEANS = TABLES(OVERALL)
  /EMMEANS = TABLES(Limb) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype*Limb*Sex)  .

And I ge the following warning:

The levels of the repeated effect are not different for each observation
within a repeated subject. This command is not executed.

I don't understand what that mean exactly. Could  anyone explain to me
please.

Thanks in advance,

Sincerely yours,

Val

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

[Maguin, Eugene]

Valerie,

I admit that I'd probably use GLM rather than Mixed for an RM anova. That
aside, shouldn't Week be listed in the 'By' list? See example 9 (below) in
the syntax ref.

MIXED Y BY STAGE
/FIXED = STAGE
/REPEATED = STAGE | SUBJECT(SUBJ) COVTYPE(CS).

Also, I think a pure RM would covtype of CS (compound symmetry) rather than
UN (unstructured) even though UN is more general. And (here, I'm just
curious) I'd expect limb gait parameters to be correlated within animals.
Thus treating Limb as a repeated factor.


Gene Maguin

>>I have 3-way RM ANOVA with genotype, sex, limb as factors and week (6 in
total) as repeated measure.
Briefly, I have rodents running on a treadmill and I look at different
parameters of their gait. Each of these gait parameters will be analysed
separately.
I have 4 groups (male WT, female WT, male KO and female KO) and I want
to include their limbs (fore and hind) as factor.

I try to run the following syntax in SPSS 15:

MIXED
  Swing  BY Limb Sex Genotype
  /CRITERIA = CIN(95) MXITER(100) MXSTEP(5) SCORING(1)
  SINGULAR(0.000000000001) HCONVERGE(0, ABSOLUTE) LCONVERGE(0, ABSOLUTE)
  PCONVERGE(0.000001, ABSOLUTE)
  /FIXED = Limb Genotype Genotype*Limb*Sex  | SSTYPE(3)
  /METHOD = REML
  /PRINT = CORB COVB DESCRIPTIVES G R SOLUTION TESTCOV
 /RANDOM INTERCEPT  | SUBJECT(Genotype*Sex) COVTYPE(ID)
  /REPEATED = week | SUBJECT(AnimalID*Genotype*Sex) COVTYPE(UN)
  /EMMEANS = TABLES(OVERALL)
  /EMMEANS = TABLES(Limb) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype*Limb*Sex)  .

And I ge the following warning:

The levels of the repeated effect are not different for each observation
within a repeated subject. This command is not executed.

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

[Reutter, Alex]

The warning suggests that there is a replicated value of week within one of the subjects defined by AnimalID*Genotype*Sex.  You should be able to use Identify Duplicate Cases to find it.

Alex


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Valerie Guille
Sent: Thursday, October 23, 2008 5:33 PM
To: [hidden email]
Subject: 3-way repeated measures ANOVA

Hi all,

I hope someone will be able to help me.

I have 3-way RM ANOVA with genotype, sex, limb as factors and week (6 in
total) as repeated measure.
Briefly, I have rodents running on a treadmill and I look at different
parameters of their gait. Each of these gait parameters will be analysed
separately.
I have 4 groups (male WT, female WT, male KO and female KO) and I want
to include their limbs (fore and hind) as factor.

I try to run the following syntax in SPSS 15:

MIXED
  Swing  BY Limb Sex Genotype
  /CRITERIA = CIN(95) MXITER(100) MXSTEP(5) SCORING(1)
  SINGULAR(0.000000000001) HCONVERGE(0, ABSOLUTE) LCONVERGE(0, ABSOLUTE)
  PCONVERGE(0.000001, ABSOLUTE)
  /FIXED = Limb Genotype Genotype*Limb*Sex  | SSTYPE(3)
  /METHOD = REML
  /PRINT = CORB COVB DESCRIPTIVES G R SOLUTION TESTCOV
 /RANDOM INTERCEPT  | SUBJECT(Genotype*Sex) COVTYPE(ID)
  /REPEATED = week | SUBJECT(AnimalID*Genotype*Sex) COVTYPE(UN)
  /EMMEANS = TABLES(OVERALL)
  /EMMEANS = TABLES(Limb) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(Genotype*Limb*Sex)  .

And I ge the following warning:

The levels of the repeated effect are not different for each observation
within a repeated subject. This command is not executed.

I don't understand what that mean exactly. Could  anyone explain to me
please.

Thanks in advance,

Sincerely yours,

Val

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