From: Jason Burke To: 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 >