topic how to add with in year and company? in SAS Procedures

how to add with in year and company?

aarony — Thu, 24 Apr 2014 16:09:08 GMT

I have ned_1 which is a binary variable if

boardid year ned_1

1 2000 0

1 2000 1

1 2001 1

1 2002 0

2 2000 0

2 2001 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 — Thu, 24 Apr 2014 16:17:09 GMT

I would use proc summary:

proc summary data=have;

var ned_1;

by boardid year;

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

run;

Reeza — Thu, 24 Apr 2014 16:17:19 GMT

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 — Thu, 24 Apr 2014 16:19:29 GMT

proc sql;

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

group by boardid, year

;

quit;

Not tested.

Haikuo