In Survey Solutions--and in practice for data producers--a value label set is applied to only one variable at a time (even if that value set is reusable category in Designer).
Even if it might be more advantageous to have a single value set applied to multiple variables, data producer conventions may be the more traditional one-value-set-one-label approach. For that convention, there' no good tooling to identify where a value set is applied to more than one variable.
Implementation ideas
Identify value sets via r(names) returned by label dir
Get a list of variable(s) using each value set via ds, has(vallabel label_name)
Store value set name in a macro when the length of the list from the prior step is greater than 1
Return list of value labels with more than 1 variable usage in r(names) (or other conventional name)
Problem
In Survey Solutions--and in practice for data producers--a value label set is applied to only one variable at a time (even if that value set is reusable category in Designer).
Even if it might be more advantageous to have a single value set applied to multiple variables, data producer conventions may be the more traditional one-value-set-one-label approach. For that convention, there' no good tooling to identify where a value set is applied to more than one variable.
Implementation ideas
r(names)
returned bylabel dir
ds, has(vallabel label_name)
r(names)
(or other conventional name)