topic Re: How can I only get the last row that is grouped by 2 variables? in SAS Programming

How can I only get the last row that is grouped by 2 variables?

aalluru — Wed, 30 Mar 2022 18:51:21 GMT

I have the following data:

ID Flag Date Details

1 N 1/1 abc

1 N 1/2 efg

1 Y 1/1 hij

2 N 1/3 lmo

This dataset is already sorted by ID, flag and date (ascending order) using proc sort. I want to now only output the last row in every ID, flag combination as follows:

ID Flag Date Details

1 N 1/2 efg

1 Y 1/1 hij

2 N 1/3 lmo

Re: How can I only get the last row that is grouped by 2 variables?

Tom — Wed, 30 Mar 2022 19:04:50 GMT

Just use BY group processing. You want the last one per ID FLAG group.

data want;
  set have;
  by ID Flag Date;
  if last.flag;
run;

Re: How can I only get the last row that is grouped by 2 variables?

aalluru — Wed, 30 Mar 2022 19:07:16 GMT

that was easier than I thought. Thanks!