DATA Step, Macro, Functions and more

macro within proc sql

Not applicable
Posts: 0

macro within proc sql

Hi guys,

My question is can i call macro within a proc sql procedure?

I am writing a simple proc sql procedure. the macro will take table a,b fields as parameters.

proc sql;
select a,
&macro(a.sth, b.otherthing)

from table a left join table b


Posts: 43

Re: macro within proc sql

Posted in reply to deleted_user
Yes, you can.

Remember in mind that macro is just string substitution, which always occurs before code execution.
Not applicable
Posts: 0

Re: macro within proc sql

Thanks Kevin,

so you mean the macro will be executed first and then sas execute the code.

but some of those parameters are coming from the joined tables, if the table are not joined first, does the macro still be able to take them in as parameter?

Super User
Posts: 5,884

Re: macro within proc sql

Posted in reply to deleted_user
If the macro variable is not initialized, then it would probably not have any value if the join hasn't been done.

Macro variable just holds values that can be assigned globally in SAS session (that is, independent from data steps, SQL etc). They don't get executed. If you talk about macro execution, you probably mean %macro definitions, which probably contain macro statements maybe mixed with other SAS statements/programs.

You could review the on-line documentation for SAS macro programming.

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation