Help using Base SAS procedures

select only the last rows for each id

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

select only the last rows for each id

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


Accepted Solutions
Solution
‎08-15-2011 06:22 PM
PROC Star
Posts: 7,366

select only the last rows for each id

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;

View solution in original post


All Replies
Solution
‎08-15-2011 06:22 PM
PROC Star
Posts: 7,366

select only the last rows for each id

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;

Contributor
Posts: 44

select only the last rows for each id

thank you!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 159 views
  • 1 like
  • 2 in conversation