topic Re: help needed to create a macro var as x1 x2 ...xn where n is not determined in SAS Programming

help needed to create a macro var as x1 x2 ...xn where n is not determined

sunrain — Tue, 31 May 2011 11:13:12 GMT

Dear Helper:

I am trying to create a macro var as x1 x2 ...xn, where the number n should be determined by another macro var.

Sunrain

Re: help needed to create a macro var as x1 x2 ...xn where n is not determined

andreas_lds — Tue, 31 May 2011 11:23:27 GMT

You have tried using a loop?

[pre]%let varCount = 10;

%do i = 1 %to &varCount;
%local x&i;
%end;[/pre]

Re: help needed to create a macro var as x1 x2 ...xn where n is not determined

sunrain — Tue, 31 May 2011 11:42:08 GMT

Thank you, Andrea.
I would like a macro var to contain these variable names, not a list of macro vars.
Sorry that I misled you.

Sunrain

Re: help needed to create a macro var as x1 x2 ...xn where n is not determined

polingjw — Tue, 31 May 2011 12:08:16 GMT

[pre]
22 %macro varlist(varCount);
23 %do i=1 %to &varCount;
24 %*; x&i
25 %end;
26 %mend;
27 %let var=%varlist(10);
28 %put var=&var;
var=x1 x2 x3 x4 x5 x6 x7 x8 x9 x10
[/pre]