Example: Using the INFOMAPS Procedure and the Information Maps Engine

Step 7: Print the Data from the Information Map

You can use the PRINT procedure to print all of the data that the information map contains. If the information map contains any filters, they can be used to restrict the amount of returned data. For the purpose of this example, only the first five observations are selected.

The following code uses the PRINT procedure to display information about the data items:

/* Print five observations of detailed data from the data that */
/* the information map references.                             */
proc print data=HR_Data."Employee Info"n (obs=5);
run;

title1 "Total salary for each division except Education and Publications";
title2 "and Host Systems Development";
proc print data=HR_Data."Employee Info"n
   (keep="Annual Salary"n Division 
    aggregate=yes 
    filter=(NOT("Education and Publications"n 
                OR "Host Systems Development"n)));
run;

Log for the PRINT Procedure

114  /* Print five observations of detailed data from the data that */
115  /* the information map references.                             */
116  proc print data=HR_Data."Employee Info"n (obs=5);
117  run;

NOTE: There were 5 observations read from the data set HR_DATA.'Employee Info'n.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           5.57 seconds
      cpu time            0.14 seconds

118
119  title1 "Total salary for each division except Education and Publications";
120  title2 "and Host Systems Development";
121  proc print data=HR_Data."Employee Info"n
122     (keep="Annual Salary"n Division
123      aggregate=yes
124      filter=(NOT("Education and Publications"n
125                  OR "Host Systems Development"n)));
126  run;

NOTE: There were 14 observations read from the data set HR_DATA.'Employee Info'n.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           4.78 seconds
      cpu time            0.09 seconds

Output from the PRINT Procedure

                                         The SAS System

                                                                 Identification    Dept_
              Obs    Jobcode    Location    Division                 Number        code

                1    FAC011       Cary      FACILITIES            333-88-1850       FAC
                2    TS0007       Cary      TECHNICAL SUPPORT     333-88-7366       TS0
                3    SAM009       Cary      SALES & MARKETING     301-97-8691       SAM
                4    ACT001       Cary      FINANCE               333-44-5555       ACT
                5    VID001       Cary      VIDEO                 333-78-0101       VID

                                                   Annual         Monthly
              Obs    Title                         Salary          Salary      Enddate

                1    LANDSCAPING SUPV             $28,000          $2,333            .
                2    TECH SUP ANALYST II          $32,000          $2,667            .
                3    MARKETING ANALYST            $52,000          $4,333            .
                4    TAX ACCOUNTANT I             $37,000          $3,083            .
                5    VIDEO PRODUCER               $25,400          $2,117            .

                   Total salary for each division except Education and Publications
                                    and Host Systems Development
 
                                                                  Annual
                             Obs    Division                      Salary

                               1    CALIFORNIA REGIONAL          $96,500
                               2    CONTRACTS                   $511,000
                               3    EXECUTIVE                   $973,000
                               4    FACILITIES                  $596,500
                               5    FINANCE                     $326,000
                               6    HUMAN RESOURCES             $824,500
                               7    INFORMATION SYSTEMS         $919,500
                               8    INTERNAL DATA BASE          $178,000
                               9    QUALITY ASSURANCE           $898,000
                              10    SALES & MARKETING         $1,254,500
                              11    SOFTWARE DEVELOPMENT      $2,348,000
                              12    TECHNICAL SUPPORT           $688,000
                              13    TEXAS REGIONAL              $918,000
                              14    VIDEO                       $238,400

Top of Page