Help using Base SAS procedures

Proc sql thresholdvalues

Accepted Solution Solved
Reply
Contributor
Posts: 53
Accepted Solution

Proc sql thresholdvalues

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

Accepted Solutions
Solution
‎01-16-2018 06:55 AM
Super User
Super User
Posts: 9,599

Re: Proc sql thresholdvalues

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.

View solution in original post


All Replies
Solution
‎01-16-2018 06:55 AM
Super User
Super User
Posts: 9,599

Re: Proc sql thresholdvalues

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.

☑ This topic is solved.

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

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