Selection Process based on criteria

ilikesas — Sun, 10 Jan 2016 04:36:20 GMT

Hi,

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

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:

Thank you!!!

Re: Selection Process based on criteria

PGStats — Sun, 10 Jan 2016 04:53:40 GMT

proc sql;

create table want as

select *

from have

group by stock

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

quit;