I am trying to create a way to get the default selection in a listbox to be the latest month. As time goes on this obviously changes. This seems like it should be easy but I just cant figure it out. Can anyone help? Thanks
Hey guys, One example we have is do it on the data side so basically the dataset is amended each month. We have a example of this... which works reasonabily well , however when you want to use the functionality of difference between this period and last period I imagine its going to break. This is something im trying to look into at the moment. So sorry not really a answer but feeling your pain... Cheers Rob
I think its doable, can you try below option and let me know if it works for you.
First make your dropdown value an required field. ( Go to the properties tab and navigate to your dropdown control and check the Required check box )
That will make you mandatory to select the field in the dropdown. Then right click your dropdown go to the "sort frequency" option and change it to descending.
let me if it works for you.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.