DB drops commas from Value Description
Opened this issue · 0 comments
deepayan commented
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.