SPSSX Discussion

2nd try: why was default missing code in Report/Case Summaries changed to 0 for numeric variables in SPSS21!!!!

Classic

List

Threaded

4 messages Options

Paulette Johnson

2nd try: why was default missing code in Report/Case Summaries changed to 0 for numeric variables in SPSS21!!!!

When my students point and click --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Processing Summary^a *
Cases
Included Excluded Total
N Percent N Percent N Percent
id 4 100.0% 0 0.0% 4 100.0%
item1 4 100.0% 0 0.0% 4 100.0%
item2 2 50.0% 2 50.0% 4 100.0%
item3 3 75.0% 1 25.0% 4 100.0%
a. Limited to first 100 cases.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 .00 5.00
3 3 3.00 1.00 3.00
4 4 3.00 .00 .00
Total N 4 4 2 3

Yes, it SAYS there are missing in Case Processing Summary, but they
don't look at that! They think all the data is there since there are
ZEROES in the table.

So they must use syntax (most don't know how to use) in order to see the
default in SPSS 20 and earlier --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM MISSING='.' TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 . 5.00
3 3 3.00 1.00 3.00
4 4 3.00 . .
Total N 4 4 2 3

Paulette Johnson, PhD
Statistical Consulting, DM 409D
Florida International University
Miami, FL 33199
305 348 2261
www.fiu.edu/~statcon

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

Bruce Weaver

Re: 2nd try: why was default missing code in Report/Case Summaries changed to 0 for numeric variables in SPSS21!!!!

Administrator

I'm not sure I understand the problem. Judging by your output, and from the small example I concocted, I would guess that your item1 to item3 variables have 0 as a user-defined missing value. That's why your Total Ns are 4, 2 and 3.

data list list / id item1 item2 item3 (4f2.0).
begin data
1 5.00 3.00 4.00
2 3.00 .00 5.00
3 3.00 1.00 3.00
4 3.00 .00 .00
end data.

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT MEAN STDDEV.

missing values item1 to item3 (0).
SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT MEAN STDDEV.

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100 MISSING="."
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT MEAN STDDEV.

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100 MISSING="Missing"
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT MEAN STDDEV.

Paulette Johnson wrote

When my students point and click --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Processing Summary^a *
Cases
Included Excluded Total
N Percent N Percent N Percent
id 4 100.0% 0 0.0% 4 100.0%
item1 4 100.0% 0 0.0% 4 100.0%
item2 2 50.0% 2 50.0% 4 100.0%
item3 3 75.0% 1 25.0% 4 100.0%
a. Limited to first 100 cases.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 .00 5.00
3 3 3.00 1.00 3.00
4 4 3.00 .00 .00
Total N 4 4 2 3

Yes, it SAYS there are missing in Case Processing Summary, but they
don't look at that! They think all the data is there since there are
ZEROES in the table.

So they must use syntax (most don't know how to use) in order to see the
default in SPSS 20 and earlier --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM MISSING='.' TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 . 5.00
3 3 3.00 1.00 3.00
4 4 3.00 . .
Total N 4 4 2 3

Paulette Johnson, PhD
Statistical Consulting, DM 409D
Florida International University
Miami, FL 33199
305 348 2261
www.fiu.edu/~statcon

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

--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).

mrose@benrose.org

Re: 2nd try: why was default missing code in Report/Case Summaries changed to 0 for numeric variables in SPSS21!!!!

In reply to this post by Paulette Johnson

CONTENTS DELETED

The author has deleted this message.

David Marso

Re: 2nd try: why was default missing code in Report/Case Summaries changed to 0 for numeric variables in SPSS21!!!!

Administrator

In reply to this post by Paulette Johnson

"Yes, it SAYS there are missing in Case Processing Summary, but they don't look at that!"
So, If I ignore crucial information (ie there is a red light in front of me) it is OK to keep driving?

"They think all the data is there since there are ZEROES in the table."
I think the moon is made of blue cheese and that there are goblins in my closet.
Sound like they are off to a good start in landing a job in marketing research.

"So they must use syntax (most don't know how to use) in order to see the default in SPSS 20 and earlier'
I am not sure where you arrive at 'default in 20 and earlier'... My ancient 11.5 pastes:
SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT .

However there is a little textbox under options:
Missing statistics appear as: [ ]
You can add whatever text you wish:

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM MISSING='oops' TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT .

--

Paulette Johnson wrote

When my students point and click --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Processing Summary^a *
Cases
Included Excluded Total
N Percent N Percent N Percent
id 4 100.0% 0 0.0% 4 100.0%
item1 4 100.0% 0 0.0% 4 100.0%
item2 2 50.0% 2 50.0% 4 100.0%
item3 3 75.0% 1 25.0% 4 100.0%
a. Limited to first 100 cases.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 .00 5.00
3 3 3.00 1.00 3.00
4 4 3.00 .00 .00
Total N 4 4 2 3

Yes, it SAYS there are missing in Case Processing Summary, but they
don't look at that! They think all the data is there since there are
ZEROES in the table.

So they must use syntax (most don't know how to use) in order to see the
default in SPSS 20 and earlier --

SUMMARIZE
/TABLES=id item1 item2 item3
/FORMAT=VALIDLIST NOCASENUM MISSING='.' TOTAL LIMIT=100
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT.

*Case Summaries^a *
id item1 item2 item3
1 1 5.00 3.00 4.00
2 2 3.00 . 5.00
3 3 3.00 1.00 3.00
4 4 3.00 . .
Total N 4 4 2 3

Paulette Johnson, PhD
Statistical Consulting, DM 409D
Florida International University
Miami, FL 33199
305 348 2261
www.fiu.edu/~statcon

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

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"