topic Re: Dynamically Sorting a Data Column in SAS VA in SAS Visual Analytics

Dynamically Sorting a Data Column in SAS VA

DavidPhillips2 — Wed, 24 Oct 2018 13:56:57 GMT

In SAS VA 7.4. I have a report that uses parameters to dynamically populate a checkbox. Without dynamically populating the checkbox list I could simply do a custom sort on the data column. Is there a way to sort the values of the dynamic checkbox list?

Few SAS users use parameters so to help them understand:

Dropdown1 is populated by a lookup table.

The values of Checkboxlist1 change when the value of Dropdown1 is populated via parameters.

I want to sort the values of Checkboxlist1 to be custom sorted based off of a separate table or logic structure when the selected value of Checkboxlist1 changes.

Re: Dynamically Sorting a Data Column in SAS VA

FredrikE — Tue, 16 Oct 2018 07:42:25 GMT

HI!

I don't really follow you here, do you have one checkbox, a list with checkboxes, a table with data...etc. 🙂

Where do you do the sort?

Do you mean that the checkbox list should be sorted everytime a selection is made?

//Fredrik

Re: Dynamically Sorting a Data Column in SAS VA

DavidPhillips2 — Tue, 16 Oct 2018 09:07:22 GMT

A user selects a value from a drop down list. Based on the selection a checkboxlist is populated.

Re: Dynamically Sorting a Data Column in SAS VA

FredrikE — Tue, 16 Oct 2018 12:25:58 GMT

I tried to add a listbox and a checkboxlist.

Added an interaction and sorted the list in descending order.

When i select a value from the drop down the list is populated and still sorted in descending order.

I also tried with a custom sort and the sorting was still there even when I selected values from the drop down.

You say you use parameters, is that in a filter expression?

Don't you use interactions?

I might be way out here 🙂

//Fredrik

Re: Dynamically Sorting a Data Column in SAS VA

DavidPhillips2 — Wed, 24 Oct 2018 13:59:31 GMT

Dropdown1 is populated by a lookup table.

The values of Checkboxlist1 change when the value of Dropdown1 is populated via parameters.

I want to sort the values of Checkboxlist1 to be custom sorted based off of a separate table or logic structure when the selected value of Checkboxlist1 changes.