Re: sql in SAS/AF

You can submit PROC SQL steps, in an SCL program, just as you would any
other SAS code:

dcl string (13) inputTable;
dcl string (5) outputTable;
dcl string (32) yourVariable;

inputTable='sashelp.class';
outputTable='height';

submit;
proc sql;
create view &outputTable as
select &yourVariable from &inputTable;
quit;
endsubmit;

For SQL only, you can also drop the PROC SQL, RUN, and QUIT statements if
you use the SQL and CONTINUE options on the SUBMIT statement:

submit sql continue;
create view &outputTable as
select &yourVariable from &inputTable;
endsubmit;

For the first example, code within the SUBMIT block doesn't get executed if
you test the AF application in TESTAF mode. On the other hand, code within
the SUBMIT SQL block does get executed if you test the AF application in
TESTAF mode. The latter can make debugging easier.

Once you have the data set, in the form of a data view or data file, you can
use the variable values list model
(sashelp.classes.Variablevalueslist_c.class) with the listbox control to
display the unique variable values:

Variablevalueslist.dataset=outputTable;
Variablevalueslist.variable=yourVariable;
Listbox.model='Variablevalueslist';

The listbox control (as well as the variable values list model) will have
the unique values of yourVariable as its' items attribute. Although it
isn't required to have Oracle return only unique values (the variable values
list model will do it for you), it's probably more efficient.

RandyHerbison@westat.com

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
yaobinmail@GMAIL.COM
Sent: Tuesday, January 04, 2005 4:00 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: sql in SAS/AF


Hello,

I want to populate a listbox with items from Oracle table e.g set
listbox.items to valuse from "proc sql select distinct ID from
oraTable.tissue". I'm new for SAS/AF. I tried SAS doc but didn't find the
answer. Thanks in advance.