BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

Information Maps: Used All Over the SAS BI System

Submitted by on 2013-08-20 – 8:57 AM

You can make information maps available to SAS Enterprise Guide and SAS Add-In for MS Office, which might make is easier for some SAS BI users to reach the data.  It also makes your  information map more useable for various purposes.  The import method for SAS Enterprise Guide and the Add-In work very similar but I’m going to show how to do it with SAS EG.  

The biggest difference is SAS EG generates code that you can copy into a stored process or maybe even a batch process.  Why recreate the wheel when the data you want is already assemble in a ready-to-go package?

Accessing a SAS Information Map from a Client

From SAS Enterprise Guide, open the information map by selecting File > Open > Information Map.  If you don’t know the name of the map, use the Search SAS Folders tab.  Type an * in the All or part of a name field and select Search.  Then click the map you want to import.  

info_map_in_sas_eg_02

 

After you select the map, the following window appears.  It allows you to select the items you want, set up any filter, and then chose the name and storage location.  The dataset is created in the Process Flow area.

info_map_in_sas_eg_04

 

Here’s what the result looks like – that’s right just a dataset that you can use in a stored process or perhaps another task.
  info_map_in_sas_eg_05

Reviewing the Code

The good thing about SAS Enterprise Guide is that it generates the code to import the map.  You can learn more about the INFOMAP LIBNAME engine in the BASE SAS 9.3 Guide to Information Maps.   Here’s a quick overview to help you understand what is happening behind the scenes, so to speak!

Step 1: Use a LIBNAME to Access the Map

It’s a basic LIBNAME statement which indicates to use an info map (sasioime) and gives it a name (_egimle). You may need to set different options based on what you might be doing.  Read more in the documentation for more options. 

/* assign the library using the INFOMAPS library engine */
libname _egimle sasioime
mappath="/Shared Folder/Maps" /*Only folder specified not map name*/
aggregate=yes
metacredentials=no
PRESERVE_MAP_NAMES=YES;

Step 2 – Import the Dataset

The data is imported using a SAS data step.   The dataset name in the metadata is Dataloss, which is the name used (_egimle.’dataloss’n).

data WORK.dataloss (label='Selected Data from dataloss');
sysecho "Extracting data from information map";
 length 
Businesstype $ 3
Businesssubtype $ 7
Affected 8
Arrestcount 8;

set _egimle."dataloss"n /*Here's map name! */
(keep= Businesstype Businesssubtype Affected Arrestcount
filter=((Affected > 50))
);
run;
/* clear the libname when complete */
libname _egimle clear;

Let EG Write the Code!

Some developers don’t like to let SAS Enterprise Guide write code for them. This is one case that I find it’s useful – sure I could have studied the documentation to learn all the ends and outs – but it sure is easier to let the software do the trial run.  If I can get a draft of what I want to do, then I can embellish the details later.  

Also, if it doesn’t work then I don’t have to drive myself crazy trying to figure out what I did wrong.  Instead I can focus on a wrong connection, a permissions issue, or something like that.

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

Never miss a BI Notes post!

Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.
The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: , ,