@Haydn,
Can you tell me the exact data you are exporting from SharePoint? Is it text that represents a date or is it an actual DateTime field? If you are exporting a DateTime field, if I recall correctly, you have to compensate for the difference between the way .Net represents a DateTime and SAS. SAS DateTime values are a count of seconds starting on 01 Jan 1960. By contrast, .Net represents a DateTime value as the number of seconds 01 Jan 0001. There are 715,509 days between 01 Jan 0001 and 01 Jan 1960 (I looked it up), and there are 84,600 seconds per day. You would need to adjust a SharePoint DateTime value by subrtracting (715,509 * 84600) from it if I'm remembering my math correctly.
If you're reading character representations of a date, for example 09/09/2020, then you need to make sure you're using a Date format if it's a date (example 09/09/2020) or a DateTime format if the value is represents a DateTime value (example 2020/09/09:16:57:00). Be sure to used Date formats for dates and DateTime formats for DateTimes.
Jim
In addition, SAS doesn't consider 4000 or 8000 to be leap years. If you're dealing with long term dates, you might have to compensate for that difference in what is considered a leap year.
... View more