Proc sql thresholdvalues

[Kiteulf]

Hi

How do I match the different values in on my main dataset

I want to match in the Number given that the DP_pct/score is over or below the thresholdvalues

DP_pct	Score	Number
0,05	523	0
0,1	523	0
0,2	523	0
1	523	0
0,05	541	0
0,1	541	100 000
0,2	541	200 000
1	541	300 000
0,05	561	100 000
0,1	561	200 000
0,2	561	300 000
1	561	400 000
0,05	615	500 000
0,1	615	600 000
0,2	615	800 000
1	615	1 000 000
0,05	1 000	700 000
0,1	1 000	800 000
0,2	1 000	1 000 000
1	1 000	1 000 000

[RW9 · Accepted solution]

You would first present test data in the form of a datastep using the code window (its the {i} above post are), following this guide if need be:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

You would then present example required output.

It is next to impossible to guess what you want from what you post.  I believe this has been mentioned a few times before.