topic Concatenate Single Quote with text of a Macro Variable in SAS Programming

Concatenate Single Quote with text of a Macro Variable

MKhandelwal — Fri, 11 Feb 2011 11:44:44 GMT

Hi,

I have a macro variable dep_var as

[pre] %let dep_var=yld syld myld; [/pre]
I want a new macro variable as say
[pre]new_dep='yld syld myld' [/pre]
i.e I want to cocatenate the text of my macro variable dep_var with single quotes.

Thanks.

Re: Concatenate Single Quote with text of a Macro Variable

data_null__ — Fri, 11 Feb 2011 14:18:09 GMT

%str(%') is needed. You may need to unquote the value, now or later.

[pre]
927 %let dep_var=yld syld myld;
928 %let new_var1=%str(%')&dep_var.%str(%');
929 %let new_var2=%unquote(%str(%')&dep_var.%str(%'));
930
931 %put _user_;
GLOBAL NEW_VAR2 'yld syld myld'
GLOBAL NEW_VAR1 yld syld myld
GLOBAL DEP_VAR yld syld myld
[/pre]

Re: Concatenate Single Quote with text of a Macro Variable

russt_sas — Mon, 14 Aug 2017 18:55:45 GMT

There are 2 ways to accomplish this task.

%let dep_var=yld syld myld;

Method 1:

%let new_var2=%unquote(%str(%'&dep_var%'));

Method 2 (If running SAS 9.4 or greater):

%let new_var3=%tslit(&dep_var);