在sql里面生产宏的问题

想在一个sql里做多个select into的话，应该怎么写？

PROC SQL NOPRINT;
SELECT DISTINCT var1, var2 INTO  :E1 SEPERATED BY “ , ” ,
:E2 SEPERATED BY “  ”  FROM DATA_TABLE;
QUIT;

%PUT &E1;
%PUT &E2;

proc sql noprint;
select distinct name into: var1- :var19
from sashelp.class;
quit;

也可以选用data步里的call symputx，也很灵活

lira12 发表于 2018-5-4 14:12
PROC SQL NOPRINT;
SELECT DISTINCT var1, var2 INTO  :E1 SEPERATED BY “ , ” ,
:E2 SEPERATED BY “ ...

谢谢 就是这句