SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Selection Process based on criteria

Accepted Solution Solved
Reply
Super Contributor
Posts: 441
Accepted Solution

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
Respected Advisor
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

View solution in original post


All Replies
Solution
‎01-10-2016 12:19 AM
Respected Advisor
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.

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

Discussion stats
  • 1 reply
  • 217 views
  • 0 likes
  • 2 in conversation