I am trying to load data from oracle into SAS . for a date field SAS by default treats it as datetime field.
how do I trim the datetime to date in the load call
my code looks something like this
proc casutil;
load casdata="WSPLIT" casout="WSPLIT" vars= ( (NAME="ROW_DATE",format='ddmonyyyy' formattedlength=9 ),
(NAME="ROW_DATE",format='DATE9' formattedlength=9 ),
/*(NAME="ROW_DATE"),*/ (NAME="ABCD"),
)
incaslib="MAIN" outcaslib="DBORA" ;
if I use the commented line row_date shows up like 05OCT2020 00:00:00... the uncommented format
gets me date in 1917388800, I am trying to get just 05OCT2020
SAS Documentation just says
FORMAT="string" specifies the format to apply to the variable.
... View more
