SPSSINC MERGE TABLES not working
I'm using the "Merge Viewer Tables ..." dialog box to merge 2 simple CTABLES output tables. (Table 1)<br>
Tried allmost every combination and the result is allways the same: (Table 2)<br>
The Proportions Table doesn't apear in the result, just it's header and a part of it's footnote.<br>
What am I doing wrong?
This is the Syntax of my last attempt<br>
SPSSINC MERGE TABLES MATCHLABEL="count" ATTACH=ROWS
MODE=MERGE
/OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
HALIGN=CENTER SEPARATOR="\n".
Please post the syntax you are using.
This is the CTABLES syntax<br>
MRSETS
/MCGROUP NAME=$v188 LABEL=" 2, "
VARIABLES=V311 v311a.
CTABLES
/FORMAT EMPTY=BLANK MISSING='.' /SMISSING VARIABLE
/TABLE $v188 [C][COLPCT.COUNT PCT40.0, TOTALShttp://COUNT PAREN40.0]
BY edu[c]+ inc[c]+ agex[C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=$v188 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='N=' POSITION=AFTER
/COMPARETEST TYPE=PROP ALPHA=0.1 ADJUST=NONE ORIGIN=COLUMN
/TITLES TITLE=" - ".
and This is the pasted Syntax from the Merge dialog box:
DATASET ACTIVATE DataSet1.
SPSSINC MERGE TABLES MATCHLABEL="Count" ATTACH=COLUMNS
MODE=MERGE
/OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
HALIGN=RIGHT SEPARATOR="\n".
This table is deceptively simple. It contains in the rows a hidden statistics label. You need to specify that label as the match point. The default label is Count, but your table just has percentages, so you need to specify that hidden label as MATCHLABEL.<br>
This syntax will do it.
SPSSINC MERGE TABLES ATTACH=ROWS MATCHLABEL="Column N %"
MODE=MERGE
/OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
HALIGN=RIGHT SEPARATOR="\n".
HTH,
Jon Peck
worked like a charm!<br>
tank you very much
How many times have I been down this "error road" I had to do a reinstall of both V20 & Python<br>
Running the following:
CTABLES
/VLABELS VARIABLES=educ jobcat DISPLAY=LABEL
/TABLE educ [C] BY jobcat [C] http://COUNT F40.0, ROWPCT.COUNT PCT40.1, COLPCT.COUNT PCT40.1
/CATEGORIES VARIABLES=educ ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER
MISSING=EXCLUDE
/CATEGORIES VARIABLES=jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE.
SPSSINC MODIFY TABLES subtype="Custom Table"
SELECT="%"
DIMENSION= COLUMNS
LEVEL = -1 PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.
And get this error:\
>Error # 6890. Command name: BEGIN PROGRAM
>Configuration file spssdxcfg.ini is invalid.
>Execution of this command stops.
Configration file spssdxcfg.ini is invalid because the LIB_NAME is NULL.
Tks
I have no idea why this keeps coming up for you, but it doesn't have to do specifically with MERGE TABLES. The Python plugin is not installed or is not installed correctly. If uninstalling and reinstalling it doesn't clear this up, please contact Technical Support.<br>
Regards,
Jon
Thanks Jon, figured it was the Python install so will go that suggested route<br>
BTY, what version is used by V21? I know it should install with the full installation but just in case can it be installed separately and if so, where available?
Tks
W
Version 21 has a corresponding Python Essentials 21 that is included on the installation media and downloadable with the Statistics product. You no longer go to the SPSS Community site to get it. It is still a separate install. It uses Python 2.7, which is the same Python version as V20. On Windows, Python will be installed as part of the Essentials install if needed.<br>
The V21 Essentials includes some additional extension commands compared with V20 that you used to have to get from the SPSS Community site (but there are still plenty of others up there).
Regards,
Jon
Thanks again Jon