display long string variables

[Moon Kid]

Is there a way to display long strings (A2048)?

LIST just cut the lines in the output window.

CTABLES & Co. wrap a line in a to small column.

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

[Maguin, Eugene]

2048 means 26 80 character lines. Could this be a default length that can be shortened via Alter type?  If not and if the records for this variable have text data that is to be read (several paragraphs worth I would guess), then when faced with this situation I have written the variable to a text file that was then opened in word to access formatting controls.
Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Moon Kid
Sent: Thursday, April 24, 2014 12:32 PM
To: [hidden email]
Subject: display long string variables

Is there a way to display long strings (A2048)?

LIST just cut the lines in the output window.

CTABLES & Co. wrap a line in a to small column.

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

[Jon K Peck]

As Gene said, very long text lines will be quite hard to read in any of the normal Statistics output formats if these variables are really full.  You can, however, come close by using the case listing feature of the SUMMARIZE procedure (Analyze > Reports > Case Summaries) to display the wrapped text in pivot table cells that can be quite wide.  You might need to fiddle with the cell widths to suit your purpose.  Interactive you can do that in the pivot table editor, and there are ways to do it programmatically as well.




Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        04/24/2014 10:33 AM
Subject:        [SPSSX-L] display long string variables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Is there a way to display long strings (A2048)?

LIST just cut the lines in the output window.

CTABLES & Co. wrap a line in a to small column.

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

[David Marso]

OTOH:
MATRIX.
SAVE {1}/OUTFILE *.
END MATRIX.

STRING A (A255).
COMPUTE a='saanbanbnanmnmmasnmnmamnsmnxnmnasbmmsamnmadmasmdnasmdnmananmnnmasndandm,nadn'+
                    'anasmdnandmandanmanmanmdnadnas,mdnmndm,asndanmasnnamdnadnmadnandm,and,an,dn,mdasm'+
                    'nmamnasdadnmandmandmanmsndnamnanmasn'.

CTABLES  /FORMAT MINCOLWIDTH=800 /TABLE BY a .

Jon K Peck wrote

As Gene said, very long text lines will be quite hard to read in any of
the normal Statistics output formats if these variables are really full.
You can, however, come close by using the case listing feature of the
SUMMARIZE procedure (Analyze > Reports > Case Summaries) to display the
wrapped text in pivot table cells that can be quite wide.  You might need
to fiddle with the cell widths to suit your purpose.  Interactive you can
do that in the pivot table editor, and there are ways to do it
programmatically as well.




Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:   Moon Kid <[hidden email]>
To:     [hidden email],
Date:   04/24/2014 10:33 AM
Subject:        [SPSSX-L] display long string variables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Is there a way to display long strings (A2048)?

LIST just cut the lines in the output window.

CTABLES & Co. wrap a line in a to small column.

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

[Moon Kid]

On 2014-04-24 12:08 David Marso <[hidden email]> wrote:
> *CTABLES  /FORMAT MINCOLWIDTH=800 /TABLE BY a .*

This is nice but has one problem.

The values are displayed in side by side. Of course I need them
displayed in a vertical order.
But removing the BY from your command remove the effect of MINCOLWIDTH,
too.

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

[Moon Kid]

On 2014-04-24 12:09 Jon K Peck <[hidden email]> wrote:
> As Gene said, very long text lines will be quite hard to read in any
> of the normal Statistics output formats if these variables are really
> full.

But there is no technical reason for that. It is just a "bug" in SPSS.

> You can, however, come close by using the case listing feature
> of the SUMMARIZE procedure (Analyze > Reports > Case Summaries)

This is nice. But...

> You might need to fiddle with the cell widths to suit your
> purpose.  Interactive you can do that in the pivot table editor, and
> there are ways to do it programmatically as well.

How can I do this programmatically. Maybe I missunderstand the
following command or there is another solution?

SUMMARIZE
  /TABLES=v51s
  /FORMAT=VALIDLIST NOCASENUM TOTAL
  /MISSING=VARIABLE
  /CELLS=COUNT.

SPSSINC MODIFY TABLES
   SUBTYPE = ’Summarize’
   DIMENSION = COLUMNS
   SELECT = 1
   /WIDTHS WIDTHS = 350.

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

See two comments below.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        04/25/2014 12:51 PM
Subject:        Re: [SPSSX-L] display long string variables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

On 2014-04-24 12:09 Jon K Peck <[hidden email]> wrote:
> As Gene said, very long text lines will be quite hard to read in any
> of the normal Statistics output formats if these variables are really
> full.

But there is no technical reason for that. It is just a "bug" in SPSS.
>>>No, it's not a bug.  Statistics is not designed to display data like that.

> You can, however, come close by using the case listing feature
> of the SUMMARIZE procedure (Analyze > Reports > Case Summaries)

This is nice. But...

> You might need to fiddle with the cell widths to suit your
> purpose.  Interactive you can do that in the pivot table editor, and
> there are ways to do it programmatically as well.

How can I do this programmatically. Maybe I misunderstand the
following command or there is another solution?

SUMMARIZE
 /TABLES=v51s
 /FORMAT=VALIDLIST NOCASENUM TOTAL
 /MISSING=VARIABLE
 /CELLS=COUNT.

SPSSINC MODIFY TABLES
  SUBTYPE = ’Summarize’
  DIMENSION = COLUMNS
  SELECT = 1
  /WIDTHS WIDTHS = 350.


>>>There are some errors in your MODIFY TABLES command.  Try this
SPSSINC MODIFY TABLES subtype="report"
SELECT=0
DIMENSION= COLUMNS
/WIDTHS WIDTHS=350
/STYLES  APPLYTO=DATACELLS.