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!