Merge and aggregate datasets: Difference between revisions

m
(→‎{{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, _, _, _),
date_stringdate_converter('YYYY-MM-DD'LastDate, date(Y,M,D), LastDate).
 
summaryScores(Id, Lastname, Sum, Mean) :-
136

edits