topic Re: Keep only first/last observation for EACH year of EACH company in SAS Programming

Keep only first/last observation for EACH year of EACH company

shafayat — Wed, 30 Jan 2019 02:11:22 GMT

Can anyone please give me some clue how I can keep the last observation of "EACH" year of a specific company in a weekly panel data in order to annualize it?

If I create year variable from the date and use last.year command, it only retains the last observation for the company, NOT the last for "EACH" year.

I tried sorting the data by year and then permno instead of by permno and then year, but had no luck; it then keeps only 1 observation from each year and deletes other years' data for other companies.

Thanks.

Re: Keep only first/last observation for EACH year of EACH company

PGStats — Wed, 30 Jan 2019 03:06:54 GMT

1) Create a year variable

2) Sort by permno and year

3) then, in a data step do

data newData;

set myData; by permno year;

if first.year or last.year;

run;

Re: Keep only first/last observation for EACH year of EACH company

Astounding — Wed, 30 Jan 2019 03:31:49 GMT

You will have to show your work. It is entirely possible that you are using the correct tools, but using them incorrectly. So post the program that isn't working.

Re: Keep only first/last observation for EACH year of EACH company

shafayat — Wed, 30 Jan 2019 04:41:28 GMT

This is what I was doing. I was puzzled why it did not work. I don’t even know what changed but after quite a while it started working. Thanks though.