Data Controller for SAS® - Dates & Datetimes¶
Dates & datetimes are actually stored as plain numerics in regular SAS tables. In order for the Data Controller to recognise these values as dates / datetimes a format must be applied.
Supported date formats:
Supported datetime formats:
Supported time formats:
In SAS 9, this format must also be present / updated in the metadata view of the (physical) table to be displayed properly. This can be done using DI Studio, or by running the following (template) code:
proc metalib; omr (library="Your Library"); folder="/Shared Data/table storage location"; update_rule=(delete); run;
If you have other dates / datetimes / times you would like us to support, do get in touch!