Desktop productivity for business analysts and programmers

Using date formats to group observations in PROC MEANS

Accepted Solution Solved
Reply
Occasional Contributor N_C
Occasional Contributor
Posts: 7
Accepted Solution

Using date formats to group observations in PROC MEANS

[ Edited ]

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?


Accepted Solutions
Solution
‎02-08-2017 08:15 AM
Esteemed Advisor
Posts: 6,702

Re: Date formats

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Esteemed Advisor
Esteemed Advisor
Posts: 7,251

Re: Date formats

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.

Solution
‎02-08-2017 08:15 AM
Esteemed Advisor
Posts: 6,702

Re: Date formats

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor N_C
Occasional Contributor
Posts: 7

Re: Date formats

Thanks.  Does exactly what I wanted now. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 406 views
  • 1 like
  • 3 in conversation