ccb-hms/nhanes-database

Translation error example

Closed this issue · 1 comments

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

Changing translation procedure to use NHANESA functionality