I have a list of survey questions and am quite struggling to convert certain questions to CDM format. Can you please help me with one such survey question listed below
"As far as you know, which of the family members were affected with heart disease
a) Father - 1) Yes 2) No 3) Do not know — User chose “Yes”
b) Mother - 1) Yes 2) No 3) Do not know — User chose “No”
c) Sister - 1) Yes 2) No 3) Do not know — User chose “Yes”
d) Brother - 1) Yes 2) No 3) Do not know —User chose “No”
e) Son - 1) Yes 2) No 3) Do not know – User chose “Do not Know”
f) Daughter - 1) Yes 2) No 3) Do not know – User chose “No”
Another example of such survey question is as shown below
So, in the above case of heart disease, Am I right to understand that there will be multiple rows (6 rows) for the same patient because this question allows user to select multiple choices. let’s take father option as example
I have a concept id for the question (ex:123) and concept ids for “Father” and “Yes”.
I understand that observation_concept_id will be 123 (concept id for the question) but for response the value_concept_id will be the concept_id for “Yes” or Concept_id for “Father”? Which one should I choose?
Or should I choose the value_concept_id for Father and in the value_as_numeric I should just key in as “1” for Yes.
Might be an elementary question but require your guidance on how to approach this?
I understand the options could have been made easier to just have Father, Mother, sister, daughter, son etc but since they have captured the response this way, can you please help me how can this be done?
Any help from the other forum users is also appreciated