Hi how would i convert from DDMMMYYYY:hh:dd:ss to a YYYYY-MM-DD
Example:
column ABC : 24OCT2015:02:24:33 covert to 2015-10-24
Im using PROC SQL.
A beginner so please let me know step by step, THANK YOU!
Use the datepart() function and apply a format so it looks the way you want it.
DATEPART(ABC) as ABC_DATE format=yymmdd10.
Use the datepart() function and apply a format so it looks the way you want it.
DATEPART(ABC) as ABC_DATE format=yymmdd10.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.