Desktop productivity for business analysts and programmers

Date problem

Reply
N/A
Posts: 0

Date problem

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
SAS Super FREQ
Posts: 8,720

Re: Date problem

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
Ask a Question
Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation