ccb-hms/nhanes-database

DB drops commas from Value Description

Opened this issue · 0 comments

See, e.g., https://wwwn.cdc.gov/Nchs/Nhanes/2001-2002/DEMO_B.htm#DMDBORN, which has value "Born in 50 US States or Washington, DC". In the DB, we have

> nhanesQuery("SELECT * FROM Metadata.VariableCodebook WHERE TableName = 'DEMO_B' and Variable = 'DMDBORN'")[1:4]
  Variable TableName CodeOrValue                      ValueDescription
1  DMDBORN    DEMO_B           1 Born in 50 US States or Washington DC
2  DMDBORN    DEMO_B           2                        Born in Mexico
3  DMDBORN    DEMO_B           3                        Born Elsewhere
4  DMDBORN    DEMO_B           7                               Refused
5  DMDBORN    DEMO_B           9                            Don't know
6  DMDBORN    DEMO_B           .                               Missing

Is this intended, perhaps due to a limitation in the DB? This is probably not a big deal, but will lead to minor mismatches with the non-DB versions of translated tables.