Shortcut to select multiple column

[ChrisWoo]

Hi guys, may I know how should I write my codes to select multiple columns without listing the column names one by one?

Example
Proc sql;
Select
Country,
P1,
P2,
P3,
P4
From country_list;


I wish to have a shortcut like this
Proc sql;
Select
Country,
P1-P4
From country_list

[FreelanceReinh · Accepted solution]

Hi @ChrisWoo,

There are no variable lists in PROC SQL, but in most cases you can use dataset options which support variable lists:

proc sql;
select *
from country_list(keep=country p1-p4);
quit;

[ChrisWoo]

i see. Thx