https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-problem/m-p/5043#M1603 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?<BR /> <BR /> <BR /> <BR /> Example of what is happening.<BR /> <BR /> Jun2007 500<BR /> <BR /> Jun2007 5000 <BR /> <BR /> Jun2007 10000 Thu, 11 Oct 2007 11:45:33 GMT deleted_user 2007-10-11T11:45:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-problem/m-p/5043#M1603 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?<BR /> <BR /> <BR /> <BR /> Example of what is happening.<BR /> <BR /> Jun2007 500<BR /> <BR /> Jun2007 5000 <BR /> <BR /> Jun2007 10000 Thu, 11 Oct 2007 11:45:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-problem/m-p/5043#M1603 deleted_user 2007-10-11T11:45:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-problem/m-p/5044#M1604 Hi,<BR /> You do not mention whether you are grouping in a query or whether you are using an EG task.<BR /> <BR /> Your best bet for help with this question is to contact Tech Support: <A href="http://support.sas.com/techsup/contact/index.html" target="_blank">http://support.sas.com/techsup/contact/index.html</A><BR /> <BR /> cynthia Thu, 11 Oct 2007 14:57:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-problem/m-p/5044#M1604 Cynthia_sas 2007-10-11T14:57:22Z