Thanks Jon! Works like a charm!
Now I'm moving on to the extension that should color the significant cells, the ones with the letter marks.
I tried to run the MODIFY TABLE APPEARANCE extension. While I don't get any error or warning, it also doesn't
change anything in the table.
These are my settings for the extension:
SPSSINC MODIFY TABLES subtype="customtable"
SELECT="<ALL>"
DIMENSION= COLUMNS LEVEL = -1 SIGCELLS=ALLSIG SIGLEVELS=BOTH
PROCESS = PRECEDING PRINTLABELS=FALSE
/STYLES APPLYTO=DATACELLS
BACKGROUNDCOLOR=255 255 0.
If you could point me in the right direction with this problem, I'd appreciate it very much.
Thanks,
Tal
------------------------------
Tal van Dijk
------------------------------
Original Message:
Sent: Sun September 05, 2021 01:09 PM
From: Jon Peck
Subject: Merge Viewer extension doesn't seem to work properly
Sorry, as a consequence of the Python 3 conversion of the extension commands, something got broken in this command. I found and fixed the problem, but I forgot to tell you to update your installation.
Get the spe file from here and install it with Extensions > Install Local Extension Bundle
The version on the Extension Hub will get updated, but this may take a little while.
Let me know how this works.
--
Original Message:
Sent: 9/5/2021 3:16:00 AM
From: Tal van Dijk
Subject: RE: Merge Viewer extension doesn't seem to work properly
Hi Jon,
Thanks for your reply.
I tried to run the modified syntax for Merge Tables but got this warning:
" name 'f' is not defined ".
Something in the functions seems to be undefined.
Can you tell me what's going on here?
Thanks!
------------------------------
Tal van Dijk
Original Message:
Sent: Wed September 01, 2021 03:42 PM
From: Jon Peck
Subject: Merge Viewer extension doesn't seem to work properly
This simple looking table has a very strange internal structure when the statistic type is hidden. One of the segments of the row label is duplicated, so the internal labels for the first table don't match the labels for the sig table. It is possible to write a small custom row function to modify these labels on the fly, but there are some other issues that I will need to investigate.
The good news is that MERGE TABLES has some alternative functions to the standard functions used for label-based matching. Since these tables both have the same dimensions, you can just use these. They simply match by the row and column numbers.
Here is the modified syntax.
SPSSINC MERGE TABLES ATTACH=ROWS omitstatisticslevel=yes
rowfunction="SPSSINC_MERGE_TABLES.rowfuncbynumber"
colfunction="SPSSINC_MERGE_TABLES.colfuncbynumber"
/OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES printlevels=no
HALIGN=RIGHT SEPARATOR="\n".
--
Original Message:
Sent: 9/1/2021 3:44:00 AM
From: Tal van Dijk
Subject: RE: Merge Viewer extension doesn't seem to work properly
Many thanks, Jon! I just sent you an e-mail which includes a SPV output file.
Check your spam if it doesn't pop up in your inbox.
------------------------------
Tal van Dijk
Original Message:
Sent: Tue August 31, 2021 06:16 PM
From: Jon Peck
Subject: Merge Viewer extension doesn't seem to work properly
The internal structure of CTABLES output can be complicated, and some experimentation with MERGE TABLES may be necessary. If you want to send me an spv file containing the table you want to modify, I can take a look. (jkpeck@gmail.com)
------------------------------
Jon Peck
Original Message:
Sent: Tue August 31, 2021 08:07 AM
From: Tal van Dijk
Subject: Merge Viewer extension doesn't seem to work properly
Hi all,
I have a question about merging two tables that I created in CTABLES. The cells in the primary table contain percentages while the secondary table contains letter codes in case of significant differences between columns.
I have the Merge Viewer extension installed and work with SPSS version 25.
When I set the statistics label as "visible" in the CTABLES syntax, the merge works well, but when it is set as not visible it doesn't.
Here is what I mean syntax-wise:
in the CTABLES syntax: /SLABELS POSITION=ROW VISIBLE=YES works in conjunction with
SPSSINC MERGE TABLES MATCHLABEL="Column N %" .
Changing to VISIBLE=NO doesn't.
What might be the problem here? Anyone?
Thanks,
Tal
------------------------------
Tal van Dijk
------------------------------
#SPSSStatistics