topic Re: Extract from a code in a field the last only three characters in SAS Visual Analytics

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

PaulTHR — Wed, 23 Jun 2021 15:42:04 GMT

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

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

Sam_SAS — Wed, 23 Jun 2021 15:59:11 GMT

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#n1x1svvabdfnrdn1cwiiwbx86l4l

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.

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

PaulTHR — Thu, 24 Jun 2021 11:37:20 GMT

Thanks very much - that will do for me.

Thanks