Performance : Same output but different running time

In the first case, most variables are listed in the by statement.

In the second case, most variables are listed in the table statement.

The first proc freq is twice as fast as the second one. But one also have to add the time needed upfront to sort the data upfront.