https://communities.sas.com/t5/SAS-Programming/Error-in-count-function/m-p/377517#M90655 <P>Post your log. I'm not seeing what would cause that specific error.</P> Wed, 19 Jul 2017 18:54:32 GMT Reeza 2017-07-19T18:54:32Z https://communities.sas.com/t5/SAS-Programming/Error-in-count-function/m-p/377510#M90649 <P>Getting error like&nbsp;</P><P>ERROR: Summary functions are restricted to the SELECT and HAVING clauses only.</P><P>&nbsp;</P><P>proc sql;</P><P>select &nbsp;acc,&nbsp;</P><P>sum(amt) as tot_amt,</P><P>count(id1) as count1,<BR />count(id2) as count2,<BR />count(id3) as count3,<BR />count(id4) as count4,<BR />count(id5) as count5,<BR />sum(calculated count1,calculated count2,calculated count3,calculated count4,calculated count5) as tot_id</P><P>from table</P><P>group by acc</P><P>run;</P><P>&nbsp;</P><P>Each acct have 5 ids..some are blank.</P> Wed, 19 Jul 2017 18:42:30 GMT https://communities.sas.com/t5/SAS-Programming/Error-in-count-function/m-p/377510#M90649 Kalai2008 2017-07-19T18:42:30Z https://communities.sas.com/t5/SAS-Programming/Error-in-count-function/m-p/377517#M90655 <P>Post your log. I'm not seeing what would cause that specific error.</P> Wed, 19 Jul 2017 18:54:32 GMT https://communities.sas.com/t5/SAS-Programming/Error-in-count-function/m-p/377517#M90655 Reeza 2017-07-19T18:54:32Z