Delete / cut text at the end of string

[hhchenfx]

Hi Everyone,

I have a variable of text "name" with very much randon lenght and rule.

I want to create a new variable that equal to the "name" with the last 3 character deleted.

So for the file below, the output should be:

va
subva
notsu
sas_conditio

Look around and I find the code here. Just want to make a new thread so other can use.

Thanks.

HHC

data have;
input name $;
datalines;
value
subvalue
notsure1
sas_condition12
run;

data want; 
set have;
 new=substr(name, 1, length(name)-3);
run;

[hhchenfx]

I got it.
HC

[ballardw]

Please provide details of your solution. Some may be searching for a solution to a similar problem and finding a thread markded as solved but with no solution doesn't help others later.

[hhchenfx · Accepted solution]

Actually I put the solution right in the original post.

But thank you for reminding me. I will make it clearer.

data have;
input name $;
datalines;
value
subvalue
notsure1
sas_condition12
run;

data want; 
set have;
 new=substr(name, 1, length(name)-3);
run;