Dear Team
Make value set number unique and numbering can occur automatic when creating value sets.
Currently you can accidentally assign 2 different value labels to the same number say=1, the system does not warn and this very dangerous during analysis you can have wrong statistics
Value sets
-
- Posts: 1801
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Value sets
This is actually deliberate. If you do this, you'll note that when you run your program (if it's a tabulation application), you'll have an .ERR file that warns about overlapping value sets. The reason that it is deliberate is that you might want to create a value set like this for age:
Everyone, 0 - 120
Newborns, 0
Minors, 0 - 17
Adults, 18 - 120
Elderly, 65 - 120
The same value appears in multiple values, but makes sense because the values overlap (elderly are a kind of adult). Sometimes it is not something that you would like, as you have discovered, but it's supported because it can be useful.
Everyone, 0 - 120
Newborns, 0
Minors, 0 - 17
Adults, 18 - 120
Elderly, 65 - 120
The same value appears in multiple values, but makes sense because the values overlap (elderly are a kind of adult). Sometimes it is not something that you would like, as you have discovered, but it's supported because it can be useful.