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 » Enterprise Guide

SAS BI Prompts: Gettin’ User Friendly

Submitted by on 2011-11-18 – 6:20 AM One Comment

When creating prompts in SAS Business Intelligence or SAS Enterprise Guide, the value the database or your code uses to populate the field may not be user-friendly.  Certainly you want your user community to think you are that cool BI developer tucked away in cubical B7-2.  Hey I think you can even get yourself a cool black leather jacket and some boots if you use prompting tips like this one.

BI Prompts from Losers

I’ve talked before about creating cascading prompts and date prompts but those were more of an overall discussion. Here’s an example of something that would be a common way to express the values for a chart output.  At your site – everyone may understand the terminology so I’m just using these values as an example.  Feel free to leave some comments telling me how you’ve used it.


sas bi Change the Prompt Name for the User #1


Building Cool Prompts

In the Prompt Type and Values pane, modify the Formatted (Displayed) Value for the variables.  Double-click in the field and add the value you want the user to see.  No code changes are need – this only controls what the prompt has in the drop-down (see above).  The code still expects to receive the Unformatted value (HBAR or VBAR).

This is one of those little touches that makes your work stand out from others (i.e Rock Star!!).  Use it where it makes sense.

Last Tip: Double-check your spelling if you are spell-check-dependent like someone whose post you may be reading.   No one  wants their output to be a Pig Chat.  

sas bi Change the Prompt Name for the User

 Keep your prompts easy to understand to ensure your end users can follow along effortlessly.  That’s how you become a Prompt Rockstar!

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

SAS Consultant at Zencos
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 over 10 years of SAS programming experience. Contact her for assistance with your next project.

Tags: ,

One Comment »

  • Bobbi says:

    Major lover from this blog, a large number of your articles or blog posts have seriously helped me out. Looking towards posts!