Hi,   I need to extract the data from Oracle based on DateTime .   Just want to check which is the approach to pull the data from Oracle based on below scenario.   Oracle table(Data_Type TIMESTAMP(6)) Column1 01-JUN-17 10.07.18.631000000 AM   We need to create the sas table by passing the DateTime value at sas level.  We need to include the milliseconds in time so that we will not extract the same data again.   ... View more

Thanks for the reply. My objective is to create the below format in sas dataset then pass the value in where clause. '03-MAY-17 01.15.08.214000000 PM' : This data I copied from Oracle column   How I can create the above format in the sas data step. ... View more

It's not working fine.. here is an error.   ERROR: ORACLE PREPARE ERROR: ORA-00933: SQL command not properly ended. SQL STATEMENT   ... View more

Yes, I want to create the macro variable in sas equivalent to  Oracle  TIMESTAMP(6) format. ... View more

Thanks for the quick reply.   I want to extract data from Oracle on the datetime column. In Oracle, DateTime column format is TIMESTAMP(6).   Here is my sample code to extract the data from Oracle and its work fine. my question is how I can define the ''03-MAY-17 01.15.08.214000000 PM'  format in sas to create the macro and pass in where condition while extracting the data from Oracle.   proc sql; %oracle_connect(&rtt); create table temp as select * from connection to &tt ( SELECT * FROM schema.table where TO_CHAR(CTETIME,'DD-MON-RR HH.MI.SS.FF9 AM')= '03-MAY-17 01.15.08.214000000 PM' ); quit;   ... View more

Thanks for the quick reply.   We already checked with BDA and they are unable to resolve this issue. Every alternative day, process getting fail. Can you please provide any alternative method (sas prog) to solve this issue. ... View more

Dear All, We are facing some issue on the SAS-Oracle side. We have one process which throws a timeout error sometimes. When its executed, its run in just 30 seconds and sometimes it goes into hang stage and kills later on as a timeout error.   We are joining the 3 tables and first, we are creating the distinct of few variables like this With master_dd as(select %str(/)*+ parallel(MASTER_) *%str(/) A,b  ....................., and filter out few records with where condition. in this step we are creating the table without the merge.   next step we are merging the above table with another two table from a different schema with where condition.   Its very simple join but its executed sometime and some tie its failed.   Please guide me. ... View more

Yes, the password is up to date. with the same password, I can access the other sas environment.    Can you please advise how I can check the sas unix access as we don't have any metadata env.   We are using sas9.2 on Unix for submitting the batch sas jobs.     ... View more

hare the Thanks for the quick reply. I could not share the signon macro. its very large code and also include confidential details.    Could you please share the sample signon code then I will run and share the log ... View more

Thanks,   How we can create csv file as password protected on unix. Please share any example. ... View more