In SAS Information Map Studio, you may notice that some data items have similar names with a numeric after the name. When you use the data items from various tables they may use similar names. It can be difficult for the end user to understand what the...
Read more »
You can use the Expression Editor and some SAS functions to create new data items from existing data items. Here’s how to create some common Date data items. SAS functions make it easy to perform actions and all you need is a variable and som...
Read more »
When creating a new data item, you might want to combine two or more data fields to make one. For instance, you want to create the data item Full Name from First Name and Last Name data items. Using the SAS CAT functions makes this is an easy task. There are three CAT functions...
Read more »
In Information Map Studio, you can easily set the default measure for a data item in the Properties area.
(1) Use the Default aggregate function drop-down to select the default. When you set this item to AVERAGE, the data item defaults to Average t...
Read more »
When a data item is created in Information Map Studio, the defaults are assigned for classifications and aggregations. If the data item is a percentage, this defaults may not make sense. For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage. When the data item was imported, the...
Read more »
SAS EBI is comprised of several applications. Here is a quick overview: Make Data SAS OLAP Cube Studio Build OLAP cube using SAS datasets. SAS Information Map Studio Build information maps from SAS datasets and OLAP cubes. SAS Enterprise Guide Connect to SAS datasets, RDBMS, and even Excel spreadsheets SAS Add-In for Microsoft Office...
Read more »
As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore. Here is a list of free sources that I have found that can help as you learn and want to challenge yourself. Simple Data Tables Here are some sources...
Read more »