Different result count and tabulate commands, why?

[Floris Verweij]

Hello,

I have a question, maybe a bit basic, but I did not find the solution yet. I used the 'count' command to see how much values there are in my dataset that are higher than 1, and 'tabulate' to be able to search for them in the data. However, the commands gave different results (43 and 26). What am I doing wrong?

Regards,
Floris Verweij

. count if Uncertainty > 1
  43

. tab Uncertainty if Uncertainty > 1

Uncertainty |      Freq.     Percent        Cum.
------------+-----------------------------------
   1.184075 |          7       26.92       26.92
   1.235828 |          3       11.54       38.46
   1.651584 |          3       11.54       50.00
   1.680267 |          7       26.92       76.92
   1.992621 |          6       23.08      100.00
------------+-----------------------------------
      Total |         26      100.00

[Nick Cox]

count if missing(Uncertainty) 

will I predict tell you 17. The missing values are included in your count, but not by default in the table.

[Floris Verweij]

Thanks mr. Cox!