How to arrange date variable in order after Proc Transpose

[Tom]

PROC TRANSPOSE creates the new variables as it sees values for them.  Since you are doing the transpose BY some variable the only way to insure it will create them in the order you want is to make sure the first BY group has ALL of the dates. So please re-read and study the code that @data_null__ posted.  That will insure that all of the dates exist in the first group and so that PROC TRANSPOSE will create them in the order you want.

Also if you are going to use dates as text, such as in the names of variables, then ALWAYS use year-month-day order so the character strings will sort in proper date order.  Note that this also has the advantage of not confusing your European friends into wondering how you could possible have a date with month number of 31.