By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Information Maps: Used All Over the SAS BI System
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
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
Last updated: 2013/08/21 at 8:00 AM
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

ai low code frameworks

AI Can Help Accelerate Development with Low-Code Frameworks

Data Analytics Helps Marketers Make the Most of Instagram Stories
What to Know Before Recruiting an Analyst to Handle Company Data
Tackling Bias in AI Translation: A Data Perspective
Data Ethics: Safeguarding Privacy and Ensuring Responsible Data Practices

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.

 

Tricia Aanderud August 21, 2013
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance
analyst,women,looking,at,kpi,data,on,computer,screen
What to Know Before Recruiting an Analyst to Handle Company Data
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai low code frameworks
Artificial Intelligence

AI Can Help Accelerate Development with Low-Code Frameworks

12 Min Read
data Analytics instagram stories
Analytics

Data Analytics Helps Marketers Make the Most of Instagram Stories

15 Min Read
analyst,women,looking,at,kpi,data,on,computer,screen
Analytics

What to Know Before Recruiting an Analyst to Handle Company Data

6 Min Read
data perspective
Big Data

Tackling Bias in AI Translation: A Data Perspective

9 Min Read

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

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

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

Sign in to your account

Lost your password?