topic Re: 1) how to keep the highest number of directors within the same annual report date of a company? 2) how to average the number of directors within the same annual report date of a company? in SAS Procedures

1) how to keep the highest number of directors within the same annual report date of a company? 2) how to average the number of directors within the same annual report date of a company?

aarony — Thu, 17 Apr 2014 21:02:18 GMT

BoardID 324	BoardName FIFTH THIRD BANCORP	Ticker FITB	ISIN US3167731005	mktcap 16216	annual report date Dec 2010	#of directors 1.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2010	12.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2010	13.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2010	5.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2011	1.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2011	13.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2011	14.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2011	5.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2012	1.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2012	13.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2012	14.0000
324	FIFTH THIRD BANCORP	FITB	US3167731005	16216	Dec 2012	5.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Current	1.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Current	10.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Current	11.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Current	2.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Dec 1999	2.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Dec 1999	11.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Dec 1999	13.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Dec 1999	5.0000
428	ABBOTT LABORATORIES	ABT	US0028241000	54433	Dec 2000	2.0000

For example, for the annualreportdate of “dec 2010” for boardID 324 (row 1-4) I see 1,12,13,5 as number of directors. I wanted to just keep the row with 13 (the greatest number). how can i do this and how do i do this for all the firms? or each report date?

Could you kindly provide your guidance?

1) how to keep the highest number of directors within the same annual report date of a company?

2) how to average the number of directors within the same annual report date of a company?

Re: 1) how to keep the highest number of directors within the same annual report date of a company? 2) how to average the number of directors within the same annual report date of a company?

Reeza — Thu, 17 Apr 2014 23:01:28 GMT

proc sort data=have out=have;

by board_id annualReportDate descending numberDirectors;

data want;

set have;

by boarded annualreportdate;

if first.annualreportdate;

run;

proc sort data=have out=have;

by board_id annualReportDate ;

var numberDirectors;

output out=want2 mean(numberDirectors)=avgnumdirectors;

run;

Re: 1) how to keep the highest number of directors within the same annual report date of a company? 2) how to average the number of directors within the same annual report date of a company?

Peter_C — Fri, 18 Apr 2014 07:26:08 GMT

This type of query is a natural fit for proc sql

Within the company/year group you derive the max # and mean with code like

Proc sql ;

Create table summary_list as

select boardID, ticker, AnnualReportDate

, max( numDir) as maxDir

, mean( numDir) as avgNdir

from your.data

group by 1,2,3

;

quit ;

Re: 1) how to keep the highest number of directors within the same annual report date of a company? 2) how to average the number of directors within the same annual report date of a company?

Jagadishkatam — Fri, 18 Apr 2014 14:07:01 GMT

The below code by proc means will accomplish both the requirements

proc means data=have mean max nway;

class BoardID boardName Ticker ISIN mktcap date ;

var value;

output out=means max=max mean=mean;

run;

Thanks,

jag