SPSS CUSTOM TABLES - HOW TO 'REPEAT HEADER ROW'

[researcher]

I have set up some custom tables: in the rows a very large number of variables (like 1000) and in the columns the breaks which I want across all those row variables. How can I get SPSS to reinsert the column heading (i.e the breaks) at the top of each  analysis As (crudely ) shown below. All help appreciated


                 break1     break 2 break 3

VAR A

                  break1     break 2 break 3

VARB

                break1     break 2 break 3

VAR C      

[Jon Peck]

If you are printing paginated tables, the header information is automatically repeated at the top of each page.  It sounds, though, like what you want here is to repeat that information above each variable.  If that is right, using multiple TABLE subcommands would do that.  The gui only generates one TABLE subcommand, but in syntax  you can have many, and they can share the CTABLES global subcommands.  That could be set up for a large number of variable using Python programmability or even macro.

On Thu, Jan 21, 2016 at 2:40 PM, researcher <[hidden email]> wrote:

I have set up some custom tables: in the rows a very large number of variables (like 1000) and in the columns the breaks which I want across all those row variables. How can I get SPSS to reinsert the column heading (i.e the breaks) at the top of each analysis As (crudely ) shown below. All help appreciated break1 break 2 break 3 VAR A break1 break 2 break 3 VARB break1 break 2 break 3 VAR C

---

View this message in context: SPSS CUSTOM TABLES - HOW TO 'REPEAT HEADER ROW'
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

--

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

[researcher]

Hi Jon

Thanks for that reply.  

The format ultimately will be exporting the custom tables to excel for the client.

I don't have python or any knowledge of it so I need to do this entirely within SPSS syntax.

It is helpful to know that it could be done with MACROS but I need a bit more help than that as I don't normally use macros so not really sure where to start.

If it is possible to provide  a bit more breakdown on that would be much appreciated

Thanks

Mike

[Jon Peck]

If you want to send me the details of what you want to do and a sample of the input data, I'll see if I can put together an example.  It might use Python, but you won't  need to know Python in order to use it.

On Fri, Jan 22, 2016 at 6:38 AM, researcher <[hidden email]> wrote:

Hi Jon

Thanks for that reply.

The format ultimately will be exporting the custom tables to excel for the
client.

I don't have python or any knowledge of it so I need to do this entirely
within SPSS syntax.

It is helpful to know that it could be done with MACROS but I need a bit
more help than that as I don't normally use macros so not really sure where
to start.

If it is possible to provide  a bit more breakdown on that would be much
appreciated

Thanks

Mike



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-CUSTOM-TABLES-HOW-TO-REPEAT-HEADER-ROW-tp5731371p5731378.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

--

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

[David Marso]

Look up DEFINE !ENDDEFINE in the syntax reference.
Within that see !DO !DOEND

DEFINE Blah ( !POS !CMDEND)
!DO !V !IN (!1)
FREQUENCIES !V.
!DOEND
!ENDDEFINE.

Apply that to your tables command and your set.

[Art Kendall]

It may be the SPLIT FILES would be a help.

1000 variables?!?!

If you give more detail about the whole project there may be other approaches.

What is the meaning of your variables?

Is some individual going to deal with 1000 yariable Excel table?
Is the info in an excel table mutually exclusive to the info in any other Excel table?

So far it is appears that
SPLIT FILES
MACROs
ad hoc PYTHON
PYTHON EXTENSIONS
VARTOCASES

are possibilities.

[researcher]

Thanks very much for the reply David - i will look into that - sounds promising.

Art - the data in question is from a survey -some of the multiple choice questions in that survey have 200+ response options (not all were offered to each respondent naturally). But I didn't see that that was relevant to the query. The point is to get tables which show header row at the top of each crosstab (which I will then export to Excel).

Also I don't have Python, as mentioned.

Thanks for the replies - I have some things to explore there.

Mike

[Jon Peck]

You might want to look into the CODEBOOK command.  The relevant tables could be exported with OMS.

On Saturday, January 23, 2016, researcher <[hidden email]> wrote:

Thanks very much for the reply David - i will look into that - sounds
promising.

Art - the data in question is from a survey -some of the multiple choice
questions in that survey have 200+ response options (not all were offered to
each respondent naturally). But I didn't see that that was relevant to the
query. The point is to get tables which show header row at the top of each
crosstab (which I will then export to Excel).

Also I don't have Python, as mentioned.

Thanks for the replies - I have some things to explore there.

Mike







--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-CUSTOM-TABLES-HOW-TO-REPEAT-HEADER-ROW-tp5731371p5731387.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;[e-mail]&#39;)">LISTSERV@... (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