cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jimbarbour
Meteorite | Level 14 jimbarbour
Meteorite | Level 14

Re: Help Needed

Posted 07-28-2021 03:41 PM (1676 views)  |   In reply to Rhino84

Did you try my code?  See my first response, above.

 

Here are the results.  Isn't this what you want?

 

Jim

jimbarbour_0-1627501271469.png

 

Rhino84
Fluorite | Level 6 Rhino84
Fluorite | Level 6

Re: Help Needed

Posted 07-28-2021 03:57 PM (1671 views)  |   In reply to mkeintz
This worked Finally. Thank you all.
0 Likes
Reeza
Super User Reeza
Super User

Re: Help Needed

Posted 07-28-2021 04:02 PM (1668 views)  |   In reply to Rhino84
If you ever have multiple rates, ie 300 & 500 in a record this will break though. So verify your data.
0 Likes

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • ‎07-27-2021 05:56 PM
  • 6936 views
  • 8 likes
  • 4 in conversation