DATA Step, Macro, Functions and more

Delete / cut text at the end of string

Accepted Solution Solved
Reply
Super Contributor
Posts: 412
Accepted Solution

Delete / cut text at the end of string

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;

 


Accepted Solutions
Solution
‎02-15-2017 11:04 PM
Super Contributor
Posts: 412

Re: Delete / cut text at the end of string

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;

View solution in original post


All Replies
Super Contributor
Posts: 412

Re: Delete / cut text at the end of string

I got it.
HC
Super User
Posts: 11,343

Re: Delete / cut text at the end of string

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.

Solution
‎02-15-2017 11:04 PM
Super Contributor
Posts: 412

Re: Delete / cut text at the end of string

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 144 views
  • 0 likes
  • 2 in conversation