Solved: Insert character at a specific position in a string - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Insert character at a specific position in a string

Posted 11-15-2017 06:51 PM (31508 views)

Hello,

Let's say I have a string variable with the value "ABCD". How do I insert a 'K' between first and second characters so that the output is: AKBCD?

I tried the following but it's not working:

substr(string,1,0) = 'K';

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

PROC Star

Re: Insert character at a specific position in a string

Posted 11-15-2017 07:02 PM (33711 views) | In reply to torvyle

First step: make sure your variable has a length of $5 or longer. Otherwise you need to assign the new string to a new variable.

data want;

set have;

var = cat( substr(var, 1, 1), 'K', substr(var, 2) );

run;

View solution in original post

1 REPLY 1

PROC Star

Re: Insert character at a specific position in a string

Posted 11-15-2017 07:02 PM (33712 views) | In reply to torvyle

First step: make sure your variable has a length of $5 or longer. Otherwise you need to assign the new string to a new variable.

data want;

set have;

var = cat( substr(var, 1, 1), 'K', substr(var, 2) );

run;