Getting Started : New Features in EViews 10 : Data Handling
  
Data Handling
 
Improved R Data Support
Attribute Import and Export
Eurostat, ECB, and UN
SDMX-ML Files
World Bank Data
Exporting Data in Tableau and JSON Formats
EViews 10 offers a variety of new features for working with data.
Improved R Data Support
EViews now supports R integration directly, eliminating the need for third-party software. Simply install both EViews 10 and R on the same computer (EViews was developed and tested with R version 3.2.3. You must have version 3.2.3 or newer installed on the machine running EViews) and perform the configuration steps as in “Improved R Connectivity”.
Once you install R, you may use previously existing EViews commands, such as XRUN and XGET to move data between EViews and R.
More importantly, EViews 10 now offers native RDATA workspace file support. This support means that you can save an EViews workfile (one page at a time) directly to a new RDATA workspace file using the standard EViews database and file interface.
You may use the standard workfile Proc/Save As interactive interface to save an RDATA workspace, or you can use the wfsave or pagesave commands to perform the operation:
wfsave(type=rdata) c:\files\tq.rdata
Each simple object (series, alpha, matrix, vector, and scalar) on the current workfile page will be converted to an appropriate R data structure and saved into the new RDATA file.
You may also open an RDATA file as an EViews workfile or as an EViews database. As with saving data, you may use the interactive interface, by selecting File/Open/Foreign Data as Workfile... or File/Open/Database..., or you may issue commands.
For example, the command
dbopen(type=rdata) c:\files\data.rdata
will open the RDATA file in its own EViews database window. You can view all the R objects found in this database and individually FETCH the objects you want into your workfile:
Note: R data structures that could have multiple columns/elements (such as data.frame, list, and mts objects) are listed once per column/element with the appropriate R name.
As an EViews Database, you can use both FETCH and STORE to read and write data to the RDATA file and even link EViews series objects back to their source R structure to allow for simple data refreshes.
For further discussion, see
“Sending EViews Data to R”
“Retrieving R Data into EViews”
See also the xput and xget commands
Attribute Import and Export
Data are often accompanied by varying types of metadata. EViews now supports reading in custom series attributes (along with the series data) during an import from Excel and text files.
The EViews 10 import wizard has been modified to support reading in custom series attributes that are specified as header rows. For example, the following Excel spreadsheet has custom attributes for Description, SKU, and State specified in header rows:
When we drag and drop this file onto EViews 10, the new Import Wizard dialog appears. On the second page (Step 2), we now allow you to change how each header row is used:
By default, EViews will treat every header row as a Name field, but you can change the row type for each header by selecting (or specifying a custom value for) the attribute name:
You can now complete the import and verify that all custom attributes have been read in correctly:
Both the wfopen and import commands have been modified to support new values for the "namepos=" argument and a new "colheadnames=" argument to specify individual attribute names for each column.
Correspondingly, EViews 10 also supports saving series object attributes when the destination is an Excel spreadsheet file or a text file. Attributes will be saved as extra header rows as specified above. See WFSAVE reference for more details on the new "attr", option.
See also:
wfopen, pageload, and import
wfsave and pagesave
Eurostat, ECB, and UN
SDMX Databases provide access to a list of datasets that offer a large range of publicly available data.
Both the Standard and Enterprise versions of EViews offer access to Eurostat, ECB (European Central Bank), and UN (United Nations) data using SDMX Web Services.
Please note that an internet connection will be required to obtain SDMX online data. For more information on the datasets, please see
http://ec.europa.eu/eurostat/data/database
https://ec.sdw-wsrest.ecb.europa.eu
http://data.un.org/WS/
EViews offers a custom interface to the SDMX databases. The interface includes a custom browser for navigating and retrieval of available data. To start, you must open a database window to SDMX database by selecting File/Open Database… from the main EViews menus, then selecting Eurostat SDMX Database, or ECB SDMX Database, or UN SDMX Database from the Database/File type dropdown menu. A dialog of the following form will be displayed:
Click on OK to open the online database. You will be presented with a standard EViews database representing a connection to the data. Click on Browse or Browse-Append to open an all new custom database.
Here we see the interface to the Eurostat data:
The browser allows you to find data available within datasets by navigating through a set of folders. Click on any folder to move inside it. A dialog with a list of filters will be shown, which will allow you to filter and customize the search results of the available series objects in the selected dataset:
Click on Get to show the results.
The browser interface to SDMX online data offers a number of useful tools for working with your database. Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
For additional detail, see
“Eurostat, ECB, UN, and IMF”
See also dbopen
SDMX-ML Files
SDMX (Statistical Data and Metadata eXchange) standardizes the processes for the exchange of statistical data among international organizations.
EViews offers an interface to SDMX data where the user has the ability to read SDMX datasets and data structure definitions (DSD) in structured XML documents (SDMX-ML), using the standard EViews database interface.
EViews allows you to work offline with data from organizations like EUROSTATA, ECB, IMF, UN, BIS, and OECD. Both the Standard and Enterprise versions of EViews offer reading of SDMX data. Please note that the EViews SDMX-ML interface requires that data were previously downloaded in SDMX XML format.
To start, you must open a database window to SDMX-ML by selecting File/Open Database… from the main EViews menus, then selecting SDMX-ML files from the Database/File type dropdown menu. The following dialog should appear:
Click on Browse Path to select the folder/path on disk where the SDMX data and data definitions files are located.
Click on OK to open the database. You will be presented with a standard EViews database with the All, Query and Easy Query search interface, to view all or a selection of the data series:
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
See “SDMX-ML Files”
See also dbopen
World Bank Data
EViews 10 offers a custom interface to World Bank data. World Bank Open Data provides access to a list of datasets that offer access to global development data. These databases offer a wide variety of freely available indicators about development in countries around the world.
For more information on the World Bank datasets, please see http://data.worldbank.org.
Both the Standard and Enterprise versions of EViews offer World Bank access. Please note that an internet connection is required to obtain World Bank data.
EViews offers a custom interface to the World Bank. The interface includes a custom browser for navigating and retrieval of World Bank data. To start, open a database window to the World Bank by selecting File/Open Database… from the main EViews menus, then select World Bank Database from the Database/File type dropdown menu. The following dialog should appear:
The default data source selected is World Development Indicators (a collection of development indicators that includes global development data). Click on Browse to view and select another data source. Click on OK to open the online database.
You will be presented with a standard EViews database window. Click on Browse or Browse-Append, which opens a new custom World Bank database. Click on the folder icons to drill down into subtopics or use the search feature to find the desired data:
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
For additional discussion, see
“World Bank Data”
See also dbopen
Exporting Data in Tableau and JSON Formats
EViews 10 Enterprise Edition now supports saving series objects in a workfile page to a Tableau Data Extract file (.tde) or in JSON format. The TDE file can be used by Tableau Desktop or exported to a Tableau Server.
See wfsave and pagesave