I have to ask because it is a frequent problem with "dates". Is your date value an actual SAS date valued variable? This means that when you run proc contents on the data set or examine the variable properties the variable is Numeric and (usually) has a date format such as DATE9. , mmddyy10 or similar assigned.
If so then you assign a format that would have the month first such as WORDDATE and on the class statement for date use the order option formatted:
class date / order=formatted;
format date worddate18. ;
Provide data if that doesn't work. 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 {i} icon or attached as text to show exactly what you have and that we can test code against.
Unless you have removed a lot of stuff from your code the () in the table statement you show aren't doing much of anything
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.