Hello @sasecn,
@sasecn wrote:
I tried to use catx (scan(v1, 4, '-'), scan(v1, 5, '-')).
You just forgot the first argument of the CATX function, the delimiter:
catx('-', scan(v1, 4, '-'), scan(v1, 5, '-'))
If the number of hyphens in V1 was not limited to four, you could nest SUBSTRN and FIND function calls, but make sure that at least three hyphens are present. In PROC SQL:
select v1, case when countc(v1,'-')>=3
then substrn(v1,find(v1,'-',find(v1,'-',find(v1,'-')+1)+1)+1)
else ' '
end as want
... View more