Customize custom table's title based on a variable value

[Ketty Noonan-2]

Hi everyone,

I am running several custom tables, one for each category.

Is there a way to reflect the category's description in the custom table's title?

For example:

temp.
select if category=1.
CTABLES
  /VLABELS VARIABLES=region Total_prod DISPLAY=BOTH
  /TABLE region BY Total_prod [MEAN, COUNT F40.0]
 /TITLE TITLE 'Name of category'.

I don't think it is a good idea to type the name of the category itself because I will run the syntax for multiple categories (hence using SPSS macro).
I will also run the syntax for different variables (for example: region or income).

I have tried using valuelabels(category) but it didn't work.

Thanks in advance!

Ketty

+========================================================================+
This email is confidential and may be privileged. If you have received it
in error, please notify us immediately and then delete it.  Please do not
copy it, disclose its contents or use it for any purpose.
+========================================================================+


	
	
	
	

[David Marso]

Ketty!
Start a NEW thread rather than hijacking an OLD one!
Your question is not terribly clear anyway.
What have you actually tried that didn't work.
Do not reply here, rather do it on the NEW thread you will open.
Others? Do not reply to this hijacked thread.
--------

Ketty Noonan-2 wrote

> Hi everyone,
>
> I am running several custom tables, one for each category.
>
> Is there a way to reflect the category's description in the custom table's
> title?
>
> For example:
>
> temp.
> select if category=1.
> CTABLES
>   /VLABELS VARIABLES=region Total_prod DISPLAY=BOTH
>   /TABLE region BY Total_prod [MEAN, COUNT F40.0]
>  /TITLE TITLE 'Name of category'.
>
> I don't think it is a good idea to type the name of the category itself
> because I will run the syntax for multiple categories (hence using SPSS
> macro).
> I will also run the syntax for different variables (for example: region or
> income).
>
> I have tried using valuelabels(category) but it didn't work.
>
> Thanks in advance!
>
> Ketty
>
>
> +========================================================================+
> This email is confidential and may be privileged. If you have received it
> in error, please notify us immediately and then delete it.  Please do not
> copy it, disclose its contents or use it for any purpose.
> +========================================================================+

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Customize-custom-table-s-title-based-on-a-variable-value-tp5721838p5721840.html
Sent from the SPSSX Discussion mailing list archive at 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

[Bruce Weaver]

Ketty's post has already been "moved" to its own thread (in the Nabble archive -- and I don't think it's an issue for the UGA archive), so there will be no problem (in this case) with replying to David's message.  But his point about starting a new thread when one has a new topic is well-taken!  ;-)

HTH.

David Marso wrote

Ketty!
Start a NEW thread rather than hijacking an OLD one!
Your question is not terribly clear anyway.
What have you actually tried that didn't work.
Do not reply here, rather do it on the NEW thread you will open.
Others? Do not reply to this hijacked thread.
--------

Ketty Noonan-2 wrote
> Hi everyone,
>
> I am running several custom tables, one for each category.
>
> Is there a way to reflect the category's description in the custom table's
> title?
>
> For example:
>
> temp.
> select if category=1.
> CTABLES
>   /VLABELS VARIABLES=region Total_prod DISPLAY=BOTH
>   /TABLE region BY Total_prod [MEAN, COUNT F40.0]
>  /TITLE TITLE 'Name of category'.
>
> I don't think it is a good idea to type the name of the category itself
> because I will run the syntax for multiple categories (hence using SPSS
> macro).
> I will also run the syntax for different variables (for example: region or
> income).
>
> I have tried using valuelabels(category) but it didn't work.
>
> Thanks in advance!
>
> Ketty
>
>
> +========================================================================+
> This email is confidential and may be privileged. If you have received it
> in error, please notify us immediately and then delete it.  Please do not
> copy it, disclose its contents or use it for any purpose.
> +========================================================================+





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Customize-custom-table-s-title-based-on-a-variable-value-tp5721838p5721840.html
Sent from the SPSSX Discussion mailing list archive at 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]

The simplest solution might be to put your categorical variable in the layer.  You can then export the layers as separate tables.  CTABLES does not support split files, which would be another obvious solution, because it has the layering capability.

If that isn't appropriate, a small amount of Python code could generate table titles based on category labels - and automatically generate a table for each category value.  You would need to install the Python Essentials to use this approach.  You can't just reference the VALUELABEL function in the CTABLES TITLE subcommand.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Ketty Noonan <[hidden email]>
To:        [hidden email],
Date:        09/05/2013 07:51 AM
Subject:        [SPSSX-L] Customize custom table's title based on a variable value
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi everyone,

I am running several custom tables, one for each category.

Is there a way to reflect the category's description in the custom table's title?

For example:

temp.
select if category=1.
CTABLES
 /VLABELS VARIABLES=region Total_prod DISPLAY=BOTH
 /TABLE region BY Total_prod [MEAN, COUNT F40.0]
/TITLE TITLE 'Name of category'.

I don't think it is a good idea to type the name of the category itself because I will run the syntax for multiple categories (hence using SPSS macro).
I will also run the syntax for different variables (for example: region or income).

I have tried using valuelabels(category) but it didn't work.

Thanks in advance!

Ketty

+========================================================================+
This email is confidential and may be privileged. If you have received it
in error, please notify us immediately and then delete it.  Please do not
copy it, disclose its contents or use it for any purpose.
+========================================================================+