Date:         Fri, 7 Nov 2003 13:17:00 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: dynamic query
Comments: To: elen <yaob@HOTMAIL.COM>
Content-Type: text/plain

Elen:
SAS/Intrnet (a separate product) binds values from forms to SAS
macrovariables. You can fill in SELECT and WHERE lists, for example, in the
text of a SAS SQL program and submit the query.

So far as I know, a SAS SQL view does not have a variable type that will
automatically prompt a user for a value when the SQL compiler does not find
a column value for that variable. SAS/Intrnet appears to be your best
general option in the SAS System. Alternatively, you might want to look at
SAS SCL or APPDEV studio, or to third-party solutions (Anyone know what is
happening with David Ward and InterNext?)
Sig
-----Original Message-----
From: elen [mailto:yaob@HOTMAIL.COM]
Sent: Thursday, November 06, 2003 12:44 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: dynamic query


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.