1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
From: Jason Burke <jasonmb@NSW.BIGPOND.NET.AU>
To: <SPSSX-L@LISTSERV.UGA.EDU>
Subject: Re: Table formatting - SPSS 10.0
Date: Saturday, October 23, 1999 6:58 AM

James,

This script allows you to set the widths of each column in your table
uniquely, and also the width of the row labels. The best way to see this
work is to create a table (any SPSS pivot output), then change the widths of
each of the columns, and the labels in the rows. When you are satisfied, run
the script.

The script will then create syntax that will not only create the same
output, but also mirror the row labels & column widths. Here is an example,
with some comments that I added:

* Create a crosstab.

CROSSTABS
  /TABLES=jobcat  BY gender
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT ROW COLUMN TOTAL .

* Now set the width of the row label to 105 points, the first & second
columns to 45 points,
*  and the Total column to 50 points.

SCRIPT file = 'C:\\PROGRAM FILES\\SPSS\\SCRIPTS\\TableWidths-withSyntax.sbs'('105|45,45,50').

The only assumption is that the script is saved to the SCRIPTS subdirectory
of SPSS. A nice feature is that you can hide any redundant columns by
substituting a 0.

Best wishes,


/Jason.


> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
> James Whiley
> Sent: Wednesday, 20 October 1999 6:14
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Table formatting - SPSS 10.0
>
>
> Dear colleagues,
>
> I have recently upgraded to SPSS 10.0 from SPSS 6.1. I routinely produce
> summary tables in production using syntax, and have been doing so for many
> years now.
>
> Although my syntax continues to work, I have been required to remove the
> format commands from my syntax. Although the tables in SPSS 10.0 provide a
> more, let me say, modern look - I must add days to my schedule until the
> tables are ready to print.
>
> Is there a way to force each table adopt uniques widths for labels in the
> columns and rows? Is there new command syntax that I should be familiar
> with? I must admit, I have taken to the Table Looks with some
> success - but
> surely there must be someway to govern layout.
>
> My colleague, a more studious adopter of technology suggested VBA, but my
> experience in this field is very small.
>
> Any suggestion would be welcome, and certainly appreciated.
>
> Kind regards,
>
>
> James Wiley.
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>