I don’t think what you are looking for is published. However we can discern something from the merit scholarship numbers reported in CDS. I’ve looked at these for quite a few colleges, and usually the merit aid numbers for freshmen vs. all students are similar enough that you would expect the renewal rates to be very high.
Interestingly, Texas A&M shows a quite noticeable difference:
These numbers, if consistent from year to year, would suggest that at least 20% of students end up losing their merit scholarships.
A more typical case is Tulane, where the drop off is not so noticeable: