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 !
... View more
