cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gabnash
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: PROC SQL using GROUP BY and ORDER BY together

by Calcite | Level 5 in SAS Procedures
‎05-14-2014 08:15 AM
‎05-14-2014 08:15 AM
This was the actual code that got the error: PROC SQL;     Create Table z1_Cta_TY_v3_1 as             (   SELECT working_month,    , company    , room    , route2    , Destination    , Origin    , Work_area    , A_Week_Ending    , B_Week_Ending    , SUM(Hours_TY)    , SUM(Hourss_LY)   FROM work.z1_Cta_TY_v2_1   GROUP BY 1,2,3,4,5,6,7,8,9   ORDER BY 1,2,3,4,5,6,7,8,9 desc ) ;            RUN; Note the closing paren is after the ORDER BY group. The error was as follows: 298          GROUP BY 1,2,3,4,5,6,7,8,9 299          ORDER BY 1,2,3,4,5,6,7,8,9 desc              -----              79 300      );          -          22          200 ERROR 79-322: Expecting a ). ERROR 22-322: Syntax error, expecting one of the following: ;, ','. ERROR 200-322: The symbol is not recognized and will be ignored. ... View more

PROC SQL using GROUP BY and ORDER BY together

by Calcite | Level 5 in SAS Procedures
‎05-14-2014 05:50 AM
‎05-14-2014 05:50 AM
I have a piece of code that looks like this - without the right parenthesis after the GROUP BY clause, the ORDER BY clause generates a syntax error. Is this a fault? I couldn't find any mention of this in the SAS 9.3 manuals. PROC SQL;     Create Table z1_Cta_TY_v3_1 as             (   SELECT working_month,    , company    , room    , route2    , Destination    , Origin    , Work_area    , A_Week_Ending    , B_Week_Ending    , SUM(Hours_TY)    , SUM(Hourss_LY)   FROM work.z1_Cta_TY_v2_1   GROUP BY 1,2,3,4,5,6,7,8,9)   ORDER BY 1,2,3,4,5,6,7,8,9 desc ;            RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links