Hello,
I have a datetime format like shown below and have difficulty changing it to a date9. format.
Format is datetime22.3 and informat is also datetime22.3
ID Tken_date
110 12DEC2015:00:00:00.000
111 13DEC2015:00:00:00.000
112 14DEC2015:00:00:00.000
113 15DEC2015:00:00:00.000
WANT
ID Tken_date
110 12DEC2015
111 13DEC2015
112 14DEC2015
113 15DEC2015
Thanks
If you are not actually using the time part I would suggest converting to a date and assigning the desired format:
data want;
set have;
Tken_date=datepart(Tken_date);
format Tken_date date9.;
run;
If you are not actually using the time part I would suggest converting to a date and assigning the desired format:
data want;
set have;
Tken_date=datepart(Tken_date);
format Tken_date date9.;
run;
OMG!, I was trying that and other PUT, INPUT combinations all this while but it throwed up some negative numbers.
It works now though ...thansk a ton...
Regards
DTDATE9
format variable_name dtdate9.;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.