topic select only the last rows for each id in SAS Procedures

select only the last rows for each id

jkf91 — Mon, 15 Aug 2011 22:16:50 GMT

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,

art297 — Mon, 15 Aug 2011 22:22:17 GMT

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 — Tue, 16 Aug 2011 00:06:47 GMT

thank you!