topic I want know how can I make this procesure. in SAS Procedures

I want know how can I make this procesure.

yubihan — Mon, 24 Mar 2014 01:38:34 GMT

There are three variables. company_code, year, count.

code year count Sum_count

10 2000 1 1

10 2001 . .

10 2002 1 1

10 2002 1 2

10 2003 1 1

10 2003 1 2

10 2003 1 3

20 2000 . .

20 2000 1 1

I wnat know the code how can I make Sum_count variable.

Sum_count is the sum of count(by code, year).

If you help me I will really appreciate about it.

My english is not good. I'm sorry.

Re: I want know how can I make this procesure.

BrunoMueller — Mon, 24 Mar 2014 02:57:59 GMT

You can make use of BY group processing and the SUM statement. See sample below:

data have;
 infile cards dlm=","; 
 input
  code : $8.
  year : 4.
  count : 8.
  sum_count : 8.

 ;
cards; 
10,2000,1,1
10,2001,.,.
10,2002,1,1
10,2002,1,2
10,2003,1,1
10,2003,1,2
10,2003,1,3
20,2000,.,.
20,2000,1,1
; 

data want;
 set have;
 by code year;
 if first.year = 1 then do; 
  sumCount2 = 0; 
 end; 

 sumCount2 + count;

 if missing(count) = 1 then do; 
  call missing(sumCount2);
 end; 
run;

Re: I want know how can I make this procesure.

yubihan — Mon, 24 Mar 2014 04:22:29 GMT

Thank you!!