Dynamically Sorting a Data Column in SAS VA

[DavidPhillips2]

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.

[FredrikE]

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

[DavidPhillips2]

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

[FredrikE]

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

[DavidPhillips2]

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.