Hi Team,
I am trying to pull some data from oracle database, but I am getting the below error.
ERROR: ORACLE prepare error: ORA-00933: SQL command not properly ended. SQL statement: select Number, DATE_SEND from L_fact
where DATE_SEND >='20180822'd and DATE_SEND <='20180828'd.
proc sql feedback;
connect to oracle (user=&user password="&pass." path="@BOCP" buffsize=5000);
create table Sample as
select * from connection to oracle
(
select
Number,
DATE_SEND
from L_fact
where
DATE_SEND >='20180822'd and DATE_SEND <='20180828'd );
quit;
Thanks & Regrads,
Sanjay
Look how Oracle date literals have to be written. Do a google search for "oracle sql date literal" and follow the first link.
BTW your date literals are invalid in SAS, too.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.