On Tue, 2 Mar 2004 13:35:45 -0600, Dewen Hou <Dewen.Hou@BLOCKBUSTER.COM>
>Hi Dear All,
>Can I use a Macro Call in the Proc SQL Selection? Something like:
>Create Table A as
>Select X1, Y1, X2, Y2, %Distance(X1,Y1,X2,Y2) as Dist
>Here %Distance is a macro to do some calculation.
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.