BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jcabrera
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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

2 REPLIES 2
art297
Opal | Level 21

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;

jcabrera
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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