@Ahsan wrote:
I didn't move any data. SAS EG is connected to Oracle database so how I see date and time in SQL developer I want to see the same in SAS.
EG is a Windows program you are running on your PC to connect to a server running SAS, not Oracle. The only way it can get data from Oracle is if you used some SAS commands to connect your SAS session to your Oracle database.
So what did you run?
Did you create a SAS libref that points to a schema (database) in Oracle?
Did you use PROC SQL to connect to Oracle and write a passthrough query to pull some data from Oracle?
Did you push some buttons in EG? What type of buttons?
You probably need to either change how the data is defined in Oracle so that SAS can autodetect that you want the full datetime value for that variable. Or tell SAS your self how to treat that variable. Look at the DBSASTYPE= dataset option.
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371572.htm
You can also use SQL pass-through in SAS and use the to_char() function if you want.
There are many papers on how to do this.
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.