Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Information Maps: Used All Over the SAS BI System
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Analytics > Information Maps: Used All Over the SAS BI System
AnalyticsBig DataBusiness Intelligence

Information Maps: Used All Over the SAS BI System

Tricia Aanderud
Tricia Aanderud
5 Min Read
SHARE

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.  

Contents
Accessing a SAS Information Map from a ClientReviewing the CodeStep 1: Use a LIBNAME to Access the MapStep 2 – Import the DatasetLet EG Write the Code!

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.  

More Read

Social Metrics: Measuring Success
Barcelona: Do more with your data
5 Big Predictions for Business Intelligence in 2017
Rise of Social CRM and how IT & BPO Companies can Profit from it
PAW/TAW – The Most Important Influencers in Analytics

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.

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

 

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Image
Big DataSocial Data

Social Data and Scaling Your Mobile Ad ROI

6 Min Read
Image
Big DataCulture/LeadershipData ManagementPolicy and Governance

CERN: A Case Study in “Big Science” Data Management

6 Min Read

How Mobile BI Will Change Sales in the Next Decade

4 Min Read

Analytics run amok?

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?