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;
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;
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.
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.