I would like to know how to get the final few letters of a string?
You could always use substr using the length function to get the variable's starting point. e.g.:
data want;
set sashelp.class;
last3chars=substr(name,length(name)-2);
run;
You could always use substr using the length function to get the variable's starting point. e.g.:
data want;
set sashelp.class;
last3chars=substr(name,length(name)-2);
run;
If you want last n letters then you should start from length(of your variable)-n+1.
data want_last_2;
input AA $;
newaa=substr(aa,length(aa)-1);
cards;
sdfgh
nhdsadfg
cedsas
oiugdbah
;
proc print;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.