BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ChrisWoo
Obsidian | Level 7
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
1 ACCEPTED SOLUTION

Accepted Solutions
FreelanceReinh
Jade | Level 19

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;

View solution in original post

2 REPLIES 2
FreelanceReinh
Jade | Level 19

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
Obsidian | Level 7
i see. Thx

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1005 views
  • 0 likes
  • 2 in conversation