topic Re: add a 0 within the character in SAS Programming

add a 0 within the character

simonqin — Sat, 27 Mar 2021 08:59:18 GMT

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.

Ksharp — Sat, 27 Mar 2021 11:01:41 GMT

data have;
length x $ 20;
x='110011001';
y=substr(x,1,6)||'0'||substr(x,7);
run;

sbxkoenk — Sat, 27 Mar 2021 13:36:00 GMT

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

Have a nice day,

Koen