In a Visual Analytics report in SAS VIYA 3.5, I have a drop down box to select the date for which to show the data. By default, I want to show the current situation, i.e. the last date present in the data. In the settings for a drop down box, there is an "Initially select first item" check box, but no option to initially select the last, nor an option to sort in reverse order. The solution suggested in different forums is to change the sort order of the data item used in the drop down in the in data pane. However that only works with so called "categorical" variables and SAS VA does not see dates as categorical variables. Does anyone know a workaround? For completeness: a picture in the data pane, date variables are shown with a calendar icon (In this case the date is calculated from a time stamp. That is why there is a calculator in the icon too.) Categorical variables are shown with a tree legged symbol. The context menu for categorical variables has a Custom sort option. That for dates not.
... View more