topic Re: For several firms I have several people (directors) for 6 different years. in Statistical Procedures

For several firms I have several people (directors) for 6 different years.

jbanghoj — Mon, 30 Jun 2014 12:44:59 GMT

I have a problem in SAS which is the following:

For several firms I have several people (directors) for 6 different years.

I wish to pick one person from each firm, who has all six years of observations and perform a regression analysis on these people.

So I need help to get one person from each firm with all sex years of observation.

I have a firmID, DirectorID and a Year variable (from 2002-2004 and from 2006-2008)

I you need more detail on the problem please let me know!

Thanks!

Re: For several firms I have several people (directors) for 6 different years.

Kurt_Bremser — Mon, 30 Jun 2014 13:15:56 GMT

proc sort data=have (keep=director year) out=inter nodupkey;

by director year;

run;

data want (keep=director);

set inter;

by director;

retain control;

if first.director then control = ' '; * six blanks;

substr(control,year-&start,1) = 'X';

if last.director and control = 'XXXXXX' then output;

run;

Set macro variable start to a suitable start year.

Re: For several firms I have several people (directors) for 6 different years.

jbanghoj — Tue, 01 Jul 2014 09:09:49 GMT

Thanks alot for the reply.

I do not see how this will help me pick one director from each firm as firmID is deleted from the sample.

How do I set the macro variable start to a suitable start year?

I have observations from the years 2002-2004 and 2006-2008 - 6 years in total.

Thank you once again!

Re: For several firms I have several people (directors) for 6 different years.

RW9 — Tue, 01 Jul 2014 09:20:52 GMT

Can I suggest you post some test data and required output. Its quite difficult to guess the circumstances. At a guess you could get those directors with six years by:

proc sql;

select DIRECTORID

into :MYLIST separated by '","'

from (select distinct DIRECTORID,

count(YEAR) as CNT

from HAVE)

where CNT = 6;

quit;

This list could then be used to filter tha dataset,

data want;

set have;

where directorid in ("&MYLIST.");

run;

Re: For several firms I have several people (directors) for 6 different years.

Kurt_Bremser — Tue, 01 Jul 2014 10:53:38 GMT

Then you basically have to include the firmID in the by statements, extend the control string and compare for the right pattern(s) at the end.