PSPP-BUG: [bug #44157] COUNT vs. missing values

[John Darrington]

URL:
  <http://savannah.gnu.org/bugs/?44157>

                 Summary: COUNT vs. missing values
                 Project: PSPP
            Submitted by: jmd
            Submitted on: Mon 02 Feb 2015 07:42:39 AM CET
                Category: Syntax Parser
                Severity: 5 - Average
                  Status: None
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: None
                  Effort: 0.00

    _______________________________________________________

Details:

A user reported that the COUNT procedure handles missing values
inappropriately.

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*






    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?44157>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/