I am working on a SAS viya 3.5 job. I am using the tasks UI xml to define the inputs. The first input is organization number. I want to set the next input, sector, to the organizations sector from the same table. But I still want the user to be able to override the default value in case the information is dated. I now have a filter that filters out and return the correct sector, but I can't change the value. Is there a way to only let the filter determine the default value for each organization number, but still be able to change sector?
One way to solve this would be to have two boxes, one that filters out the default, and another optional box with an unfiltered list of all sector that overrides the macro value if present. But ideally, I want the value to just be a default that ban be overridden.
