topic Re: Substr function last caracters in SAS Programming

Substr function last caracters

SASdevAnneMarie — Tue, 12 Jan 2021 12:18:33 GMT

Hello Experts,

I have the data like this : LM7613369000000091800505984.

I would like to have the 11 last caracters.

My code is

NO1=substr(Num,11,-1)

But it doesn't work.

Could you help me please ?

Thank you !

Re: Substr function last caracters

PeterClemmensen — Tue, 12 Jan 2021 12:21:21 GMT

Do this

data _null_;
   str = "LM7613369000000091800505984";
   last11 = substr(str, length(str)-10);
   put last11 =;
run;

Result:

last11=91800505984

Re: Substr function last caracters

ballardw — Tue, 12 Jan 2021 12:24:14 GMT

Doesn't work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the <> to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the <> icon or attached as text to show exactly what you have and that we can test code against.

Consider this example:

data example;
   x='LM7613369000000091800505984';
   y=substr(x,length(x)-10);
run;

And think about why -10 yields 11 characters.