How can I customise a character data item in SAS Visual Analytics

[Karine_Ehn]

I am trying to customize a character data item in Visual Analytics, so that the first two characters of the data are hidden, like Right( x,8) function for 10 character variable. Want to do it directly in VA without changing the source data. Doable?

INPUT: 

DOIT_TODAY

OUTPUT:

IT_TODAY

Kind Regards, 

Karine

[BrunoMueller]

You can use the Substring operator:

Substring('Facility City'n, 3, 99999999)

[Karine_Ehn]

Many Thanx! But where should I apply this operator? All that I can do for my data item is shown in attached pict and non of this features allows you to use anu custom operators...

[Basl]

You can apply this operator by making a calculated item. In there you can specify your variables and use this operator

[BrunoMueller]

You use the Data Options menu like below:

You can then choose the operator Substring and fill in the fields.

[Karine_Ehn]

Pretty streight foward 🙂 Big Thanx, however I recieve empty fields by applying Substring('Sdeliverycode'n, 3, 99999999)... Any thoughts on what might cause this?

[FredrikE · Accepted solution]

Hi!

I don't know the reason for you getting missing values but one thing you really need to be careful with is the length (3:rd argument) you want to keep.

It should never be longer than the original string, i.e if the original string is 30 character you should define the substring like:

substr([var],3,28).

We have had a long journey finding why our LASR-server got memory shortage and shut down.

The reason was that we used longer substring than the original string, the higher value we used the faster the server went down 🙂

Anyhow, you should get a value from your substring, can you try a short version first, just to see that it works?

//Fredrik

[Karine_Ehn]

It solved the problem! KUDOS