Home » Enterprise Guide

SAS BI Prompts: Gettin’ User Friendly

Submitted by on November 18, 2011 – 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 post!

Get the latest BI Notes post in your Inbox when a new post is released! Click here for free subscription. You email address is kept private and you can unsubscribe anytime. Go ahead ... join us!

Attending SESUG 2015?

If you are planning to attend SESUG 2015 in beautiful Savannah, Georgia on Sept 29 then join me for my talk about data visualization "How to be the MacGyver of Data Visualization"! I'll show you some cool ways to visualize data with SAS Visual Analytics as well as some traps to avoid.

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!