BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Adnan2
Fluorite | Level 6

Hi All,

 

I have the following code and would like to do a search on values inside the macro &country. which has the value of Asia, Europe, USA.

 

I would like to use the newly created macro in a where statement in a separate data step. How could I change the value of the macro from Asia, Europe, USA to 'Asia', 'Europe', 'USA' 

proc sql noprint;
 select distinct
 origin into:country separated by ", "
 from sashelp.cars
 ;
quit;

%put &country.;

proc sql;
 create table test_into as
 select 
 *
 from sashelp.cars
 where origin in ('&country.')
 ;
quit;

 

Many thanks in advance !

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Try this

 

proc sql noprint;
 select distinct
 quote(strip(origin)) into:country separated by ", "
 from sashelp.cars
 ;
quit;

%put &country.;

proc sql;
 create table test_into as
 select 
 *
 from sashelp.cars
 where origin in (&country.)
 ;
quit;

View solution in original post

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

Try this

 

proc sql noprint;
 select distinct
 quote(strip(origin)) into:country separated by ", "
 from sashelp.cars
 ;
quit;

%put &country.;

proc sql;
 create table test_into as
 select 
 *
 from sashelp.cars
 where origin in (&country.)
 ;
quit;
andreas_lds
Jade | Level 19

Maybe i just don't understand your problem, but why do want all distinct values in a macro-variable? What is the purpose of subsequent steps?

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 882 views
  • 0 likes
  • 3 in conversation