Help using Base SAS procedures

how do you select number of variables in proc sql

Reply
N/A
Posts: 1

how do you select number of variables in proc sql

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!
Valued Guide
Posts: 2,177

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

if a data step does the job better, why use sql?
Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation