topic Shortcut to select multiple column in SAS Programming

Shortcut to select multiple column

ChrisWoo — Mon, 29 May 2023 09:20:41 GMT

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

Re: Shortcut to select multiple column

FreelanceReinh — Mon, 29 May 2023 09:46:27 GMT

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;

Re: Shortcut to select multiple column

ChrisWoo — Mon, 29 May 2023 09:57:21 GMT

i see. Thx