Keeping specific rows

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Keeping specific rows

Hi,

I'm trying to make a simple (not to me) data step action. I need to keep specific rows in my data set. This is an example - my data set looks like this:

SecurityTrialTimePrice
11134
11234
11432
11534
11733
12235
12334
12436
12639
121040
21180
21385
21581
21876
22277
22377
22477
22573
22976
221078

I would like to keep only the highlighted (red) rows. The logic is as follows: by "security" and by "trial" keep the entire row with the highest value of "time"

I appreciate any help on this code.

Thank you


Accepted Solutions
Solution
‎03-23-2014 08:28 PM
PROC Star
Posts: 7,360

Re: Keeping specific rows

If your data are already in the order shown in your example then the following code like the following could be used:

data want;

  set have;

  by Security Trial;

  if last.trial;

run;

View solution in original post


All Replies
Solution
‎03-23-2014 08:28 PM
PROC Star
Posts: 7,360

Re: Keeping specific rows

If your data are already in the order shown in your example then the following code like the following could be used:

data want;

  set have;

  by Security Trial;

  if last.trial;

run;

Occasional Contributor
Posts: 10

Re: Keeping specific rows

Thank you. Good to know about the "last.***" function in the data step.

☑ This topic is SOLVED.

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

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