In SPSS, how do I set a variable to the system missing value?
$sysmis is the name of the system missing value.
You can include this in a
compute statement or in an
if statement, as you would any other variable name. For
example, if you want to generate the variable
equals the system missing value, the syntax would look like this:
COMPUTE temp = $sysmis.
A more common scenario would be to use this variable in a conditional
statement. For example, suppose you have two variables
v2), and you wish to recode all
v2 to be equal to the system missing value where
v1 is also system missing. Rather than using the
recode command, use an
if statement like
IF sysmis(v1) v2=$sysmis.
You can use the variable
$sysmis only as a value; you
cannot use it in the actual conditional statement. If you are
searching for cases where
v1 is equal to the system
missing value, you get this:
IF v1=$sysmis v2=$sysmis. ^^^^^^^^^^ wrong syntax
if statements, set up
a condition using the missing value by specifying
sysmis(variable). Do not use the regular
= (equals) sign.
If you have questions about using statistical and mathematical software at Indiana University, email UITS Research Analytics. Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200, and is open for consultation by appointment Monday-Friday 9am-5pm.
This is document afcg in the Knowledge Base.
Last modified on 2014-06-25.
- Fill out this form to submit your issue to the UITS Support Center.
- Please note that you must be affiliated with Indiana University to receive support.
- All fields are required.