topic Re: how to concatinate macro variable values? in SAS Programming

how to concatinate macro variable values?

javvadi — Mon, 03 Feb 2014 12:48:18 GMT

Dear all,

%let var1=a;

%let var2=b;

%let var3=c;

%let var4=d;

%let var5=e;

%let x= &var1 %to &var5;

i need x=a,b,c,d,e

thank you

Re: how to concatinate macro variable values?

data_null__ — Mon, 03 Feb 2014 13:03:22 GMT

17         %let var1=a;
18         %let var2=b;
19         %let var3=c;
20         %let var4=d;
21         %let var5=e;
22         
23         
24         %let x = &var1,&var2,&var3,&var4,&var5;
25         
26         %put NOTE: &=x;
NOTE: X=a,b,c,d,e

Re: how to concatinate macro variable values?

Amir — Mon, 03 Feb 2014 13:28:39 GMT

Hi,

If you really want to make use of "%to" for larger lists then you'll need to use it inside a macro definition, e.g.:

%let var1=a;

%let var2=b;

%let var3=c;

%let var4=d;

%let var5=e;

%macro makecsv(root,fromval,toval);

%let sep=;

%let makecsv=;

%do csvloop=&fromval %to &toval;

%let makecsv=&makecsv&sep&&&root&csvloop;

%let sep=%str(,);

%end;

&makecsv;

%mend makecsv;

%let x=%makecsv(var,1,5);

%put x=&x;

Regards,

Amir.

Message was edited by: Amir Malik - formatting.

Re: how to concatinate macro variable values?

Haikuo — Mon, 03 Feb 2014 15:00:36 GMT

So there could be many solutions, but do remember SAS Macro is nothing but a text string maneuver.

%let var1=a;

%let var2=b;

%let var3=c;

%let var4=d;

%let var5=e;

%macro cat;

%global x;

%let x=;

%do i=1 %to 5;

%if &i=1 %then %let x=&var1;

%else %let x=&x,&&var&i;

%end;

%mend;

%cat;

%put &x;

Haikuo