sas Math computation query

[dennis_oz]

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;

[ChrisNZ · Accepted solution]

Like this?

proc sql;

  create table WANT as

  select *, sum(COUNT) as SUM

  from HAVE;

[Shmuel]

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