Hello there, I recently get stuck on how to do data aggregation, any input would be appreciated. The table I would like to do aggregation has multiple lines of info for users with different IDs . I would like to summarize the data into only one line of all desired info for each member. However, different rules in choosing the right value for different variables makes it hard for me. Example: Original table and desired outcome for the table is listed below (only one member is shown here): ID Name DOB Event1 Time1-A Time1-B Event2 Time2-A Time2-B Event3 Time3-A Time3-B Time3-C 123 JaneD ABC CCC 1/1/2017 1/3/2017 . . . . . . . 345 JaneD ABC NNN 3/3/2017 3/7/2017 . . . QQQ 4/3/2017 3/5/2017 3/9/2017 456 JaneD ABC . . . NNN 11/26/2016 2/9/2017 NNN 5/17/2017 4/7/2017 5/20/2017 to: Name DOB Event1 Time1 Event2 Time2 Event3 Time3 JaneD ABC CCC 1/3/2017 NNN 2/9/2017 QQQ 4/3/2017 Rules are: Event123 has to be selected based on the priority of CCC>QQQ>NNN . TimeABC etc. have to match Event and always choose the max value between A&B . Event Category overrule the max value of time. I tried proc summary but it won't always have the right match between Event and max time. Can anyone help on what aggregation method might be useful in summarizing info when too many variables are involved? Thanks!
... View more