a simple example:

data tmp;
p1_1=1;
p1_2=2;
p2_1=3;
p2_2=4;
run;

proc sql;
        select name into: keeplist separated by ' '
        from sashelp.vcolumn
        where libname='WORK ' and memname='TMP' and name like '%_2';
quit;

data want;
  set tmp(keep=&keeplist);
run;

高手，感谢感谢

顺便问下，学习SQL，有没有什么比较好的学习材料？谢谢

我看的SQL 书也不多。至少官方的SQL Reference 即可。