Hi
I am trying to sum using proc sql but I get the following on the log window
proc sql;
519 create table limbs3 as
520 select
521 id,
522 sum(sum(normal, alo2, call3, red4, wound5, callswe6,
523 swound7, sswe8, swound_sswe9)) as score
524 FROM limbs_sum;
ERROR: Function SUM requires a numeric expression as argument 1.
ERROR: Function SUM requires a numeric expression as argument 2.
ERROR: Function SUM requires a numeric expression as argument 3.
ERROR: Function SUM requires a numeric expression as argument 4.
ERROR: Function SUM requires a numeric expression as argument 5.
ERROR: Function SUM requires a numeric expression as argument 6.
ERROR: Function SUM requires a numeric expression as argument 7.
ERROR: Function SUM requires a numeric expression as argument 8.
ERROR: Function SUM requires a numeric expression as argument 9.
ERROR: The SUM summary function requires a numeric argument.
525 group by id;
526 quit;
what am I doing wrong?
Thanks for your help
... View more