Hi All,
I have difined oracle DB in SAS SMC and register the tables too.
The table has birth_dt column as DATE Format(data like 20APR1990) when i see the same column in SAS SMC and EG, been converted as DATETIME20.0(data shows like 20APR1990:00:00:00).
Users dont want apply any code on SAS dataset to extract date like datepart functions.
how to restrict 'birth_dt' column to register in SAS Metadata as in Oracle DB(DATE9. format) and stop converting to DATETIME20. format?
Thank you,
CG