BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have one problem when querying..when I take a date and time field and convert the output to month and year (JUN2007) . The problem I have is when I roll up the month year field I have trouble because it wants to not group when I sum up a number. Would you know what is happening or where I could get some advice on this problem?



Example of what is happening.

Jun2007 500

Jun2007 5000

Jun2007 10000
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi,
You do not mention whether you are grouping in a query or whether you are using an EG task.

Your best bet for help with this question is to contact Tech Support: http://support.sas.com/techsup/contact/index.html

cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1 reply
  • 848 views
  • 0 likes
  • 2 in conversation