search

ccb-hms / nhanes-database

3 stars 4 forks source link

Translation error example #173

Closed deepayan closed 6 months ago

deepayan commented 6 months ago

A concrete example of translation error, to help with testing.

> phonto::nhanesQuery("SELECT SEQN, RFXSEAR FROM Raw.AUXAR_J where SEQN = '93706'")
   SEQN RFXSEAR
1 93706       1
2 93706       1
3 93706       2
4 93706       1
5 93706       1
6 93706       1
7 93706       1
> phonto::nhanesQuery("SELECT SEQN, RFXSEAR FROM Translated.AUXAR_J where SEQN = '93706'")
   SEQN   RFXSEAR
1 93706 Right Ear
2 93706 Right Ear
3 93706 Right Ear
4 93706 Right Ear
5 93706 Right Ear
6 93706 Right Ear
7 93706 Right Ear
nathan-palmer commented 6 months ago

Changing translation procedure to use NHANESA functionality