These are strange results indeed.
I can't explain it, and my own test case (using DATA LIST to define 2 strings) did not replicate it.
I wonder if you could enter a missing value, say for instance, "M", and define that as the missing data value, so we can start narrowing down the issue?
------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------
Original Message:
Sent: Tue November 15, 2022 06:46 PM
From: Frank Watzl
Subject: Empty string labeled / declared as missing value
Provided that FamSpr_7 and FamSpr_8 are string variables: Is this legal syntax in Statistics V28?
PRESERVE.
SET PRINTBACK ON.
DISPLAY DICTIONARY.
FREQUENCIES FamSpr_7 FamSpr_8.
MISSING VALUES FamSpr_7 ("").
MISSING VALUES FamSpr_8 ("").
VALUE LABELS FamSpr_7 "" "<empty 7>".
VALUE LABELS FamSpr_8 "" "<empty 8>".
DISPLAY DICTIONARY.
FREQUENCIES FamSpr_7 FamSpr_8.
RESTORE.
I get strange results in variable view and incorrect output für FamSpr_8. Two cases have valid (i.e. non-empty) values for FamSpr_7. All cases have an empty string in FamSpr_8.
What should I tell Statistics in order to get correct FREQUENCIES output for FamSpr_8?
#SPSSStatistics