Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.
Only need to show enough records to allow us to perform the actions you need.
Since your "predicted" values have no column headings or description any match with the other data is going to rely on a lot of guessing. You should also provide that data in the forum of a data step. Then identify which variables in the "predicted" data are to be used to match the collected data. I don't see a D0 in the collected data so you need to describe how that relates to the collected data.
In this case, you need to provide details as to which variables are used for what. You seem to have potentially 7 columns at least that might be used to identify groups but I am not sure which ones you intend or how.
Note that typically using a correct format for a date, time or datetime variable in a procedure like Means or Summary will allow you to group by that
Click image to register for webinar
