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

 
 

bug #44157: COUNT vs. missing values

Submitted by:  John Darrington <jmd>
Submitted on:  Mon 02 Feb 2015 06:42:39 AM UTC  
 
Category: Syntax ParserSeverity: 5 - Average
Status: FixedAssigned to: Ben Pfaff <blp>
Open/Closed: ClosedRelease: None
Effort: 0.00

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

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

I applied a fix.

Ben Pfaff <blp>
Project AdministratorIn charge of this item.
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>
Project Administrator

 

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

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 3 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sun 15 Feb 2015 10:53:10 PM UTCblpStatusNone=>Fixed
      Assigned toNone=>blp
      Open/ClosedOpen=>Closed

    Back to the top


    Powered by Savane 3.1-cleanup1