I am currently working on a project where I would like to know the different measurements/lab tests that a person with specific condition should have underwent? I am not from healthcare background.so, your inputs would be helpful
I understand not all patients with condition A would have gone through the required measurement test. But what I would like to know is the list of measurement / lab tests for each condition? This is to find a way to handle missing values
what are all the possible measurements/lab tests for T2DM? What are the measurements/lab tests that he has actually underwent for T2DM? in this I will be able to identify MACR, MNACR etc
what are all the possible measurements/lab tests for cancer? What measurement tests did he actually undergo?
Once I have this,then I might be able to know about MACR, MNACR etc
Is there anyway in Atlas or SQL approach that I can use to get this info? I am sure it’s a common problem in EHR data analysis and you would have handled this. Can you share your experience of handling this in simplest way as possible?