Cant assign missing values to string variable in SPSS using the GUI
I am strugling recoding missing values in SPSS using the graphical user interface. I can easily recode numeric variables using the GUI and the dialogue box shown below:
But when i enter a string variable into the same dialogue box the option to define the new value as "System-missing" is not available:
Surely such a simple problem can be solved without using the syntax editor?
Im using SPSS version 19
It is because system-missing values are defined only for numeric variables. You can define user-missing values for strings. For example, recode to some unused string value, like "99999" and set the value "99999" as user-missing afterwards.
IBM SPSS Statistics 19 Command Syntax Reference, page 55:
System-missing values cannot be generated for string variables, since any character is a legal string value.
- ODBC error when trying to connect MS Excel to SPSS file on fileserver
- Why does converting a nested python dictionary into a pandas dataframe result in "has no attribute 'items' error?
- Simple contrasts output from SPSS in R
- SPSS If statement with multiple conditions
- Importing SPSS dataset into Python
- SPSS Custom Tables Nesting
- Change value labels or delete specific value labels
- pyreadstat read and write spss without data loss
- Efficient way for converting Yes/No to 1/0 in Excel or SPSS
- Fill in missing values in a row based on another column SPSS syntax?
- Pivot variables in SPSS with `CASESTOVARS` and specify the resulting column names
- Convert string YYYY-MM-DD to MM/DD/YYYY date in SPSS?
- R - changing values to labels permanently in labelled data
- SPSS match files results in empty column
- calculation with different values in SPSS
- How do I shorten super long variable labels of an SPSS file in R?
- Dynamically remove columns with no variance in syntax
- SPSS Syntax: spliting one categorical variable into multiple yes/no variables
- Translating a simple data check method from SAS into SPSS (crosstabs for 3+ variables fed into output dataset)
- SPSS: How to access values of variables, where the names of the variables I want are the values of another variable
- How do I write a DO IF command asking to compute something ONLY if the value of that case is missing? [SPSS]
- Creating one variable from three, SPSS
- How to properly invoke Python 3 script from SPSS syntax window using SCRIPT command (+ additional problems during runtime)
- What's a pythonic way (native function in pandas) to count occurrences of a certain value within cases (SPSS COUNT equivalent)?
- In a dataset where individuals have multiple rows of data per enrollment, how can I make a variable that indicates enrollment instance (1st/2nd/etc.)?
- Import .spv file into R / convert into .csv
- SAS no longer automatically converts user-defined formats to SPSS value labels
- Concat Valuelabels with IF condition in SPSS
- SPSS: trying to summarise the ranking of items, from a survey with drag&drop question
- SPSS - How to isolate the maximum value in a variable so you can use it in syntax?