|
On Tue, 2 Mar 2004 13:35:45 -0600, Dewen Hou <Dewen.Hou@BLOCKBUSTER.COM>
wrote:
>Hi Dear All,
>
>Can I use a Macro Call in the Proc SQL Selection? Something like:
>
>Proc SQL;
>Create Table A as
>Select X1, Y1, X2, Y2, %Distance(X1,Y1,X2,Y2) as Dist
>from B;
>Quit;
>
>Here %Distance is a macro to do some calculation.
>
>Thanks,
>
>David Hou
Hi, David,
Why not? It would work as long as the macro "emits" (hi, Richard!) an
expression that the select can handle. I would try the expression first as
it is then package it into the distance macro.
Cheers,
Chang
|
