Subset data by id each week in most recent year

erinlee — Thu, 26 Jan 2023 21:25:25 GMT

Hi! I'm trying to subset some data to one row per id per week (currently is multiple rows/id/week). I want to keep the row associated with the latest date. Event date just corresponds to if the event occurred in 2021 (2) or before (1). Please help! Simple question but I'm super stuck! Thanks in advance!

Have:

week	id	year	event_date
1	1	2015	1
1	1	2016	1
1	1	2021	2
2	1	2015	1
2	1	2016	1
2	1	2021	2
3	1	2015	1
3	1	2016	1
3	1	2021	2
1	2	2015	1
1	2	2016	1
1	2	2017	1
2	2	2015	1
2	2	2016	1
2	2	2017	1
3	2	2015	1
3	2	2016	1
3	2	2017	1

Want:

week	id	year	event_date
1	1	2021	2
1	2	2017	1
2	1	2021	2
2	2	2017	1
3	1	2021	2
3	2	2017	1

Re: Subset data by id each week in most recent year

maguiremq — Tue, 31 Jan 2023 13:20:58 GMT

Here you go:

data have;
infile datalines delimiter = '	';
input week id year event_date;
datalines;
1	1	2015	1
1	1	2016	1
1	1	2021	2
2	1	2015	1
2	1	2016	1
2	1	2021	2
3	1	2015	1
3	1	2016	1
3	1	2021	2
1	2	2015	1
1	2	2016	1
1	2	2017	1
2	2	2015	1
2	2	2016	1
2	2	2017	1
3	2	2015	1
3	2	2016	1
3	2	2017	1
;
run;

proc sort data = have;
	by week id year;
run;

data want;
	set have;
	by week id;
	if last.id then output;
run;

Hopefully didn't miss something - let me know if I did.

topic Re: Subset data by id each week in most recent year in SAS Programming

Subset data by id each week in most recent year

Re: Subset data by id each week in most recent year