topic Re: Define macro variables in SAS Programming

Define macro variables

SeanZ — Wed, 17 Jul 2013 21:16:13 GMT

I defined 15 macro variables like

%let x1=xxx

%let x2=xxx

%let x3=xxx

....

xxx are some variables in my dataset.

I wonder how I can call some of them together in some procedures such as proc sql and proc reg. For example, I can write

proc reg data=new;

model ret = &x1 &x2 &x3 &x4;

run;

Can I shorten this code such as model ret = &x1-&x4? I tried this, but not work.

Thanks.

Peter_C — Wed, 17 Jul 2013 22:32:29 GMT

some functions and statements allow variable ranges. The rules are not in the macro language

Tom — Wed, 17 Jul 2013 22:43:07 GMT

If you are already running in a macro then use a DO loop.

%do i=1 %to 15 ; &&x&i %end;

Or just make a new macro variable. You still have to type them out but only one time.

%let xall=&x1 &x2 &x3 &x4 &x5 &x6 .......... ;

Or pull the names from the metadata? Watch out for the SCOPE setting.

proc sql ;

select distinct cats('&',name) into : xall separated by ' '

from dictionary.macros

where name like 'X%' and scope = "GLOBAL"

;

quit;

.... var &xall ... ;

Ksharp — Thu, 18 Jul 2013 01:19:48 GMT

If their order is the same within dataset . or you could try this.

model ret = &x1 -- &x4?

Ksharp