SAS: dictionary.formats

Describe

proc sql;
  describe table dictionary.formats;
quit;


/*
create table DICTIONARY.FORMATS
  (
   libname char(8) label='Library Name',
   memname char(32) label='Member Name',
   path char(1024) label='Pathname',
   objname char(32) label='Object Name',
   fmtname char(32) label='Format Name',
   fmttype char(1) label='Format Type',
   source char(1) label='Format Source',
   minw num label='Minimum Width',
   mind num label='Minimum Decimal Width',
   maxw num label='Maximum Width',
   maxd num label='Maximum Decimal Width',
   defw num label='Default Width',
   defd num label='Default Decimal Width'
  );
 */

Select after proc format

proc format;
  picture
     ddmmyyyy_hh24miss 
    (default=19)                   /* <-- default width of format */
     other='%0d.%0m.%Y %0H:%0M:%0S'
    (datatype=datetime);
  
run;

proc sql;
  select *
  from
    dictionary.formats
  where
    libname = 'WORK' and
    objname = 'DDMMYYYY_HH24MISS';
quit;

See also