how to add with in year and company?

Solved
Frequent Contributor
Posts: 102

how to add with in year and company?

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!

Accepted Solutions
Solution
‎04-24-2014 12:19 PM
Posts: 3,167

Re: how to add with in year and company?

proc sql;

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

group by boardid, year

;

quit;

Not tested.

Haikuo

All Replies
PROC Star
Posts: 8,167

Re: how to add with in year and company?

I would use proc summary:

proc summary data=have;

var ned_1;

by boardid year;

output out=want (drop=_ sum=;

run;

Super User
Posts: 23,776

Re: how to add with in year and company?

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.

Solution
‎04-24-2014 12:19 PM
Posts: 3,167

Re: how to add with in year and company?

proc sql;

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

group by boardid, year

;

quit;

Not tested.

Haikuo

🔒 This topic is solved and locked.