Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In SPSS, how do I set a variable to the system missing value?

In SPSS, $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 temp, which 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 (v1 and v2), and you wish to recode all cases of 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 this:

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

When using recode and if statements, set up a condition using the missing value by specifying sysmis(variable). Do not use the regular  =  (equals) sign.

For more about statistical and mathematical software, email the UITS Stat/Math Center, visit the center's web page, or phone 812-855-4724 (IUB) or 317-278-4740 (IUPUI). The center is located in Bloomington at 410 N. Park Avenue, and is open for consultation by appointment Monday-Friday 9am-5pm.

This is document afcg in domain all.
Last modified on May 04, 2011.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.