how to add with in year and company?

[aarony]

I have ned_1 which is a binary variable if

boardid       year     ned_1

1                  2000   0

1               2000     1

1               2001      1

1               2001     1

1               2002     0

1               2002    0

2            2000     0

2            2000     0

2           2001     1

3           2002    1

3          2002     1

i want to arrive at

boardid      year     ned_1

1                2000         1

1               2001          2

1               2002          0

2               2000     0    

2          2001          1

3          2002          2

how may i do this? thank you in advance!

[art297]

I would use proc summary:

proc summary data=have;

  var ned_1;

  by boardid year;

  output out=want (drop=_:) sum=;

run;

[Reeza]

It helps to provide the logic, so we don't have to make assumptions.

Assuming ned_1 in your want table is the sum of the ned_1 in the first table.

Look into proc means to summarize your information.

[Haikuo · Accepted solution]

proc sql;

  select boardid, year, sum(ned_1=1) as ned_1 from have

        group by boardid, year

;

quit;

Not tested.

Haikuo