topic subtract numbers from character in SAS Studio

subtract numbers from character

RebeccaJW — Mon, 15 Apr 2019 21:50:16 GMT

Hello,

I am asked to subtract the numeric portion of a character variable using input(), substrn() or scan().

Thank you in advance for your help!

This is what the original character look like.This is the expected result.

Re: subtract numbers from character

Tom — Mon, 15 Apr 2019 21:52:59 GMT

Subtract them from what?

Show your actual data, not photographs of your data.

Show what you have tried.

Re: subtract numbers from character

Reeza — Mon, 15 Apr 2019 21:53:53 GMT

How do those align? How does 10.5[1] become 15.7 or is that just a generic example?

If you're just trying to remove the [1] section, use SCAN and INPUT.

num_var = input(scan(char_var, 1, "[]"), best32.);

@RebeccaJW wrote:

Hello,

I am asked to subtract the numeric portion of a character variable using input(), substrn() or scan().

Thank you in advance for your help!

This is what the original character look like.This is the expected result.

Re: subtract numbers from character

RebeccaJW — Mon, 15 Apr 2019 22:13:16 GMT

Thank you so much! It works!