Cláusula where no from com prefixo nas colunas

Cláusula WHERE no FROM com prefixo nas colunas
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
    proc sql;

        create table ex11a as
        select *
        from scores
        where subject_id like '100-%' 
        or subject_id like '20%';

        /* pode ser dessa forma */

        create table ex11b as
        select *
        from scores(where=(subject_id in: ('100-','20')));

    quit;