Hello,
I want by using sql (or by other methode) to create a macro variable like this
v_name ='Bob','alice','Petter'
I have tried sql with
proc sql;
select distinct name into :v_name sparated by '',''
from dbase;
quit;
I will get name= Bob','alice','Petter, but I want to get name= 'Bob','alice','Petter'
Thank you
Use the QUOTE() function and separated by space.
proc sql;
select distinct quote(name) into :v_name separated by ", "
from dbase;
quit;
Thank you for your answer.
What exactly are you going to do with a macro variable which resolves as:
'Bob','alice','Petter'
I assume your going to use it in either a do loop or an SQL where. Might I suggest a better way of doing it for SQL would be to put your parameters in a dataset and use a where (subclause) sytax, e.g:
data params; param="Bob"; output; param="Alice"; output; param="Petter"; output; run; proc sql; select * from HAVE where NAME in (select PARAM from PARAMS); quit;
Thank you
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.