Using date formats to group observations in PROC MEANS

[N_C]

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?

[RW9]

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.

[Kurt_Bremser · Accepted solution]

Instead of by, try to use class for your date variable, and the proper format.

[N_C]

Thanks.  Does exactly what I wanted now.