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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.