Keeping the last observations of individuals in a given year (in panel data)

master_kim — Fri, 26 May 2023 16:47:46 GMT

Hello everyone.

I have panel data, and I have some individuals who have multiple observations in the same year.

What I want to do is that I want to keep the last observation of those individuals with multiple observations in the same year.

Visually, I want something like this… (I thought this would show better what I wanna do)

Id data year -> Id data year

1 2 2009 1 3 2009

1 3 2009 1 2 2010

1 2 2010 2 1 2009

2 1 2009 2 3 2010

2 2 2010

2 3 2010

I was trying to use command like: "Data …. ; Set ….; by ID year; if last.ID; run;", but this would only leave last observation of the individual of the last year (assuming that I sorted by ID and year) and erase the previous year. I was wondering if you have a suggestion or idea to this issue..

Thank you very much for your help!

Re: Keeping the last observations of individuals in a given year (in panel data)

ballardw — Fri, 26 May 2023 16:56:27 GMT

Almost there, assuming correct sort order:

Data …. ; Set ….; by ID year; if last.Year; run;",

Re: Keeping the last observations of individuals in a given year (in panel data)

master_kim — Fri, 26 May 2023 17:37:25 GMT

thank you very much! that was a perfect answer!

topic Re: Keeping the last observations of individuals in a given year (in panel data) in SAS Enterprise Guide

Keeping the last observations of individuals in a given year (in panel data)

Re: Keeping the last observations of individuals in a given year (in panel data)

Re: Keeping the last observations of individuals in a given year (in panel data)