Heel (DQ): add % of missing data for each data domain (Dx, Proc, Meas, Obs)

[vojtechhuser]

A paper by Kahn http://repository.academyhealth.org/egems/vol3/iss1/7/
outlines very nice 20 item list.

For item 13 bullet 1 - Achilles should add

• % of rows in drug exposure table mapped to concept 0 (not mapped) (perhaps even stratified by year)

and similarly for all other tables like Dx, Proc, Measurement and Observations

[vojtechhuser]

This can be done by query on analysis 401, rule 6 currently gives a warning but not "depth of the problem"

select analysis_id,sum(count_value) as cnt,'all' as row_type from achilles_results where analysis_id in (400,401,601) group by analysis_id
union
select analysis_id,count_value as cnt,'concept_0' as row_type from achilles_results where analysis_id in (400,401,601) and stratum_1 = 0
order by 1;

Chris, can you help me rewrite this SQL in MS SQL flavor so that a percentage can be computed
@chrisknoll

another issue is also asking for this.

[vojtechhuser]

Iris beta part is analyzing this

[alondhe]

Added in recent commits