how do you select number of variables in proc sql

rajm895 — Fri, 09 Apr 2010 02:30:00 GMT

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!

Re: how do you select number of variables in proc sql

Peter_C — Fri, 09 Apr 2010 09:02:38 GMT

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

topic how do you select number of variables in proc sql in SAS Procedures

how do you select number of variables in proc sql

Re: how do you select number of variables in proc sql