Split Files And Custom Tables

[SUBSCRIBE SPSSX-JohnF]

Using the split file function within the context of custom tables, if for instance, you split by state, the title is footnoted with "a" and then the a appears at the bottom of the table as, for example, a. STATE = Virginia.  Is there any code to eliminate this?  I have a variable of State in the table so the footnote is overkill.  Any input will be appreciated, Thanks.

=====================
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

[Jon Peck]

An alternative would be to put the split variable in the layer of the table instead of using SPLIT FILES.

There is no built-in way to suppress the footnote, but you can do this using the SPSSINC MODIFY TABLES extension command with a tiny custom function.

First, define the function...

begin program.
def hidefootnote(obj, i, j, numrows, numcols, section, more, custom):
    Footnotes = more.thetable.FootnotesArray()
    Footnotes.SetTextHiddenAt(0, True)
    return False
end program.

Then, following the CTABLES commands, run this.

 SPSSINC MODIFY TABLES subtype="customtable"

SELECT=0
DIMENSION= COLUMNS LEVEL = -1
PROCESS = ALL
/STYLES  APPLYTO=LABELS
CUSTOMFUNCTION="__main__.hidefootnote".

That will remove the first footnote, if any, from all the CTABLES objects.

SPSSINC MODIFY TABLES can be installed from the Extensions > Extension Hub menu.

On Tue, Jul 30, 2019 at 11:21 AM SUBSCRIBE SPSSX-JohnF <[hidden email]> wrote:

Using the split file function within the context of custom tables, if for instance, you split by state, the title is footnoted with "a" and then the a appears at the bottom of the table as, for example, a. STATE = Virginia.  Is there any code to eliminate this?  I have a variable of State in the table so the footnote is overkill.  Any input will be appreciated, Thanks.

=====================
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

--
===================== 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