BookmarkSubscribeRSS Feed
jmniotis
Calcite | Level 5

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

2 REPLIES 2
Reeza
Super User

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
Tourmaline | Level 20

Welcome to the SAS Community 🙂 

 

You can use the SUBSTR (left of 😃 Function

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2737 views
  • 1 like
  • 3 in conversation