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).
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.