Previous Page | Next Page

Example: Using the INFOMAPS Procedure and the Information Maps Engine

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

106  /* View the data items, including any filters, in the information map. */
107  proc contents data=HR_Data."Employee Info"n;
108  run;

NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           6.01 seconds
      cpu time            0.18 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

110  /* Turn on aggregation and view the contents of the information map. */
111  proc contents data=HR_Data."Employee Info"n(aggregate=yes);
112  run;

NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           4.14 seconds
      cpu time            0.06 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

Previous Page | Next Page | Top of Page