Summarize Table -- Format List

[Eric Black]

I just upgraded to v21.  For checking data, I oftentimes use the summarize
table command with "/format list" so I can see where I have issues for
certain computations.

I now noticed that v21 displays a sysmis as 0 in the table.

I.e. if you do
compute v_sysmis = $sysmis.
summarize table
v_sysmis
/format list.

I get 0 where I actually want to see a period only.

Does anybody know what switch to use?  I didn't see anything in the manual,
but I might have missed the obvious.

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

I don't see SYSMIS displayed as 0 in V21.  The case listing still shows a period.  Of course, sysmis does not apply to strings.


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




From:        Matt Kretschmer <[hidden email]>
To:        [hidden email],
Date:        10/30/2012 01:12 PM
Subject:        [SPSSX-L] Summarize Table -- Format List
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I just upgraded to v21.  For checking data, I oftentimes use the summarize
table command with "/format list" so I can see where I have issues for
certain computations.

I now noticed that v21 displays a sysmis as 0 in the table.

I.e. if you do
compute v_sysmis = $sysmis.
summarize table
v_sysmis
/format list.

I get 0 where I actually want to see a period only.

Does anybody know what switch to use?  I didn't see anything in the manual,
but I might have missed the obvious.

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

[ViAnn Beadle]

This appears to be a “feature” of SUMMARIZE. By default, it displays 0 for sysmis but you can specify any symbol you want using the MISSING  keyword on the SUMMARIZE command.

 

The old LIST command shows the sysmis dot and the data editor shows the sysmis dot.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jon K Peck
Sent: Tuesday, October 30, 2012 3:04 PM
To: [hidden email]
Subject: Re: Summarize Table -- Format List

 

I don't see SYSMIS displayed as 0 in V21.  The case listing still shows a period.  Of course, sysmis does not apply to strings.


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




From:        Matt Kretschmer <[hidden email]>
To:        [hidden email],
Date:        10/30/2012 01:12 PM
Subject:        [SPSSX-L] Summarize Table -- Format List
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I just upgraded to v21.  For checking data, I oftentimes use the summarize
table command with "/format list" so I can see where I have issues for
certain computations.

I now noticed that v21 displays a sysmis as 0 in the table.

I.e. if you do
compute v_sysmis = $sysmis.
summarize table
v_sysmis
/format list.

I get 0 where I actually want to see a period only.

Does anybody know what switch to use?  I didn't see anything in the manual,
but I might have missed the obvious.

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

[Eric Black]

Thanks ViAnn - what exactly do I have to write there?  The manual offers this:

[/MISSING=[{EXCLUDE**}][{VARIABLE** }]
{INCLUDE } {TABLE }
{DEPENDENT}

Those do not offer anything on having a customized symbol

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

[ViAnn Beadle]

I'm using v. 21 and the looked at the online help. This might be a recent
addition to SUMMARIZE.

The MISSING keyword is used to specify a string on the FORMAT subcommand.

It is kinda confusing to have MISSING used both as a subcommand name AND a
keyword.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Matt Kretschmer
Sent: Wednesday, October 31, 2012 8:54 AM
To: [hidden email]
Subject: Re: Summarize Table -- Format List

Thanks ViAnn - what exactly do I have to write there?  The manual offers
this:

[/MISSING=[{EXCLUDE**}][{VARIABLE** }]
{INCLUDE } {TABLE }
{DEPENDENT}

Those do not offer anything on having a customized symbol

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

[Eric Black]

Got it  ViAnn - thanks so much

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