SPSSX Discussion

SHRINK WIDE TABLES IN 17

Classic

List

Threaded

4 messages Options

Conlon, Dan (DSHS/HRSA)

SHRINK WIDE TABLES IN 17

I just received SPSS V17 and am trying to use a feature that worked
previously in SPSS V15. It does not seem to work in SPSS 17.

The feature is the ability to shrink wide tables to fit on a printed page
(without any wrapping). I understand SPSS considers this problem a defect
in SPSS 17. I'll paste below the resolution information from
http://support.spss.com/Tech/ to describe the issue in more detail.

I have not seen any discussion of this problem on the listserve. It is a
feature I used very frequently in previous versions - and I'm assuming
many other users have as well. So, I am wondering if others have
experienced the same problem and, more importantly, whether a workaround
was developed.

Thanks,
Dan

//////////////////////////////////////

Resolution number: 80196 Created on: Oct 17 2008 Last Reviewed on: Oct
20 2008

Problem Subject: Table properties: Rescale wide table to fit on page has
no effect in SPSS Statistics 17 for printing the table

Problem Description: I am using SPSS Statistics 17 and have created a
wide table. In order to print it in portrait format A4 I have double
clicked on the table in the viewer. Under Format - Table Properties -
Printing tab I have activated the option "Rescale wide table to fit on
page".
However, when I go to File - Print Preview I have noticed that the table
is wrapped, so it seems that the option has no effect on wide tables. Is
that true?
To replicate you can create a wide table with this syntax:

GET FILE='C:\Program Files\SPSSInc\Statistics17\Samples\English\Employee
data.sav'.
T-TEST GROUPS=gender('f' 'm')
/MISSING=ANALYSIS
/VARIABLES=salbegin
/CRITERIA=CI(.95).

Resolution Subject: This problem has been reported to SPSS Development -
No Workaround Available

Resolution Description:
This problem has been reported to SPSS Development. Currently there is no
workaround available. We apologize for any inconvenience.

//////////////////////////////////////

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

SPSS Support

Re: SHRINK WIDE TABLES IN 17

Dan,

We have not seen a workaround for this problem. It should be fixed in Release 17.0.1, due out in mid-December.

David Nichols

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Dan Conlon
Sent: Thursday, November 06, 2008 12:01 PM
To: [hidden email]
Subject: [SPSSX-L] SHRINK WIDE TABLES IN 17

I just received SPSS V17 and am trying to use a feature that worked previously in SPSS V15. It does not seem to work in SPSS 17.

The feature is the ability to shrink wide tables to fit on a printed page (without any wrapping). I understand SPSS considers this problem a defect in SPSS 17. I'll paste below the resolution information from http://support.spss.com/Tech/ to describe the issue in more detail.

I have not seen any discussion of this problem on the listserve. It is a feature I used very frequently in previous versions - and I'm assuming many other users have as well. So, I am wondering if others have experienced the same problem and, more importantly, whether a workaround was developed.

Thanks,
Dan

//////////////////////////////////////

Resolution number: 80196 Created on: Oct 17 2008 Last Reviewed on: Oct 20 2008

Problem Subject: Table properties: Rescale wide table to fit on page has no effect in SPSS Statistics 17 for printing the table

Problem Description: I am using SPSS Statistics 17 and have created a wide table. In order to print it in portrait format A4 I have double clicked on the table in the viewer. Under Format - Table Properties - Printing tab I have activated the option "Rescale wide table to fit on page".
However, when I go to File - Print Preview I have noticed that the table is wrapped, so it seems that the option has no effect on wide tables. Is that true?
To replicate you can create a wide table with this syntax:

GET FILE='C:\Program Files\SPSSInc\Statistics17\Samples\English\Employee
data.sav'.
T-TEST GROUPS=gender('f' 'm')
/MISSING=ANALYSIS
/VARIABLES=salbegin
/CRITERIA=CI(.95).

