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

[rgreen33]

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

[rogerjdeangelis]

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

[rgreen33]

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