Formatting Crosstabs table in SPSS 18

[Warren Chrusciel]

In SPSS 18 the column and row headers in a crosstabs table that I am
working with are currently formatted with 2 digits after the decimal
point.   I am trying to increase the number of digits in the headers and
save it to format tables that I generate in the future.  I tried to use
the TableLooks feature but the headers of new tables still had 2 digits. I
used the SET TLook command with the .stt file that I had created using a
table that had 6 digits after the decimal point in the header and then ran
a new crosstabs procedure in syntax.

Is there any way to format (and then save) the crosstabs headers (number
of digits displayed) in SPSS 18?  Should I be using the TableLooks feature
or is there a better way to do this?

Thank you,

Warren Chrusciel
Municipal Property Assessment Corporation
1420 Blair Place, Suite 300
Ottawa, Ontario K1J 9L8
Canada

=====================
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 number of decimals in the header is based on the number of decimals in the variable definition, so if you change the variable from, say F8.2 to F8.3, you will get one more decimal in the column labels.

However, since most decimal fractions don't have an exact floating point representation and results will be rounded to the specified format, you could get multiple columns with the same rounded value.  If this happens,  you might want to round or truncate the variables with fractional values before running the crosstab or even bin the values.

HTH,


Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435

From:	Warren Chrusciel <[hidden email]>
To:	[hidden email]
Date:	09/02/2010 09:05 AM
Subject:	[SPSSX-L] Formatting Crosstabs table in SPSS 18
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

In SPSS 18 the column and row headers in a crosstabs table that I am
working with are currently formatted with 2 digits after the decimal
point.   I am trying to increase the number of digits in the headers and
save it to format tables that I generate in the future.  I tried to use
the TableLooks feature but the headers of new tables still had 2 digits. I
used the SET TLook command with the .stt file that I had created using a
table that had 6 digits after the decimal point in the header and then ran
a new crosstabs procedure in syntax.

Is there any way to format (and then save) the crosstabs headers (number
of digits displayed) in SPSS 18?  Should I be using the TableLooks feature
or is there a better way to do this?

Thank you,

Warren Chrusciel
Municipal Property Assessment Corporation
1420 Blair Place, Suite 300
Ottawa, Ontario K1J 9L8
Canada

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

[Warren Chrusciel]

That's exactly what I needed to do.

Thank you,

Warren Chrusciel

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