Using SAS to read Create Date in DTOC4SYS

Document ID : KB000112465
Last Modified Date : 29/08/2018
Show Technical Document Details
Question:
I'm trying to use SAS (or Sort) to build a report from a DTOC4SYS Capture file.
The create data isn't giving me anything recognizable today's date is 7600F1.
 
Answer:
The way that the date is parsed is:
The first two characters is the year which is added to d'1900'.
So, x'76' = d'118' which gives you 2018.
Then, x'00F1 = d'241'
Then your trusty Julian calendar shows that as Aug 29. 
So, that is how Vantage stores the date in as compact a format as possible,
and also be compatible for year 2000 and beyond.