Resolution Subject: This problem has been reported to SPSS Development - No Workaround Available

Resolution Description:
This problem has been reported to SPSS Development. Currently there is no workaround available. We apologize for any inconvenience.

//////////////////////////////////////

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

Jason Burke

Re: SHRINK WIDE TABLES IN 17

In reply to this post by Conlon, Dan (DSHS/HRSA)

Hi Dan,

Have you made use of the new OUTPUT EXPORT coomand syntax. One of the
KEYWORDS allows you to specify how you would like wide tables dealt
with, when exported.

Here is an example:

GET FILE='C:\Program
Files\SPSSInc\Statistics17\Samples\English\Employee data.sav'.
T-TEST GROUPS=gender('f' 'm')
/MISSING=ANALYSIS
/VARIABLES=salbegin
/CRITERIA=CI(.95).

* Export Output.
OUTPUT EXPORT
/CONTENTS EXPORT=VISIBLE LAYERS=VISIBLE
/DOC DOCUMENTFILE='C:\Wide_Report.doc'
NOTESCAPTIONS=YES
WIDETABLES=SHRINK
PAGESIZE=MM(210.0, 297.0)
TOPMARGIN=MM(25.4)
BOTTOMMARGIN=MM(25.4)
LEFTMARGIN=MM(25.4) RIGHTMARGIN=MM(25.4) .

I found this new OUTPUT EXPORT command, with the keywords, a great
addition. Naturally, the page margins reflect settings for A4, rather
than LETTER, page size

HTH,

Jason

On Fri, Nov 7, 2008 at 5:01 AM, Dan Conlon <[hidden email]> wrote:

> I just received SPSS V17 and am trying to use a feature that worked
> previously in SPSS V15. It does not seem to work in SPSS 17.
>
> The feature is the ability to shrink wide tables to fit on a printed page
> (without any wrapping). I understand SPSS considers this problem a defect
> in SPSS 17. I'll paste below the resolution information from
> http://support.spss.com/Tech/ to describe the issue in more detail.
>
> I have not seen any discussion of this problem on the listserve. It is a
> feature I used very frequently in previous versions - and I'm assuming
> many other users have as well. So, I am wondering if others have
> experienced the same problem and, more importantly, whether a workaround
> was developed.
>
> Thanks,
> Dan
>
> //////////////////////////////////////
>
> Resolution number: 80196 Created on: Oct 17 2008 Last Reviewed on: Oct
> 20 2008
>
> Problem Subject: Table properties: Rescale wide table to fit on page has
> no effect in SPSS Statistics 17 for printing the table
>
> Problem Description: I am using SPSS Statistics 17 and have created a
> wide table. In order to print it in portrait format A4 I have double
> clicked on the table in the viewer. Under Format - Table Properties -
> Printing tab I have activated the option "Rescale wide table to fit on
> page".
> However, when I go to File - Print Preview I have noticed that the table
> is wrapped, so it seems that the option has no effect on wide tables. Is
> that true?
> To replicate you can create a wide table with this syntax:
>
> GET FILE='C:\Program Files\SPSSInc\Statistics17\Samples\English\Employee
> data.sav'.
> T-TEST GROUPS=gender('f' 'm')
> /MISSING=ANALYSIS
> /VARIABLES=salbegin
> /CRITERIA=CI(.95).
>
>
> Resolution Subject: This problem has been reported to SPSS Development -
> No Workaround Available
>
> Resolution Description:
> This problem has been reported to SPSS Development. Currently there is no
> workaround available. We apologize for any inconvenience.
>
> //////////////////////////////////////
>
> =====================
> 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

Conlon, Dan (DSHS/HRSA)

Re: SHRINK WIDE TABLES IN 17

Thanks Jason for pointing out the OUTPUT EXPORT command. That approach
works as you suggest. It looks like there are a lot of useful options
with that command (which I look forward to exploring more fully when I
get time).

