| OHDSI Home | Forums | Wiki | Github |
Question, what is the best way to use ATLAS to find a measurement that has a value? To say it another way, I want to be able to find all records for a given measurement that have a recorded numeric value.
Is this the best way? Doesn’t feel right.
Tagging my friend @Chris_Knoll because I feel like we have talked about this in the past and I cannot remember what you told me.
In the 2.15 release, we will have options to look for ‘is any of’ or ‘is not any of’ for the Value as Concept fields of measurement and observation. This will let you do things such as look for non-null values or null values. I believe that’s what you were remembering.
In the case of numbers, the UI only gives you the option to search by a range, and therefore you can do as above to look for a large range of values, and this will have the effect of returning measurements with a non-null value as number. However, there’s no way to search for measurements where the value as number is null There doesn’t seem to be a good use case for returning the measurements with null value as number, but your approach will get you ‘measurements that have a value as number populated’.
