Do If Spss String. If you use the SPSS keyword all instead of a variable or a list of variables you will delete all user-defined missing values for all variables both string and numeric. I need to search the entire variable for a few keywords then select them out for analysis.
If Type does not say String youre dealing with a numeric variable. The syntax below converts all string variables in one go. To do this do not type anything in the parentheses after the variable listed on the missing values command.
Write n spaces between the apostrophes.
Because the variable score is a string variable we cannot calculate a mean etc for this variable. In this situation you must use Automatic Recode in order for SPSS to recognize blank strings as missing values. Its most basic use is compute s2 string s1f1. If the logical expression on DO IF is true the program executes the commands immediately following DO IF up to the first ELSE IF.
