Replacing the nth character in string with a specified value

[jmniotis]

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

[Reeza]

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

---

[PeterClemmensen]

Welcome to the SAS Community 🙂 

You can use the SUBSTR (left of 😃 Function