I have SAS and SPSS on my PC and have a choice of using SAS or SPSS when converting an Excel file into a SAS dataset. In terms of reading a date variable, SAS reads the data as is. SPSS reads it and returns a different value.
This is the original date value for one case in the Excel file.
SAS PROC IMPORT returned the same date.
SPSS's IMPORT process (into a SAS dataset) returned this:
To force SPSS to correct the data, you need to subtract 21916 from the date (which converts the date of this case to be March 1st of 2016).
data spss;set raw.Assessment_spss;
FORMAT DateTaken_74 date9. ;
Here is the difference in terms of how they read column names. I read the same Excel table using SAS and SPSS.
SAS PROC IMPORT uses __ (two spaces) when it finds a space in column names. SPSS ignores spaces.