Crosstabulation table

[Gary Stevens-2]

This is a normal crosstab of my data. (I do have more columns of years
across the top).  Note that agegroup '10 to 17' is missing in '3 BA/BS +'

First table example-
                    YEAR
Education    2004
1 <HS degree Mage35 10 to 17 106
   18 to 24 338
   25 to 34 194
        35+ 33
  Total          671
2 HS/GED/some Mage35 10 to 17 7
   18 to 24 787
   25 to 34 1493
          35+ 451
  Total          2738
3 BA/BS + Mage35 18 to 24 69
   25 to 34 1892
        35+ 710
  Total          2671
4 unk  Mage35 10 to 17 1
   18 to 24 16
   25 to 34 17
        35+ 6
  Total          40

If I go to pivot table/pivot trays and move Mage35 up and under YEAR I get
the second table example.

Second table example-

Education YEAR
  2004
  Mage35                Total
  10 to 17   18 to 24 25 to 34    35+
1 <HS degree 106    338         194     33      671
2 HS/GED/some 7    787         1493     451     2738
3 BA/BS +     69         1892     710     2671
4 unk  1    16         17     6     40


My question is how can I get the second table example without having to go
to the pivot tray? (Four age groups under each year) I have many crosstabs
to do and simply cannot go to the pivot tray for each one.

The supreme question is, how can I get my preferred first example crosstab
to show a place holder row if all the data is empty?
For example, I want all the age groups (10 to 17, 18 to 24, .....35+) above
to appear, not just the ones with data, so that I can paste the table into a
spreadsheet and continue my work.

Many thanks,
Gary Stevens

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

[Peck, Jon]

If you have the Custom Tables option, you can control these layout issues directly, including showing empty rows.

If that is not available, you would need to write an autoscript for crosstab tables that does the pivots automatically when the tables are created.  That won't cover the empty rows issue, though.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gary Stevens
Sent: Thursday, April 02, 2009 9:49 AM
To: [hidden email]
Subject: [SPSSX-L] Crosstabulation table

This is a normal crosstab of my data. (I do have more columns of years
across the top).  Note that agegroup '10 to 17' is missing in '3 BA/BS +'

First table example-
                    YEAR
Education    2004
1 <HS degree Mage35 10 to 17 106
   18 to 24 338
   25 to 34 194
        35+ 33
  Total          671
2 HS/GED/some Mage35 10 to 17 7
   18 to 24 787
   25 to 34 1493
          35+ 451
  Total          2738
3 BA/BS + Mage35 18 to 24 69
   25 to 34 1892
        35+ 710
  Total          2671
4 unk  Mage35 10 to 17 1
   18 to 24 16
   25 to 34 17
        35+ 6
  Total          40

If I go to pivot table/pivot trays and move Mage35 up and under YEAR I get
the second table example.

Second table example-

Education YEAR
  2004
  Mage35                Total
  10 to 17   18 to 24 25 to 34    35+
1 <HS degree 106    338         194     33      671
2 HS/GED/some 7    787         1493     451     2738
3 BA/BS +     69         1892     710     2671
4 unk  1    16         17     6     40


My question is how can I get the second table example without having to go
to the pivot tray? (Four age groups under each year) I have many crosstabs
to do and simply cannot go to the pivot tray for each one.

The supreme question is, how can I get my preferred first example crosstab
to show a place holder row if all the data is empty?
For example, I want all the age groups (10 to 17, 18 to 24, .....35+) above
to appear, not just the ones with data, so that I can paste the table into a
spreadsheet and continue my work.

Many thanks,
Gary Stevens

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