General keyword search EViews database

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

xprimexinverse
Posts: 39
Joined: Fri Sep 18, 2015 11:41 am
Location: Dublin, Ireland
Contact:

General keyword search EViews database

Postby xprimexinverse » Wed Nov 27, 2019 12:58 pm

Hi,

I'm wondering if it's possible to do a very general database query in EViews?

For example, I would like to be able to use @wquery like this:

@wquery("mydb", "* matches *Exports* and freq=Q", "name")


The key feature of the above code is the first wildcard (*) term in "* matches *Exports*".

My understanding is that I need to specify the first wildcard (*) term, which is typically something like "name" or "description".

The problem with this functionality is that it requires me to know the specific attribute of interest. As a user of a large database with many attributes, I won't necessarily know this information.

For example (hopefully understandable without providing a workfile): let's say my database contains two series called series1 and series2. Series1 has an attribute called "Table.Description" with a value of "Trade Exports Table". Series2 has an attribute called "Statistic" with a value "Exports of Goods". How do I write a general search for "Exports" so that the query returns both series1 and series2? Assume that I do not know the two attributes.

Thanks for the help!
- Graeme

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 17 guests