Hi, I've formatted my dates to display at MONYY7. (Aug2016) . I expected the data to group together when I ran a proc means sum and grouped be the formatted variable but it doesn't. Is there a way to make it do so please?
Instead of by, try to use class for your date variable, and the proper format.
You have used the word which answers your own question:
"I've formatted my dates to display at MONYY7. (Aug2016)"
Formats merely display the underlying data differently, they do not change the underlying data. Hence you will still see the actual value of the data is number of days since a certain date (i.e. a SAS numeric date value), which is used when grouping.
As you haven't shown any test data or code, can I assume you have put the format statement in your means code - that might work. If not just put your data to a character variable as month year value, and then group on that.
Instead of by, try to use class for your date variable, and the proper format.
Thanks. Does exactly what I wanted now.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.