Help using SPSSINC merge tables

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Help using SPSSINC merge tables

J McClure
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