Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Drop-down List - Can you show a description instead of a code?

Reply
Contributor
Posts: 45

Drop-down List - Can you show a description instead of a code?

I am new to SAS and just getting started with VA.  When building a dashboard, I want to place a drop-down list in my "report prompt" section.  This drop-down list will be linked to a "List of Values" data source (a table that I have in LASR from Oracle).  This "List of Values" contains fields for Description and Code.  I would like to display the Description in the drop-down list, but let the Code be used for my actual filtering, as I the data source for my main table (which will be filtered by the drop-down) contains only the Code.  Is this possible?

 

Thanks,

Ricky

Valued Guide
Posts: 505

Re: Drop-down List - Can you show a description instead of a code?

If the table from Oracle is realtively small <1TB you might want to looka at

 

1. proc pmenu

2. proc fsedit

3. window

4. %window

 

In addition thare are some nice open source 'windowing' R and Python tools that can interface with SAS

 

Contributor
Posts: 45

Re: Drop-down List - Can you show a description instead of a code?

So, is this not possible from within the GUI interface of Visual Analytics Designer?  I'm not sure that my users will understand SAS coding for a while.

 

Thanks,

Ricky

Post a Question
Discussion Stats
  • 2 replies
  • 83 views
  • 0 likes
  • 2 in conversation