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

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

Karine_Ehn — Thu, 31 Jan 2019 10:53:18 GMT

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

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

BrunoMueller — Thu, 31 Jan 2019 14:08:14 GMT

You can use the Substring operator:

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

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

Karine_Ehn — Thu, 31 Jan 2019 15:04:36 GMT

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...

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

Basl — Thu, 31 Jan 2019 15:13:05 GMT

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

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

BrunoMueller — Thu, 31 Jan 2019 15:13:47 GMT

You use the Data Options menu like below:

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

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

Karine_Ehn — Thu, 31 Jan 2019 16:51:23 GMT

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

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

FredrikE — Fri, 01 Feb 2019 09:58:41 GMT

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

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

Karine_Ehn — Fri, 01 Feb 2019 15:51:03 GMT

It solved the problem! KUDOS