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.
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*
|