Error in group by

anandmgjsa — Sun, 02 May 2021 11:21:45 GMT

Hi,

I am getting error in group by ; the error is esyntax error expecting gt lt get let ! !! <= >= and othe such conditionals.

My code is :

proc sql;

select clnt_seg_beo_code, count(*) as count

from beo

group by month clnt_seg_beo_code

order by count;

quit;

Please help...

Re: Error in group by

sbxkoenk — Sun, 02 May 2021 11:31:07 GMT

Hello,

I think you are missing a comma in your group by statement:

group by month , clnt_seg_beo_code

But please post the LOG next time you're posting a question where code is producing errors.

Cheers,

Koen