topic Re: sas Math computation query in SAS Programming

sas Math computation query

dennis_oz — Thu, 10 Sep 2020 23:54:01 GMT

Hi All,

please can you advice to get sum in Want:

Want :

Channel item count sum

Commercial_Sales ItemA 1620 2611
Commercial_Sales ItemB 41 2611
Contact_Centre ItemA 147 2611
Contact_Centre ItemB 803 2611

Have:

data have;
input Channel :$30. item :$10. count 8.;
datalines;
Commercial_Sales ItemA 1620 
Commercial_Sales ItemB 41 
Contact_Centre ItemA 147 
Contact_Centre ItemB 803 
;
run;

Re: sas Math computation query

ChrisNZ — Fri, 11 Sep 2020 00:09:59 GMT

Like this?

proc sql;

create table WANT as

select *, sum(COUNT) as SUM

from HAVE;

Re: sas Math computation query

Shmuel — Fri, 11 Sep 2020 00:10:04 GMT

proc sql;
  select *, sum(count) as sum
  from have;
quit;