passing table title as variable label dynamically in SPSS CTABLES

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

passing table title as variable label dynamically in SPSS CTABLES

jagadishpchary
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
Reply | Threaded
Open this post in threaded view
|

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

Mario Giesel-2
...
  /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



--

=====================
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
Reply | Threaded
Open this post in threaded view
|

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

jagadishpchary
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
Reply | Threaded
Open this post in threaded view
|

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

Jon Peck
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]

===================== 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
Reply | Threaded
Open this post in threaded view
|

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

Mario Giesel-2
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
===================== 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
Reply | Threaded
Open this post in threaded view
|

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

jagadishpchary
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
Reply | Threaded
Open this post in threaded view
|

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

Mario Giesel-2
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:


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