CREATE MULTIPLE DICHOTOMY FROM CONDITIONS command

See Crunch Automation basics for more information.

The CREATE MULTIPLE DICHOTOMY FROM CONDITIONS command allows you to create a multiple response variable indicating the logical condition to use for each of its responses. Each response statement must contain a LABEL and an optional ALIAS.

CREATE MULTIPLE DICHOTOMY FROM CONDITIONS
    MAPPING
        SELECT condition LABEL "label" [ALIAS alias],
        ....
        SELECT condition LABEL "label" [ALIAS alias]
    END
AS alias
[TITLE "string"]
[DESCRIPTION "string"]
[NOTES "string"];

Example

CREATE MULTIPLE DICHOTOMY FROM CONDITIONS
    MAPPING
        SELECT A=1 LABEL "First" ALIAS s1,
        SELECT B=1 OR C = 1 LABEL "Second",                
        SELECT D != 1 AND (C != 1) LABEL "Third" ALIAS s2
    END
AS my_mr_cond;

Help Center

Example

Related articles