- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-19-2017 02:42 PM
(1029 views)
Getting error like
ERROR: Summary functions are restricted to the SELECT and HAVING clauses only.
proc sql;
select acc,
sum(amt) as tot_amt,
count(id1) as count1,
count(id2) as count2,
count(id3) as count3,
count(id4) as count4,
count(id5) as count5,
sum(calculated count1,calculated count2,calculated count3,calculated count4,calculated count5) as tot_id
from table
group by acc
run;
Each acct have 5 ids..some are blank.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Post your log. I'm not seeing what would cause that specific error.