Date:         Tue, 17 Mar 1998 18:31:12 -0500
Reply-To:     Thomas Huang <NYPRO.THuang@SDPS.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Thomas Huang <NYPRO.THuang@SDPS.ORG>
Subject:      parameter query in ORACLE
Content-Type: text/plain

Hi  everyone,
This is not exactly a SAS question, but it's about something I can do in
SAS and I'd like to know if I can do the same in MS ACCESS.
 
The question is: Is there such a thing as parameter query in ORACLE? I
created a  pass-through query to access data in ORACLE from MS
ACCESS and it worked fine.  But I want the query to prompt the user to
enter the criteria (I guess this is called parameter query in MS ACCESS)
for a certain field before the query get submitted to ORACLE.
 
I know this can be done in SAS by creating a macro variable.  For
example:
%LET ADMITDTE='12/29/1997';
proc sql;
  connect to oracle (user='xxx' orapw='yyy' path='@zzz');
create table CLAIMS as
select * from connection to oracle
(
SELECT *
 FROM   HOSP_CLAIMS
 WHERE ADMIT_DATE=&ADMITDTE
);
 
Thanks in advance!