I have datatime in numeric format and i wnat to convert it into date format dd/mm/yy format
example:-
01APR3016 00:00:00 in numeric format
i want
01APR2016 in date format
In what scenario, if its for a report then format it as date9.:
format <variable> date9.;
If you want a variable as date9 then:
<new_variable>=datepart(<old_variable>);
format <new_variable> date9.;
In what scenario, if its for a report then format it as date9.:
format <variable> date9.;
If you want a variable as date9 then:
<new_variable>=datepart(<old_variable>);
format <new_variable> date9.;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.