Hi--
I have column with a bunch of records that indicate a rating level. The rating level is manually entered.
Column Responses look like this:
-2LOW
12,very high
12-veryhigh
3,moderate
9,high- final risk rating very high
0-Low
risk score 11
LOW
I would like to try and clean up the responses. Is there a way to make a conditional format that does something like this?:
If anywhere in the cell, there is a -2 = ‘Case Risk Rating: Low -2’
If anywhere in the cell, there is a 12 = ‘Case Risk Rating: Very High 12’
If anywhere in the cell, there is a 3 = ‘Case Risk Rating: Moderate 3’
If anywhere in the cell, there is a 9 = ‘Case Risk Rating: High 9’
If anywhere in the cell, there is a 0 = ‘Case Risk Rating: Low 0’
If anywhere in the cell, there is a 11 = ‘Case Risk Rating: Very High 11’
If anywhere in the cell, there is a LOW = ‘Case Risk Rating: Low’
99=SKIPPED
Thanks!
Since there are some values that overlap (e.g., -2LOW, 0-Low, and LOW) is the order you listed the order of prescedence that you want applied?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.