how do you select number of variables in proc sql

[rajm895]

I have col1 to col12 in my dataset and i want to select all of these variables in the proc sql step, is it possible to do it

for example if it was a datastep i would do keep col1-col12,

proc sql;
create table x as
select col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, y.*
from x, y
on x.pt=y.pt etc etc
quit;

Is there a way to include col1 to col12 in a simpler way

Thank you very much!

[Peter_C]

if a data step does the job better, why use sql?