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

SAS Information Map Studio: Get me a new Data Item, puhhleeze!

Submitted by on 2011-10-10 – 6:00 AM 3 Comments

When creating a new data item in SAS Information Map Studio, 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 (concatenate) functions in the Expression Editor makes this is an easy task.

There are three CAT functions available from the SAS Information Map Studio – Expression Editor.  Each of these functions has a slight difference that is useful in various situations. 

sas bi information map studio

For this example, you will learn how to use the CATX functions to create the Full name data item in three different ways:

  • Employee Name is the First Name and Last Name
  • Employee is the Last Name, First Name
  • Employee Code uses the Employee Number and Last Name

Using Functions with the SAS Information Map Studio

The CATX function does 3 things:

  • Concatenates two or more data items
  • Removes the white space at end of the character value
  • Allows you to set a delimiter (comma, space, and so on) between the data items

It’s one of the many SAS functions you can use when creating a new data item.  You can learn more about the SAS functions here. 

Create Data Item from Two Data Items 

For this data item, you want a space between the first name and last name.  When adding the code place a space between the quote marks.  The following example show how to create the new data item.

sas bi information map studio

Adding Space to Your Data Item

For this data item, you want a comma between the last and first names.  Place a comma in the quotes.  Also add a space after the comma otherwise the name will be like this:

LastName,FirstName

Here’s an example of how to code this item:

sas bi information map studio

Use Two Functions at Once

In the next screenshot, I have added another SAS function called UPCASE.  Sometimes there is a requirement for the last name to be in all capital letters.  By adding the UPCASE function around the  LastName data item, it will convert that data item to upper case letters.

You can also see that the function was selected from the Function list.

sas bi information map studio

Create Employee Code

For this data item, you are creating a code that has the employee number and the Last Name separated by an underscore. Place the underscore symbol between the quote marks to have it inserted between the data items.

sas bi information map studio

 

 

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.

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:

3 Comments »

  • Anonymous says:

    Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something.I think that you can do with some pics to drive the message home a bit, but instead of that, this is excellent blog.A fantastic read.I will definitely be back

  • Thanh says:

    Helpful details! I have been trying to find something such as this for some time now. Appreciation!

  • Emerson says:

    Awesome message, I really anticipate messages of your stuff.