I want know how can I make this procesure.

[yubihan]

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.

[BrunoMueller · Accepted solution]

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;

[yubihan]

Thank you!!