topic substr the last few letters in SAS Procedures

substr the last few letters

iusing — Wed, 16 Nov 2011 16:05:36 GMT

I would like to know how to get the final few letters of a string?

art297 — Wed, 16 Nov 2011 16:26:08 GMT

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;

Linlin — Wed, 16 Nov 2011 16:34:12 GMT

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;