CREATE CATEGORICAL CASE command
CREATE CATEGORICAL CASE (non-schema command)
See Crunch Automation basics for more information.
The CREATE CATEGORICAL CASE command allows you to assign specific values to categories based on a sequence of logical conditions. This is useful for creating segments or defining conditions based on multiple other variables, and not just recoding one. Rows that do not match any WHEN condition will be missing.
CREATE CATEGORICAL
CASE
WHEN condition THEN "label" [CODE value [MISSING]]
...
WHEN condition THEN "label" [CODE value [MISSING]]
[ELSE "string" [CODE value [MISSING]|ELSE INTO NULL]
END
AS alias
[TITLE "string"]
[DESCRIPTION "string"]
[NOTES "string"];
Example
CREATE CATEGORICAL
CASE
WHEN pid3 = "Democrat" AND ptystrength = "Strong"
THEN "Strong Democrat" CODE 1
WHEN pid3 = "Democrat" AND ptystrength = "Weak"
THEN "Weak Democrat" CODE 2
WHEN pid3 = "Independent" AND ptycloser = "Democrat"
THEN "Lean Democrat" CODE 3
WHEN pid3 = "Independent" AND ptycloser = "Neither"
THEN "Independent" CODE 4
WHEN pid3 = "Independent" AND ptycloser = "Republican"
THEN "Lean Republican" CODE 5
WHEN pid3 = "Republican" AND ptystrength = "Weak"
THEN "Weak Republican" CODE 6
WHEN pid3 = "Republican" AND ptystrength = "Strong"
THEN "Strong Republican" CODE 7
ELSE "Unknown party" CODE 9 MISSING
END
AS "pid7"
TITLE "Party Identification"
DESCRIPTION "7 category party identification scale"
NOTES "Recoded from pid3, ptystrength, and ptycloser";