Example: Using the INFOMAPS Procedure and the Information Maps Engine |
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
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.