Using SAS to read Create Date in DTOC4SYS
search cancel

Using SAS to read Create Date in DTOC4SYS

book

Article ID: 112465

calendar_today

Updated On:

Products

Vantage Storage Resource Manager

Issue/Introduction



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.
 

Environment

Release: SMV3EN00200-14.0-Graphical Management Interface
Component:

Resolution

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.