topic Replacing the nth character in string with a specified value in New SAS User

Replacing the nth character in string with a specified value

jmniotis — Mon, 19 Aug 2019 15:56:46 GMT

Hello!

I have a field on a table where I want to replace the 8th digit with a 1 in the character string for each of the rows. The string is consistently 12 characters long. Currently that 8th digit is always a zero.

Anybody know how I can accomplish this task?

I'm using SAS 7.1. We'll be upgrading to 8.1 in the near future.

Thanks so much in advance!

Jonathan

Re: Replacing the nth character in string with a specified value

Reeza — Mon, 19 Aug 2019 16:02:52 GMT

Use the SUBSTR() function.

substr(varName, 8, 1) = '1';

@jmniotis wrote:

Hello!

I have a field on a table where I want to replace the 8th digit with a 1 in the character string for each of the rows. The string is consistently 12 characters long. Currently that 8th digit is always a zero.

Anybody know how I can accomplish this task?

I'm using SAS 7.1. We'll be upgrading to 8.1 in the near future.

Thanks so much in advance!

Jonathan

Re: Replacing the nth character in string with a specified value

PeterClemmensen — Mon, 19 Aug 2019 16:14:32 GMT

Welcome to the SAS Community 🙂

You can use the SUBSTR (left of 😃 Function