bugPSPP - Bugs: bug #44157, COUNT vs. missing values

 
 

bug #44157: COUNT vs. missing values

Submitter:  John Darrington <jmd>
Submitted:  Mon 02 Feb 2015 06:42:39 AM UTC
   
 
Category:  Syntax Parser Severity:  5 - Average
Status:  Fixed Assigned to:  blp
Open/Closed:  Closed Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup
   

Sun 15 Feb 2015 10:53:10 PM UTC, comment #1: 

I applied a fix.

Ben Pfaff <blp>
Group administrator
Mon 02 Feb 2015 06:42:39 AM UTC, original submission:  

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*



John Darrington <jmd>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by blp (Posted a comment)
  • -email is unavailable- added by jmd (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2015-02-15 blp StatusNone Fixed
        Assigned toNone blp
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code