How do I convert a DATETIME22.3 value into a SAS date value (number of days since January 1 1960)? I am running PC SAS 9.3.
Glad it worked. On closer inspection, you will find that newdatadate and sasdate contain the same value (with different formatting).
The function to extract a date from a datetime is datepart().
So you either do (in a data step)
date_new = datepart(datetimeval);
format date_new yymmdd10.;
or (to replace the original variable)
dateval = datepart(dateval);
format dateval yymmdd10.;
Although I prefer version 1, as it also allows you to set a length for the new variable (date values can be stored in 4 bytes, datetime need all 8).
Glad it worked. On closer inspection, you will find that newdatadate and sasdate contain the same value (with different formatting).
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.