01-30-2017 08:21 AM
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?
01-30-2017 09:32 AM
If the table from Oracle is realtively small <1TB you might want to looka at
1. proc pmenu
2. proc fsedit
In addition thare are some nice open source 'windowing' R and Python tools that can interface with SAS
01-30-2017 09:45 AM
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.