Calculate firm age

dapenDaniel — Mon, 27 Jan 2020 19:33:11 GMT

Hello,

I have a dataset that lists the beginning year and end year of companies. The sample dataset is below

FirmID Beginning End

1001 1998 2005

1002 1982 2000

I would like to generate a panel data. The data is below.

FirmID Year age

1001 1998 1

1001 1999 2

...

1001 2005 8

1002 1982 1

...

1002 2000 19

What program do I need to use? Thanks.

Re: Calculate firm age

novinosrin — Mon, 27 Jan 2020 19:40:49 GMT

data have;
input FirmID    Beginning              End;
cards;
1001          1998                  2005
1002          1982                  2000
;

data want;
 set have;
 do year=Beginning to end;
  age=year-Beginning+1;
  output;
 end;
 drop Beginning End;
run;

topic Re: Calculate firm age in New SAS User

Calculate firm age

Re: Calculate firm age