Step 6: View the Data Items and Filters Using the CONTENTS Procedure

You can view the data items and filters in the new information map that you just created.
The following code uses the CONTENTS procedure to display the default set of information about the data items and filters:
/* View the data items, including any filters, in the information map. */
proc contents data=HR_Data."Employee Info"n;
run;
Log for the CONTENTS Procedure
122  /* View the data items, including any filters, in the information map. */
123  proc contents data=HR_Data."Employee Info"n;
124  run;

NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.46 seconds
      cpu time            0.03 seconds
Output from the CONTENTS Procedure
                                The CONTENTS Procedure

      Data Set Name        HR_DATA.'Employee Info'n    Observations          .
      Member Type          DATA                        Variables             9
      Engine               INFOMAPS                    Indexes               0
      Created              .                           Observation Length    0
      Last Modified        .                           Deleted Observations  0
      Protection                                       Compressed            NO
      Data Set Type                                    Sorted                NO
      Label                                            Filters               4
      Data Representation  Default
      Encoding             Default


                      Alphabetic List of Variables and Attributes

  #    Variable                 Type    Len    Format       Label

  7    Annual Salary            Num       8    DOLLAR12.    Physical column SALARY
  5    Dept_code                Char     32
  3    Division                 Char     40                 Physical column DIVISION
  9    Enddate                  Num       8    DATE9.       Physical column ENDDATE
  4    Identification Number    Num       8    SSN11.       Physical column IDNUM
  1    Jobcode                  Char      8                 Physical column JOBCODE
  2    Location                 Char      8                 Physical column LOCATION
  8    Monthly Salary           Num       8    DOLLAR12.
  6    Title                    Char     20    $F20.        Physical column TITLE


                                  Information Maps

   FilterName                  FilterType  FilterDesc

   Status is Current           Unp
   Education and Publications  Unp         Employees in Education and Publications
   Host Systems Development    Unp         Employees in Host Systems Development
   Cary HQ                     Unp         Located in Cary, North Carolina HQ
The following code uses the AGGREGATE= data set option in conjunction with the CONTENTS procedure to display additional information about the aggregations that are applied to data items that are measures:
/* Turn on aggregation and view the contents of the information map. */
proc contents data=HR_Data."Employee Info"n(aggregate=yes);
run;
Log for the CONTENTS Procedure
126  /* Turn on aggregation and view the contents of the information map. */
127  proc contents data=HR_Data."Employee Info"n(aggregate=yes);
128  run;

NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.22 seconds
      cpu time            0.01 seconds
Output from the CONTENTS Procedure
                                The CONTENTS Procedure

      Data Set Name        HR_DATA.'Employee Info'n    Observations          .
      Member Type          DATA                        Variables             9
      Engine               INFOMAPS                    Indexes               0
      Created              .                           Observation Length    0
      Last Modified        .                           Deleted Observations  0
      Protection                                       Compressed            NO
      Data Set Type                                    Sorted                NO
      Label                                            Filters               4
      Data Representation  Default                     Aggregate Variables   2
      Encoding             Default


                     Alphabetic List of Variables and Attributes

                                                Default
#  Variable               Type  Len  Format     Aggregation  Label

7  Annual Salary          Num     8  DOLLAR12.  SUM          Physical column SALARY
5  Dept_code              Char   32
3  Division               Char   40                          Physical column DIVISION
9  Enddate                Num     8  DATE9.                  Physical column ENDDATE
4  Identification Number  Num     8  SSN11.                  Physical column IDNUM
1  Jobcode                Char    8                          Physical column JOBCODE
2  Location               Char    8                          Physical column LOCATION
8  Monthly Salary         Num     8  DOLLAR12.
6  Title                  Num     8  BEST12.    COUNT        Physical column TITLE


                                  Information Maps

   FilterName                  FilterType  FilterDesc

   Status is Current           Unp
   Education and Publications  Unp         Employees in Education and Publications
   Host Systems Development    Unp         Employees in Host Systems Development
   Cary HQ                     Unp         Located in Cary, North Carolina HQ