Transforming numerical series into alpha or svector

[michel]

Dear Support,

I need to convert a numerical series into a string in order to find the unique values in the series. Later in the progam I still need it to be a string.
Currently I use a simple loop to do the transformation:

Code: Select all

%codepays_all ="" for !i = 1 to @obs(codepays) %codepays_all = %codepays_all +" "+@str(codepays(!i)) next string codepays_all = %codepays_all %codepays_unique = @wunique(codepays_all) string codepays_unique = %codepays_unique

However, the series codepays has 160000 observations and the loop takes some minutes to run (I have to run this multiple times for similar variables).

Now my question is, is there a faster way to perform this transformation? Ideally I could convert the series codepays into an svector or alpha and from there on use @wjoin to convert it into a string (such that I can use @wunique).

Kind regards,

michel

[EViews Gareth]

http://www.eviews.com/help/helpintro.ht ... evals.html

[michel]

Thank you very much!

[EViews Gareth]

Probably a bit faster :D

[michel]

Its no comparision. :)
Considering the transformation of a vector into an svector, is there any function I could use? Currently I do it as shown in my first post on the current topic.

Ideally this would work:

Code: Select all

vector codepaysorigine_unique = @uniquevals(codepaysorigine) svector codepaysorigine_unique_sv = @str(codepaysorigine_unique)

Kind regards,

michel

[EViews Gareth]

Not currently.