mf_fmtdttm.sas File Reference

Returns E8601DT26.6 if compatible else DATETIME19.3. More...

Go to the source code of this file.

Detailed Description

From our experience in [Data Controller for SAS] (https://datacontroller.io) deployments, the E8601DT26.6 datetime format has the widest support when it comes to pass-through SQL queries.

However, it is not supported in WPS or early versions of SAS 9 (M3 and below) when used as a datetime literal, eg:

data _null_;
  demo="%sysfunc(datetime(),E8601DT26.6)"dt;
  demo=;
run;

This macro will therefore return DATEITME19.3 as an alternative format based on the runtime environment so that it can be used in such cases, eg:

data _null_;
  demo="%sysfunc(datetime(),%mf_fmtdttm())"dt;
  demo=;
run;

Related Macros

• mf_fmtdttm.test.sas

Author

Allan Bowe

Definition in file mf_fmtdttm.sas.