Actually that value represents the DATETIME value 24OCT2018:00:00:00. To convert the result to a DATE value use the DATEPART() function.
Just add '14OCT1582:00:00'dt to it to convert it to a SAS datetime value.
1 data test;
2 spss_dt = 13759718400;
3 sas_dt = spss_dt + '14OCT1582:00:00'dt ;
4 dt = sas_dt;
5 date = datepart(dt);
6 format spss_dt sas_dt comma15. dt datetime19. date date9.;
7 put (_all_) (=/);
8 run;
spss_dt=13,759,718,400
sas_dt=1,855,958,400
dt=24OCT2018:00:00:00
date=24OCT2018
NOTE: The data set WORK.TEST has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
... View more
