SPSSX Discussion

passing table title as variable label dynamically in SPSS CTABLES

Classic

List

Threaded

7 messages Options

jagadishpchary

passing table title as variable label dynamically in SPSS CTABLES

Hi,

I just wanted to know is there any way where i can pass the variable label
as ttitle dynamically in CTABLES?

Also, I would like to know how do i give the table numbering in CTABLES?

Many thanks for the reply.

Regards,
Jagadish

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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

spss.giesel@yahoo.de

Re: passing table title as variable label dynamically in SPSS CTABLES

...
  /TITLES TITLE = ')TABLE' CAPTION = ')DATE | )TIME'.


Mario Giesel
Munich, Germany

Am Montag, 25. November 2019, 08:31:37 MEZ hat jagadishpchary <[hidden email]> Folgendes geschrieben:

Hi,

I just wanted to know is there any way where i can pass the variable label

as ttitle dynamically in CTABLES?

Also, I would like to know how do i give the table numbering in CTABLES?

Many thanks for the reply.

Regards,

Jagadish

Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================

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

jagadishpchary

Re: passing table title as variable label dynamically in SPSS CTABLES

HHi Mario,

Thanks for the reply.

If i use the below synatx i am getting the Row & column label. However I
need only the row title. is that posssible in CTABLES?

Thanks,
Jagadish

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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

Re: passing table title as variable label dynamically in SPSS CTABLES

You can customize the title by wrapping the CTABLES command in a small Python program. For example (using employee data.sav).

begin program.
import spss, spssaux

vardict = spssaux.VariableDict()
label = vardict['jobcat'].VariableLabel
cmd = """CTABLES
/VLABELS VARIABLES=jobcat gender DISPLAY=DEFAULT
/TABLE jobcat [COUNT F40.0] BY gender
/CATEGORIES VARIABLES=jobcat gender ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE
/TITLES TITLE='%s'.""" % label

spss.Submit(cmd)
end program.

This gets the variable label for the jobcat variable and uses it in the TITLES subcommand.

Note that the CTABLES command is enclosed in triple quotes.

On Wed, Nov 27, 2019 at 5:59 AM jagadishpchary <[hidden email]> wrote:

HHi Mario,

Thanks for the reply.

If i use the below synatx i am getting the Row & column label. However I
need only the row title. is that posssible in CTABLES?

Thanks,
Jagadish

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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 K Peck
[hidden email]

spss.giesel@yahoo.de

Re: passing table title as variable label dynamically in SPSS CTABLES

In reply to this post by jagadishpchary

Sure. Just type the row title you wish instead of ')TABLE'.

Mario Giesel
Munich, Germany

Am Mittwoch, 27. November 2019, 13:59:19 MEZ hat jagadishpchary <[hidden email]> Folgendes geschrieben:

HHi Mario,

Thanks for the reply.

If i use the below synatx i am getting the Row & column label. However I
need only the row title. is that posssible in CTABLES?

Thanks,

Jagadish

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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

jagadishpchary

Re: passing table title as variable label dynamically in SPSS CTABLES

In reply to this post by Jon Peck

Hi Jon,

Thanks for the python code.

I need to use this code in the SPSS macros. However i am getting error -
unable to run the code ( i tried all possible ways). Could you please let me
know if the python code can be incorporated within the SPSS macros?

thanks you for letting me know.

Regards,
Jagadish

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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

spss.giesel@yahoo.de

Re: passing table title as variable label dynamically in SPSS CTABLES

see syntax reference for DEFINE .. !ENDDEFINE:

Limitations
...
- BEGIN PROGRAM-END PROGRAM commands are not supported within a macro.


Mario Giesel
Munich, Germany

Am Sonntag, 1. Dezember 2019, 20:04:39 MEZ hat jagadishpchary <[hidden email]> Folgendes geschrieben: