| Date: | Mon, 6 Jul 2009 11:13:55 -0500 |
|---|
| Reply-To: | Melissa Ives <mives@chestnut.org> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | Melissa Ives <mives@chestnut.org> |
|---|
| Subject: | Setting pivot table dimensions |
|---|
| Content-Type: | multipart/alternative;
|
|---|
Hello all,
I am looking for a way to set crosstab and means tables to default to a different setting in crosstabs from this:
Title
Studyid Study ID-text (Not to be confused with XStudy)
Total
1
2
3
VARB
A
Count
468
132
26
626
% within VARB
74.8%
21.1%
4.2%
100.0%
% within Studyid
47.7%
52.8%
47.3%
48.7%
B
Count
513
118
29
660
% within VARB
77.7%
17.9%
4.4%
100.0%
% within Studyid
52.3%
47.2%
52.7%
51.3%
Total
Count
981
250
55
1286
% within VARB
76.3%
19.4%
4.3%
100.0%
% within Studyid
100.0%
100.0%
100.0%
100.0%
to this (i.e. move the statistics dimension in the row from 1 to 0 (from second to first).
Title
Studyid Study ID-text (Not to be confused with XStudy)
Total
1
2
3
Count
VARB
A
468
132
26
626
B
513
118
29
660
Total
981
250
55
1286
% within VARB
VARB
A
74.8%
21.1%
4.2%
100.0%
B
77.7%
17.9%
4.4%
100.0%
Total
76.3%
19.4%
4.3%
100.0%
% within Studyid
VARB
A
47.7%
52.8%
47.3%
48.7%
B
52.3%
47.2%
52.7%
51.3%
Total
100.0%
100.0%
100.0%
100.0%
In SPSS version 14, I had a script that did this. I cannot get it to work in 17, but is seems to me that this would be a standard option or at least commonly available. Does anyone have a way to do this as a default that can be turned off so I can revert to the standard output?
I also prefer means tables to be similarly formatted - which generally means switching the variables (row becomes column and column becomes row) and leaving statistics in the first dimension of row.
Melissa Ives
mives@chestnut.org
voice: 309-451-7819
________________________________
PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.
[text/html]
| 
