Need help, Category position in Complex tables

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

Need help, Category position in Complex tables

Daniel-2
Hello All,

This site looks like a very good resource, i have been doing some hunting
around with no luck yet.

Basically im trying to produce a table that will look like this:[IMG]
http://i493.photobucket.com/albums/rr292/trdmrk8/tryingtoacheive.jpg[/IMG]

Where it has the questions (Variables) down the left, Values alot the top
but values shown by either of the roles, rather than a total.

I can get it to look like this, [IMG]
http://i493.photobucket.com/albums/rr292/trdmrk8/2-8.jpg[/IMG] but i need
the labels circled in red to be the column headings rather than in a row.

If anyone can help me, i would very much appreciate it!!!!

Thanks in advance

=====================
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: Need help, Category position in Complex tables

David Marso
Administrator
You *DIDN'T* post your syntax so I'm not going to bother to ESP it.
Post it and maybe someone will help you tweak it.
OTOH:  Look at the examples in the manual under these subcommands also the TABLE subcommand which controls half the enchilada.
----
The CLABELS subcommand controls the location of category labels.
/CLABELS {AUTO }
{ROWLABELS= {OPPOSITE} }
{LAYER }
{COLLABELS= {OPPOSITE} }
{LAYER }
By default, category labels are nested under the variables to which they belong. Category labels for row and column variables can be moved to the opposite dimension or to the layers. If labels exist in both dimensions, only one dimension, row labels or column labels, can be moved; they cannot be swapped.

The SLABELS Subcommand
The SLABELS subcommand controls the position of summary statistics in the table and whether summary labels are shown.
/SLABELS POSITION= {COLUMN} VISIBLE= {YES}
{ROW } {NO }
{LAYER }
By default, summaries appear in the columns and labels are visible.


 
Daniel-2 wrote
Hello All,

This site looks like a very good resource, i have been doing some hunting
around with no luck yet.

Basically im trying to produce a table that will look like this:[IMG]
http://i493.photobucket.com/albums/rr292/trdmrk8/tryingtoacheive.jpg[/IMG]

Where it has the questions (Variables) down the left, Values alot the top
but values shown by either of the roles, rather than a total.

I can get it to look like this, [IMG]
http://i493.photobucket.com/albums/rr292/trdmrk8/2-8.jpg[/IMG] but i need
the labels circled in red to be the column headings rather than in a row.

If anyone can help me, i would very much appreciate it!!!!

Thanks in advance

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