topic Re: SAS compute a column in SAS Programming

SAS compute a column

dennis_oz — Wed, 09 Sep 2020 11:51:43 GMT

Hi All,

Kindly request you to help me to approach the below problem.

I have Channel , Item and Count. I want to get the sum of all count , i.e 2611 and then divide by each count to get weights . So weights is 1620/2611 = 62.05% .

channel	item	count	weights
Commercial_Sales	ItemA	1620	62.05%
Commercial_Sales	ItemB	41	1.57%
Contact_Centre	ItemA	147	5.63%
Contact_Centre	ItemB	803	30.75%
		2611

Below is the data

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 compute a column

novinosrin — Wed, 09 Sep 2020 12:05:50 GMT


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

proc sql;
create table want as
select *, count/sum(count) as weights format=percent10.2
from have;
quit;

Re: SAS compute a column

ballardw — Thu, 10 Sep 2020 17:38:03 GMT

Just to provide one of the alternate possibilities:

proc freq data=have noprint; 
  tables channel*item/list out=want(rename=( percent=weights)) ;
  weight count;
run;