EViews Add-In to Excel - Get Data

[cmgconsulting]

I'm trying out the "Get Data" inside of excel to pull from an eviews file. For some reason I can't get it to sample from the data before it brings it in. Is this possible to do in the add-in? For example, if I have a dataset with a variable called states, can I say something to the effect of smpl @all if states = "Texas" to get only data for the state of Texas?

[EViews Steve]

Unfortunately, our OLEDB driver was designed to read data out of workfiles and databases WITHOUT a lot of the programming engine support that is available in EViews.

On one hand, this means you can use our OLEDB driver without incurring the resource cost of launching EViews itself (which can be slower to startup). On the other hand, this means the driver is limited to doing very simple types of filtering of the data.

Our driver only supports specifying a date range for a filter such as "@smpl 1991 2000" or "@smpl 11 20" or "@smpl @all". You can't use the IF condition and you can't specify a pre-existing sample object in the workfile to use as this would require the command processing engine that currently only exists within EViews itself.

You'll have to read in the entire dataset (or chunks of it at a time) and then either use Excel or your own VBA code to filter it yourself.

Another alternative would be to use our COM Automation interface (which you can do from Excel). This will launch EViews (hidden in the background) and you'd have full access to all of it's built-in functionality to use samples to filter your rows. Please refer to our COM Automation whitepaper for more details on this:
http://eviews.com/download/whitepapers/ ... mation.pdf

Steve