Date:         Wed, 20 Aug 2008 12:25:41 -0700
Reply-To:     Akshaya <akshaya.nathilvar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Akshaya <akshaya.nathilvar@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: macro variable generated by Proc SQL
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

My bad, you can use inner SELECT clause in a SELECT clause.(Learned a
new thing). Define the macro variables as global before the SQL step,
so that you can refer it anywhere in the same SAS session.

%global first_&&id&i last_&&id&i lastdos_&&id&i

Thanks!
Akshaya