Extract from a code in a field the last only three characters

[PaulTHR]

I am looking  to extract from a code in a field the last only three characters - am trying to do this in SAS® Data Studio - Prepare Data.

Using data prep from SAS Viya 3.5

Code in the field can look something like this      265265414TGA

And I want to extract/include only the last 3 characters TGA

I dont want to code this in if possible rather use the options available

Any suggestions - thanks

[Sam_SAS · Accepted solution]

Hello,

You can do this directly in VA by creating a calculated item with the Substring() operator. If the length of the value is not always the same, you can use GetLength() to determine the length of the value.

Those operators are documented here:

https://go.documentation.sas.com/doc/en/vacdc/v_008/vareportdata/p0dovqqp325peyn1dpijpxxmwj83.htm#n1...

So to get the last three characters from the "Name" column you would do something like,

Substring('Name'n, ( GetLength('Name'n) - 2 ), 3)

I'm sure this can also be done in Data Studio, but I can't tell you offhand how to do it.

[PaulTHR]

Thanks very much - that will do for me.

Thanks