SAS/ETS(R) 9.2 User's Guide

The SASEHAVR interface gives Windows users random access to economic and financial data that resides in a Haver Analytics Data Link Express (DLX) database. You can now use the SAS windowing environment to view HAVERDLX data and use the SAS viewtable commands to navigate your Haver database. You can use the SQL procedure to create a view of your resulting SAS data set.

You can see the available data sets in the SAS LIBNAME window of the SAS windowing environment by selecting the SASEHAVR libref in the LIBNAME window that you have previously used in your libname statement. You can view your SAS output observations by double-clicking on the desired output data set libref in the libname window of the SAS windowing environment. You can use Viewtable on the SAS command line to view any of your SASEHAVR tables, views, or librefs both for input and output data sets.

It is also possible to select specific variables to be included or excluded from the SAS data set by using the KEEP= or the DROP= option. When the KEEP= or the DROP= option is used, the resulting SAS data set keeps or drops the variables that you select in that option. There are three wildcards currently available: '*', '?', and ''. The '*' wildcard corresponds to any character string and will include any string pattern that corresponds to that position in the matching variable name. The '?' means that any single alphanumeric character is valid. The '' wildcard corresponds to a single numeric character.

You can also select time series in your data by using the GROUP= or the SOURCE= option to select on group name or on source name. Alternatively, you can deselect time series by using the DROPGROUP= or the DROPSOURCE= option. These options also support the wildcards '*', '?', and ''.

By default, SASEHAVR selects only the variables that are of the specified frequency in the FREQ= option. If this option is not specified, SASEHAVR selects the variables that match the frequency of the first selected variable. If no other selection criteria are specified, the first selected variable is the first physical DLXRecord read from the Haver database.