topic Re: Drop-down List - Can you show a description instead of a code? in SAS Visual Analytics

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

rgreen33 — Mon, 30 Jan 2017 13:21:52 GMT

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

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

rogerjdeangelis — Mon, 30 Jan 2017 14:32:00 GMT

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

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

rgreen33 — Mon, 30 Jan 2017 14:45:19 GMT

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