select only the last rows for each id

[jkf91]

Hi all,

I have the data in the following format:

Subject     cum_count_x

1                    1

1                    2

2                    1

2                    2

3                    1

3                    2

3                    3

How do I select only the last rows (containing the total cum_sum value) of each subject? Basically, I want to create a new data set that looks like:

Subject     cum_count_x

1                    2

2                    2

3                    3

Thank you,

C

[art297 · Accepted solution]

You didn't indicate what the file name was, so I will call it "have" and the file you want "want".

data want;

  set have;

  by subject;

  if last.subject then output;

run;

[jkf91]

thank you!