Page 1 of 1
@uniquevals with option to exclude
Posted: Wed Nov 16, 2016 2:06 pm
by chester
I have an alpha series called group. I'd like all the unique values in 'group' EXCLUDING blanks.
Is there any option that I can use to achieve this?
Code: Select all
svector uniquegroups =@uniquevals(group)
list = @wjoin(uniquegroups)
Re: @uniquevals with option to exclude
Posted: Wed Nov 16, 2016 3:28 pm
by EViews Gareth
There is not, you'll have to manually remove it.
Re: @uniquevals with option to exclude
Posted: Wed Nov 16, 2016 3:52 pm
by EViews Matt
If you merely want to remove the extra space in the final string, you could use the following quick-and-dirty workaround:
Code: Select all
list = @wjoin(@wsplit(@wjoin(uniquegroups)))
It's not efficient, but it is concise.
Re: @uniquevals with option to exclude
Posted: Thu Nov 17, 2016 7:27 am
by chester
If you merely want to remove the extra space in the final string, you could use the following quick-and-dirty workaround:
Code: Select all
list = @wjoin(@wsplit(@wjoin(uniquegroups)))
It's not efficient, but it is concise.
There are rows in my alpha series that are actually blank and I'd like to skip them when gathering unique values.