However, in the majority of cases (particularly when using Custom
Tables), I find it more efficient to print the tables directly from the
Viewer window (without the need to export to Word or other
applications). In those situations, it is nice to have the Table
pre-shrunk by using a customized TableLook. As David from SPSS Support
mentioned, the defect will be corrected in Release 17.0.1. So, I'll have
to be patient until then.

Thanks,
Dan

-----Original Message-----
From: Jason Burke [mailto:[hidden email]]
Sent: Friday, November 07, 2008 4:11 PM
To: Conlon, Dan (DSHS/HRSA)
Cc: [hidden email]
Subject: Re: SHRINK WIDE TABLES IN 17

Hi Dan,

Have you made use of the new OUTPUT EXPORT coomand syntax. One of the
KEYWORDS allows you to specify how you would like wide tables dealt
with, when exported.

Here is an example:

GET FILE='C:\Program
Files\SPSSInc\Statistics17\Samples\English\Employee data.sav'.
T-TEST GROUPS=gender('f' 'm')
/MISSING=ANALYSIS
/VARIABLES=salbegin
/CRITERIA=CI(.95).

* Export Output.
OUTPUT EXPORT
/CONTENTS EXPORT=VISIBLE LAYERS=VISIBLE
/DOC DOCUMENTFILE='C:\Wide_Report.doc'
NOTESCAPTIONS=YES
WIDETABLES=SHRINK
PAGESIZE=MM(210.0, 297.0)
TOPMARGIN=MM(25.4)
BOTTOMMARGIN=MM(25.4)
LEFTMARGIN=MM(25.4) RIGHTMARGIN=MM(25.4) .

I found this new OUTPUT EXPORT command, with the keywords, a great
addition. Naturally, the page margins reflect settings for A4, rather
than LETTER, page size

HTH,

Jason

On Fri, Nov 7, 2008 at 5:01 AM, Dan Conlon <[hidden email]> wrote:
> I just received SPSS V17 and am trying to use a feature that worked
> previously in SPSS V15. It does not seem to work in SPSS 17.
>
> The feature is the ability to shrink wide tables to fit on a printed
page
> (without any wrapping). I understand SPSS considers this problem a
defect
> in SPSS 17. I'll paste below the resolution information from
> http://support.spss.com/Tech/ to describe the issue in more detail.
>
> I have not seen any discussion of this problem on the listserve. It is
a
> feature I used very frequently in previous versions - and I'm
assuming
> many other users have as well. So, I am wondering if others have
> experienced the same problem and, more importantly, whether a
workaround
> was developed.
>
> Thanks,
> Dan
>
> //////////////////////////////////////
>
> Resolution number: 80196 Created on: Oct 17 2008 Last Reviewed on:
Oct
> 20 2008
>
> Problem Subject: Table properties: Rescale wide table to fit on page
has
> no effect in SPSS Statistics 17 for printing the table
>
> Problem Description: I am using SPSS Statistics 17 and have created a
> wide table. In order to print it in portrait format A4 I have double
> clicked on the table in the viewer. Under Format - Table Properties -
> Printing tab I have activated the option "Rescale wide table to fit on
> page".
> However, when I go to File - Print Preview I have noticed that the
table
> is wrapped, so it seems that the option has no effect on wide tables.
Is
> that true?
> To replicate you can create a wide table with this syntax:
>
> GET FILE='C:\Program
Files\SPSSInc\Statistics17\Samples\English\Employee
> data.sav'.
> T-TEST GROUPS=gender('f' 'm')
> /MISSING=ANALYSIS
> /VARIABLES=salbegin
> /CRITERIA=CI(.95).
>
>
> Resolution Subject: This problem has been reported to SPSS Development
-
> No Workaround Available
>
> Resolution Description:
> This problem has been reported to SPSS Development. Currently there is
no
> workaround available. We apologize for any inconvenience.
>
> //////////////////////////////////////
>
> =====================
> 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