Date:         Fri, 7 Nov 2003 08:10:04 -0800
Reply-To:     elen <yaob@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         elen <yaob@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: dynamic query
Content-Type: text/plain; charset=ISO-8859-1

yaob@hotmail.com (elen) wrote in message news:<6ae61632.0311060944.1f67171e@posting.google.com>...
> I'd like to create a query according to user's input. The user will
> select which columns of tables and data he need. Is there a way in SAS
> to create a query statement dynamically and execute later? Thanks in
> advance.

What I mean by dynamic query is that the query will be changed(not
hard coded) according to user's input. I think macro doesn't work
because I don't know which tables and columns a user need. The select
and from clause should also be dynamic as well as any necessary table
join. Is there something similar to EXECUTE function of sql but with
query statements.
Thanks.