Merge and aggregate datasets: Difference between revisions
m
→{{header|Prolog}}
(→{{header|SAS}}: Refactor SQL) |
|||
Line 864:
summaryScores(4004,Wirth,15.4,7.7)
false.</pre>
Implemented using XSB Prolog (which allows for user-defined aggregates):
<lang prolog>:- import bagMax/2, bagCount/2, bagSum/2, bagReduce/4 from aggregs.
:- import julian_date/7, date_string/3 from iso8601.
Line 883:
patient(Id,Lastname),
julian_date(LastDateNumber, Y, M, D, _, _, _),
summaryScores(Id, Lastname, Sum, Mean) :-
| |||