BookmarkSubscribeRSS Feed
Kalai2008
Pyrite | Level 9

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
Reeza
Super User

Post your log. I'm not seeing what would cause that specific error.

sas-innovate-wordmark-gradient-background 3.pngSAS Innovate

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1324 views
  • 0 likes
  • 2 in conversation