Merge and aggregate datasets: Difference between revisions

((summarizeSUMMARIZE (visit whereWHERE score>0.0) byBY {id}: {sumscore := sumSUM(score), avgscore := avgAVG(score)}) unionUNION

(extendEXTEND (patient {id} minusMINUS ((visit whereWHERE score>0.0) {id})): {sumscore := NaN, avgscore := NaN})) joinJOIN

(summarizeSUMMARIZE visit byBY {id}: {maxdate := maxMAX(date)} unionUNION

(extendEXTEND (patient {id} minusMINUS (visit {id})): {maxdate := DateUnknown()})) joinJOIN