topic Splitting a character variable in Viya in SAS Visual Analytics

Splitting a character variable in Viya

Rik96 — Wed, 23 Oct 2024 08:59:30 GMT

Hello,

I would like to split a character variable in SAS Viya 4 containing last names. In many cases the variable contains the last name of both partners seperated by a '-'. However, we only want the first last name. The variable looks something like this: 'xxxxxx - xxxxx'. I have tried the functions substring and getword in Viya 4, but they do not seem to do the trick. This is because many last names consist out of multiple words and both functions are not well suited for this.

Does someone have any idea how to tackle this in Viya?

Thanks in advance.

Rik

Re: Splitting a character variable in Viya

LinusH — Wed, 23 Oct 2024 09:18:00 GMT

SCAN function works for this kind of scenarios:

SAS Help Center: SCAN Function

Re: Splitting a character variable in Viya

Rik96 — Wed, 23 Oct 2024 09:38:37 GMT

I see I mentioned the wrong environment. I mean Visual Analytics. The scan function is not part of this.

Re: Splitting a character variable in Viya

pathew — Wed, 23 Oct 2024 10:00:47 GMT

In Visual Analytics you can use the FindChar / FindString functions instead, in contrast to the FindWord function you can specify the separator(s) this way. For your example this could work:

IF (FindChar(LastName, '-') > 0) return Substring(LastName, 1, FindChar(LastName, '-'))

ELSE LastName

Re: Splitting a character variable in Viya

Rik96 — Wed, 23 Oct 2024 10:53:51 GMT

Thanks! This worked