BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
HugoR
Fluorite | Level 6

Hello

 

Is there any function that allows me substract information rigth to left data?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

1. DONT YELL. ALL CAPS IS YELLING AND YELLING IS RUDE, ESPECIALLY WHEN ASKING FOR HELP. 

2. You show us what you have but not what you need. 

3. Your vague comment about zeros makes me suspect you want to remove leading zeroes. If that's the case, convert the character variable to a numeric variable.

 

If not, post what you have and what you want, as text, not an image. When you post an image, if you want code as help, are you expecting us to type out your data to test it? Help us help you by making the problem clear and as easy to follow as possible. Please consider taking some more time to illustrate your problem. 

View solution in original post

6 REPLIES 6
SASKiwi
PROC Star

Your question is not clear but I suggest you check out the REVERSE function to see if it fits your needs. If you want further help please provide an example of what you want.

HugoR
Fluorite | Level 6
HELLO SASKIWI THE INFORMATION IS NOT EQUAL, I NEED TO EXTRACT FROM RIGHT TO LEFT AND DO NOT INCLUDE THE ZERO THAT ARE TO THE RIGHT
HELP.png
Reeza
Super User

Probably but what does subtract mean? Are you referring to the mathematical operation? Or a string operation? Or something else.

 

As indicated your question is vague, please post some example data and what you expect output. Otherwise, I suggest googling: SAS Functions by Category 9.4

 

One of the first results will be the documentation which lists functions by category and you can find one or several that will help you accomplish what you need. 

HugoR
Fluorite | Level 6
>HELLO REEZA THE INFORMATION IS NOT EQUAL, I NEED TO EXTRACT FROM RIGHT TO LEFT AND DO NOT INCLUDE THE ZERO THAT ARE TO THE RIGHT
HELP.png
Reeza
Super User

1. DONT YELL. ALL CAPS IS YELLING AND YELLING IS RUDE, ESPECIALLY WHEN ASKING FOR HELP. 

2. You show us what you have but not what you need. 

3. Your vague comment about zeros makes me suspect you want to remove leading zeroes. If that's the case, convert the character variable to a numeric variable.

 

If not, post what you have and what you want, as text, not an image. When you post an image, if you want code as help, are you expecting us to type out your data to test it? Help us help you by making the problem clear and as easy to follow as possible. Please consider taking some more time to illustrate your problem. 

HugoR
Fluorite | Level 6
Thanks Reeza for your recommendations And I apologize for the caps, I did not know that rude.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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

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
  • 6 replies
  • 1839 views
  • 7 likes
  • 3 in conversation