macro within proc sql

[deleted_user]

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,
b,
c,
&macro(a.sth, b.otherthing)

from table a left join table b

quit;

Thanks,

[KevinQin]

Yes, you can.

Remember in mind that macro is just string substitution, which always occurs before code execution.

[deleted_user]

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?

thanks,

[LinusH]

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.

/Linus