topic Adding the string in macro variable separated by comma in SAS Programming

Adding the string in macro variable separated by comma

David_Billa — Thu, 18 Mar 2021 09:25:06 GMT

I've the macro variable as below. Now I want to create one more macro variable by using this macro variable 'Meta_Col' and I want to add the string meta. to the value in the macro variable Meta_Col

%let Meta_Col=businessDataName,reportingArea,reportingDate,reportingPurpose;

Desired Result is to create one macro variable (e.g. Meta_new_Col) and it should have value as below. Any help?

meta.businessDataName,meta.reportingArea,meta.reportingDate,meta.reportingPurpose

Re: Adding the string in macro variable separated by comma

Kurt_Bremser — Thu, 18 Mar 2021 09:34:49 GMT

%let Meta_Col=businessDataName,reportingArea,reportingDate,reportingPurpose;

data _null_;
meta_col = "&meta_col.";
length meta_new_col $1000;
do i = 1 to countw(meta_col,",");
  meta_new_col = catx(",",meta_new_col,"meta."!!scan(meta_col,i,","));
end;
call symputx("meta_new_col",meta_new_col);
run;

%put &=meta_new_col;

Re: Adding the string in macro variable separated by comma

FreelanceReinh — Thu, 18 Mar 2021 10:23:56 GMT

Alternatively, you can use a combination of functions:

%let Meta_new_Col=meta.%sysfunc(tranwrd(%quote(&meta_col),%str(,),%str(,meta.)));