BookmarkSubscribeRSS Feed
simonqin
Fluorite | Level 6

Hi,

 

I am working on the health dataset and try to add a '0' value within all the ID number.

 

such as 

 

original ID      New ID

110011001     1100110001

110012001     1100120001

......

 

I want to know whether it has a syntax regarding to this.

2 REPLIES 2
Ksharp
Super User
data have;
length x $ 20;
x='110011001';
y=substr(x,1,6)||'0'||substr(x,7);
run;
sbxkoenk
SAS Super FREQ

On top of the suggestion by @Ksharp ...

For more extensive / detailed info about 

"Inserting a substring into a SAS string"

, see:

 

Inserting a substring into a SAS string
By Leonid Batkhan on SAS Users
February 15, 2021

Inserting a substring into a SAS string - SAS Users

 

Have a nice day,

Koen

 

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
  • 2 replies
  • 788 views
  • 0 likes
  • 3 in conversation