BookmarkSubscribeRSS Feed
Ryujin
Calcite | Level 5
I seem to be having trouble using the group by with Proc SQL e.g
in SQL if i wanted to take a datetime and group by day rather then the full datetime I would do:

CONVERT(varchar(10), DateTime, 101)

When I format to DateTime9.0 in SAS and then try to group by that same column it shows it as DateTime9.0 but won't group by the same.
2 REPLIES 2
Flip
Fluorite | Level 6
If I understand you correctly take the date from the datetime by
datevar = datepart(datetimevar)
and group by that.
Ryujin
Calcite | Level 5
Thank you.
I just had the datepart in Select Statement and then referenced the alias in the group by

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2157 views
  • 0 likes
  • 2 in conversation