HI,
I'm not sure if the below is readable cut I have cut and pasted in
my output in a .htm format.
I am making my first try at merging two tables. The first table is a
crosstabs (primary) and the second is the test statistics results
(secondary) from the crosstabs. I want the p-vales from the
chi-squared test to be a new column in the crosstabs table
I got an error message:
SPSSINC MERGE TABLES MATCHLABEL="p-value" ATTACH=COLUMNS
MODE=MERGE
/OPTIONS HIDE=NO APPENDTITLE=NO APPENDCAPTION=NO ADDLABELLEAF=YES
HALIGN=RIGHT SEPARATOR="\n".
Error: global name 'omitstatistics' is not defined
I saw in the merge files dialog box help file that there may be a
hidden level called 'statistics'. Is this the problem and if so how
do I deal with it?
Thanks,
Jan
* Custom Tables.
CTABLES
/VLABELS VARIABLES=PHQ_sleepD S_Affect_anxD MajDeprsn DISPLAY=DEFAULT
/TABLE PHQ_sleepD [C][COLPCT.COUNT PCT40.1, COUNT F40.0] + S_Affect_anxD [C][COLPCT.COUNT PCT40.1, COUNT F40.0] BY MajDeprsn [C]
/CATEGORIES VARIABLES=PHQ_sleepD S_Affect_anxD MajDeprsn ORDER=A KEY=VALUE EMPTY=INCLUDE
/TITLES
TITLE='Test merge'
/SIGTEST TYPE=CHISQUARE ALPHA=0.05 INCLUDEMRSETS=NO CATEGORIES=ALLVISIBLE.
Custom Tables
Notes |
Output
Created |
08-Dec-2010 16:13:59 |
Comments |
|
Input |
Data |
C:\Jan\PhD\PhD_analysis\VStudy1DT\VSTUDY1DT2.sav |
Active Dataset |
DataSet1 |
Filter |
<none> |
Weight |
<none> |
Split File |
<none> |
N of Rows in Working
Data File |
482 |
Syntax |
CTABLES
/VLABELS VARIABLES=PHQ_sleepD S_Affect_anxD
MajDeprsn DISPLAY=DEFAULT
/TABLE PHQ_sleepD [C][COLPCT.COUNT PCT40.1, COUNT
F40.0] + S_Affect_anxD [C][COLPCT.COUNT PCT40.1,
COUNT F40.0] BY MajDeprsn [C]
/CATEGORIES VARIABLES=PHQ_sleepD S_Affect_anxD
MajDeprsn ORDER=A KEY=VALUE EMPTY=INCLUDE
/TITLES
TITLE='Test merge'
/SIGTEST TYPE=CHISQUARE ALPHA=0.05 INCLUDEMRSETS=NO
CATEGORIES=ALLVISIBLE.
|
Resources |
Processor Time |
00:00:00.047 |
Elapsed Time |
00:00:00.046 |
|
[DataSet1] C:\Jan\PhD\PhD_analysis\VStudy1DT\VSTUDY1DT2.sav
Table 1
Test
merge |
|
Major
depression PHQ-9) |
no |
yes |
Column N % |
Count |
Column N % |
Count |
Insomnia
or hypersomnia |
Not at all |
21.2% |
44 |
2.2% |
6 |
Several days or more |
78.8% |
164 |
97.8% |
266 |
Intense
Anxiety/Anxiety Attacks |
Not at all |
40.6% |
84 |
10.7% |
29 |
Several days or more |
59.4% |
123 |
89.3% |
242 |
|
Pearson
Chi-Square Tests |
|
Major
depression PHQ-9) |
Insomnia
or hypersomnia |
Chi-square |
45.348 |
df |
1 |
Sig. |
.000* |
Intense
Anxiety/Anxiety Attacks |
Chi-square |
58.039 |
df |
1 |
Sig. |
.000* |
Results are based on nonempty rows
and columns in each innermost subtable. |
*. The Chi-square statistic is
significant at the 0.05 level. |
|
SPSSINC MERGE TABLES MATCHLABEL="p-value" ATTACH=COLUMNS
MODE=MERGE
/OPTIONS HIDE=NO APPENDTITLE=NO APPENDCAPTION=NO ADDLABELLEAF=YES
HALIGN=RIGHT SEPARATOR="\n".
Error: global name 'omitstatistics' is not defined
=====================
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