topic Delete / cut text at the end of string in SAS Programming

Delete / cut text at the end of string

hhchenfx — Wed, 15 Feb 2017 03:21:28 GMT

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;

Re: Delete / cut text at the end of string

hhchenfx — Wed, 15 Feb 2017 03:21:44 GMT

I got it.
HC

Re: Delete / cut text at the end of string

ballardw — Wed, 15 Feb 2017 15:38:04 GMT

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.

Re: Delete / cut text at the end of string

hhchenfx — Thu, 16 Feb 2017 04:03:31 GMT

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;