Metadata Export Reference
SAS Data Sets Exported for Groups and Data Stores

Exporting Metadata for Groups and Data Stores describes how to export metadata for any object displayed in the Explorer window except an Environment object. This section describes the format of the exported data sets.
GENERAL:
    #    Variable    Type    Len    Pos    Label
   ---------------------------------------------------------------------
    1    INFOTYPE    Char      8      0    Information Type
    2    OBJNAME     Char     40      8    Name
    3    OBJTYPE     Char     40     48    Type
    4    OBJ_ID      Char     17     88    ID
    5    VERSION     Char      8    105    Version of Metadata
    6    DESC        Char    200    113    Description
    7    PARENTNM    Char     40    313    Owning Parent Name
    8    PARENTTP    Char     40    353    Owning Parent Type
    9    PARENTID    Char     17    393    Owning Parent Metadata ID
   10    PARENTLB    Char      8    410    Owning Parent Metadata Libref
   11    MDLIBREF    Char      8    418    Metadata Libref
   12    MDCREATE    Char     20    426    Metadata Created
   13    MDMODIFY    Char     20    446    Metadata Modified
   14    DTCREATE    Char     20    466    Data Created
   15    DTMODIFY    Char     20    486    Data Modified
   16    SUMTYPE     Char     20    506    Summary Table Type
   17    NUMCHILD    Char      8    526    Number of Direct Subordinates
   18    NOTES       Char      3    534    Notes Available
   19    NOTESLOC    Char     40    537    Notes Location

SUPPORT:

    #    Variable    Type    Len     Pos    Label
        ------------------------------------------------------------
    1    INFOTYPE    Char      8       0    Information Type
    2    OBJNAME     Char     40       8    Name
    3    OBJTYPE     Char     40      48    Type
    4    OBJ_ID      Char     17      88    Metadata ID
    5    VERSION     Char      8     105    Version of Metadata
    6    ROLE        Char     20     113    Support Role
    7    PERSNAME    Char    200     133    Person Name
    8    TITLE1      Char    200     333    Title (Primary)
    9    TITLE2      Char    200     533    Title (Secondary)
   10    PHONE1      Char     20     733    Phone (Primary)
   11    PHONE2      Char     20     753    Phone (Secondary)
   12    EMAIL       Char     40     773    Email Address
   13    ADDR1       Char    200     813    Address (line 1)
   14    ADDR2       Char    200    1013    Address (line 2)
   15    ADDR3       Char    200    1213    Address (line 3)
   16    ADDR4       Char    200    1413    Address (line 4)

LOCATION:

    #    Variable    Type    Len     Pos    Label
    --------------------------------------------------------------------
    1    INFOTYPE    Char      8       0    Information Type
    2    OBJNAME     Char     40       8    Name
    3    OBJTYPE     Char     40      48    Type
    4    OBJ_ID      Char     17      88    Metadata ID
    5    VERSION     Char      8     105    Version of Metadata
    6    LOCROLE     Char     20     113    Location Role
    7    LOCNAME     Char     40     133    SAS Library Name
    8    LOCDESC     Char    200     173    SAS Library Description
    9    ASSGNBY     Char     30     373    Assigned by
   10    LIBREF      Char      8     403    SAS Libref
   11    ENGINE      Char      8     411    SAS Library Engine
   12    PATH        Char     40     419    SAS Library Path
   13    OPTIONS     Char    200     459    SAS Library Options
   14    STORFORM    Char      8     659    Storage Format
   15    TABLE       Char      8     667    Table Name
   16    HOST        Char     40     675    Host Name
   17    LOCALE      Char     10     715    Locale
   18    REMOTE      Char    200     725    Remote Address
   19    SCRIPT      Char    200     925    Remote Script
   20    COMAMID     Char      8    1125    Access Method
   21    PROTECT     Char      3    1133    Protected
   22    TBLTYPE     Char     40    1136    DBMS Table Type
   23    CONNNAME    Char     40    1176    DBMS Connection Name
   24    CONNICK     Char      8    1216    DBMS Connection Nickname
   25    CONNUSER    Char     32    1224    DBMS Connection User/Schema
   26    CONNOPTS    Char    200    1256    DBMS Connection Options

COLUMNS:

    #    Variable    Type    Len    Pos    Label
        -----------------------------------------------------------
    1    INFOTYPE    Char      8      0    Information Type
    2    OBJNAME     Char     40      8    Name
    3    OBJTYPE     Char     40     48    Type
    4    OBJ_ID      Char     17     88    Metadata ID
    5    VERSION     Char      8    105    Version of Metadata
    6    COLNAME     Char      8    113    Column Name
    7    COLDESC     Char    200    121    Column Description
    8    COLTYPE     Char      1    321    Column Type
    9    LENGTH      Char      8    322    Column Length
   10    FORMAT      Char     32    330    Column Format
   11    INFORMAT    Char     32    362    Column Informat
   12    SUMROLE     Char     20    394    Summary Role
   13    CNOTELOC    Char     35    414    Column Note

FISCAL:

    #    Variable    Type    Len    Pos    Label
         ----------------------------------------------------------
    1    INFOTYPE    Char      8      0    Information Type
    2    OBJNAME     Char     40      8    Name
    3    OBJTYPE     Char     40     48    Type
    4    OBJ_ID      Char     17     88    Metadata ID
    5    STOD        Char      9    105    Start Time of Day
    6    SDOW        Char      9    114    Start Day of Week
    7    SDOM        Char      9    123    Start Day of Month
    8    SMOY        Char      9    132    Start Month of Year
Top of Page