Sql.sas

data resultats;
    set votre_table;

    array colonnes[*] col1-col20;

    terme1_present = 0;
    terme2_present = 0;
    terme3_present = 0;

    do i = 1 to dim(colonnes);
        if colonnes[i] contains 'terme1' then terme1_present = 1;
        if colonnes[i] contains 'terme2' then terme2_present = 1;
        if colonnes[i] contains 'terme3' then terme3_present = 1;
    end;

    if terme1_present and terme2_present and terme3_present;
run;