topic Re: Date conversion SPSS numeric to SAS date in SAS Programming

Date conversion SPSS numeric to SAS date

vanja — Tue, 13 Aug 2024 13:45:05 GMT

I have imported SPSS files (.sav) into SAS Viya via proc import. But the date variables are not converted into SAS dates. After some investigation I found that the value I have got is a numeric value representing the number of seconds since October 14 year 1582. For example the number 13759718400 represents 24-Oct-2018.

Is there a SAS function to translate this numeric value to a SAS date variable? Or has someone here invented the code needed for this conversion?

I still have the option to save my spss file into a sas dataset and then import it. I have checked that the date variables will be ok. But now I'm curious to know if there is a very simple solution to my problem. Thanks in advance!

Re: Date conversion SPSS numeric to SAS date

PaigeMiller — Tue, 13 Aug 2024 13:48:27 GMT

See https://marc.info/?l=sas-l&m=116624449238415&w=2

Re: Date conversion SPSS numeric to SAS date

ballardw — Tue, 13 Aug 2024 14:09:29 GMT

Easy to convert the value to a SAS datetime value add the result of dhms('14OCT1582'd,0,0,0)

data example;
   x=13759718400;
   offset = dhms('14OCT1582'd,0,0,0);
   SASDatetime = x+offset;
   format SASDatetime datetime20.;
   datevalue=datepart(x);
   format datevalue date9.;
run;

If you want a DATE value then extract using the DATEPART function.

Re: Date conversion SPSS numeric to SAS date

vanja — Sun, 18 Aug 2024 14:19:23 GMT

@ballardw Thank you for taking the time to solve my problem!

Re: Date conversion SPSS numeric to SAS date

vanja — Sun, 18 Aug 2024 14:23:04 GMT

@PaigeMiller Thank you, the solution you provided link to also worked.

days = datespss/86400;
datesas = date() - ( date() - MDY(10,14,1582) - days );
format datesas date9.;

Re: Date conversion SPSS numeric to SAS date

Tom — Sun, 18 Aug 2024 17:20:24 GMT

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