## Selection Process based on criteria

Solved
Super Contributor
Posts: 441

# Selection Process based on criteria

Hi,

suppose I have a data of stocks with dates and prices:

 Stock Date Price A 2009 10 A 2010 12 B 2007 20 B 2008 22 B 2009 23 C 2009 6 C 2010 6

What I would like to do is to have a selection process each individual stock is either entirely deleted or left based on 2 criteria:

The max year should be greater or equal to 2010 and the max price should be greater or equal to 8.

For the above data only stock A passes the 2 criteria,

so the "want" table should be:

 Stock Date Price A 2009 10 A 2010 12

Thank you!!!

Accepted Solutions
Solution
‎01-10-2016 12:19 AM
Posts: 4,935

## Re: Selection Process based on criteria

proc sql;

create table want as

select *

from have

group by stock

having max(year) >= 2010 and max(price) >= 8;

quit;

PG

All Replies
Solution
‎01-10-2016 12:19 AM
Posts: 4,935

## Re: Selection Process based on criteria

proc sql;

create table want as

select *

from have

group by stock

having max(year) >= 2010 and max(price) >= 8;

quit;

PG
☑ This topic is solved.