Page 1 of 1

Pool object

Posted: Wed Jun 05, 2013 5:39 am
by tvonbrasch
Hi,

I have a dataset consisting of the variable px?, where ? goes across 260 countries. How do I create a pool object for those 260 countries (i do not want to manually insert the country codes).

One way of doing this is:
pagestack px?
pageunstack(page=pool) var01 id01


but, there must be a better way to do this?

Thomas

Re: Pool object

Posted: Wed Jun 05, 2013 7:59 am
by EViews Gareth
Could you post the data?

Re: Pool object

Posted: Wed Jun 05, 2013 10:12 am
by tvonbrasch
Sure,

If I may ask another question as well. How can I create a pool object that holds only the countries where the variable px has been positive across the sample period (if @min(px?)>1) ?
Thomas

Re: Pool object

Posted: Wed Jun 05, 2013 10:27 am
by EViews Gareth

Code: Select all

%ids = @wlookup("px*", "series") %ids = @replace(%ids, "PX", "") pool p {%ids}

To only add some of them, you'd have to loop through, test the minimum, and only add those that passed the test.

Re: Pool object

Posted: Wed Jun 05, 2013 10:44 am
by tvonbrasch
perfect, thanks
t