The 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="myUserID"
     metapass="myPassword"
     metaserver="myip.us.mycompany.com"
     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.

[untitled graphic]

Top of Page