Re: does the COUNT command count missing values ?

[Germano Rossi]

2015-01-20 15:35 GMT+01:00 Ben Pfaff <address@hidden>:

It does sound like a bug.  The bug might be in the code (because it does
not do what the documentation says), or it might be in the documentation
(if PSPP does the same thing as SPSS, but the documentation is wrong).

Can anyone verify SPSS's behavior here?

Hi, here the same sequence in SPSS and in PSPP. There are 2 differences in result.

* SPSS 22.
* N=170.
COUNT norm1=SW1 TO SW5 (7).
FREQUENCIES VARIABLES=norm1   /ORDER=ANALYSIS.
* value 0 cases 134; values <> 0 cases 36.
MISSING VALUES SW1 TO SW5 (7).
COUNT mis1=SW1 TO SW5 (7).
FREQUENCIES VARIABLES=mis1   /ORDER=ANALYSIS.
* value 0 cases 134; values <> 0 cases 36.
COMPUTE mis2=NMISS(SW1 TO SW5).
FREQUENCIES VARIABLES=mis2   /ORDER=ANALYSIS.
* value 0 cases 123; values <> 0 cases 47.
RECODE SW1 TO SW5 (7=-7).
COUNT mis3=SW1 TO SW5 (7).
FREQUENCIES VARIABLES=mis3  /ORDER=ANALYSIS.
* value 0 cases 170; values <> 0 cases 0.
MISSING VALUES SW1 TO SW5 (-7).
COUNT mis4=SW1 TO SW5 (-7).
FREQUENCIES VARIABLES=mis4 /ORDER=ANALYSIS.
* value 0 cases 134; values <> 0 cases 36.
==============================================
* psppire.exe 0.8.4-g0011a5.
* N=170.
COUNT norm1=SW1 TO SW5 (7).
FREQUENCIES /VARIABLES= norm1 /FORMAT=AVALUE TABLE /STATISTICS=NONE.
* value 0 cases 134; values <> 0 cases 36.
MISSING VALUES SW1 TO SW5 (7).
COUNT mis1=SW1 TO SW5 (7).
FREQUENCIES /VARIABLES=mis1   /FORMAT=AVALUE TABLE /STATISTICS=NONE.
* value 0 cases 170; values <> 0 cases 0.   ******** DIFFERENT
COMPUTE mis2=NMISS(SW1 TO SW5).
FREQUENCIES VARIABLES=mis2 /FORMAT=AVALUE TABLE /STATISTICS=NONE.
* value 0 cases 123; values <> 0 cases 47.
RECODE SW1 TO SW5 (7=-7).
COUNT mis3=SW1 TO SW5 (7).
FREQUENCIES /VARIABLES=mis3 /FORMAT=AVALUE TABLE /STATISTICS=NONE.
* value 0 cases 170; values <> 0 cases 0.
MISSING VALUES SW1 TO SW5 (-7).
COUNT mis4=SW1 TO SW5 (-7).
FREQUENCIES /VARIABLES=mis4 /FORMAT=AVALUE TABLE /STATISTICS=NONE.
* value 0 cases 170; values <> 0 cases 0.  **** DIFFERENT



--

==================
Germano Rossi, Dipartimento di Psicologia, Universita' degli Studi di Milano Bicocca
Piazza dell'Ateneo Nuovo, 1- 20126 Milano - Italy