Missing data code function

To use this function, choose Calc > Calculator.

Inserts the constant * (missing value symbol).



Use this missing data code function when you want to use the missing value symbol * in an expression.


To change any number in C1 that is less than 1 to a missing value code, enter the expression IF(C1<1,MISS(),C1) and store the results in C2.

C1 C2
6.00 6.00
3.23 3.23
4.72 4.72
3.21 3.21
0.27 *
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy