INFOMAPS Procedure

Example 3: Aggregating a Data Item

The following example shows the aggregation of data item values using the AGGREGATION= option in the INSERT DATAITEM statement:

proc infomaps metauser="your-user-ID"
   metapass="your-password"
   metaserver="your-server-name"
   metaport=8561;

   new infomap "expression9"
      mappath="/Users/myUserID/My Folder";

   /* Make the table "Orion Star"."CUSTOMER_DIM" */
   /* accessible to the information map. */
   insert datasource sasserver="SASMain"
      table="Orion Star"."CUSTOMER_DIM";

   /* Specify the aggregation function using the AGGREGATION= option. */
   insert dataitem
     column="CUSTOMER_DIM".Customer_Age
     classification=measure
     aggregation=avg;

   save;

run;

The following window shows the results of running a query in SAS Information Map Studio using the information map that was created with the INFOMAPS procedure. You can see that the query generated from the information map calculates an average, which is displayed in the Results window.

Example information map with aggregation of data item values