The SASEHAVR Interface Engine
- Overview
-
Getting Started
-
Syntax
-
Details
-
ExamplesExamining the Contents of a Haver DatabaseViewing Quarterly Time Series from a Haver DatabaseViewing Monthly Time Series from a Haver DatabaseViewing Weekly Time Series from a Haver DatabaseViewing Daily Time Series from a Haver DatabaseLimiting the Range of Time Series from a Haver DatabaseUsing the WHERE Statement to Subset Time Series from a Haver DatabaseUsing the KEEP Option to Subset Time Series from a Haver DatabaseUsing the SOURCE Option to Subset Time Series from a Haver DatabaseUsing the GROUP Option to Subset Time Series from a Haver DatabaseUsing the OUTSELECT=ON Option to View the Key Selection Variables in a Haver DatabaseSelecting Variables Based on Short Source Key CodeSelecting Variables Based on Geography Key Codes
- References
If this is your first time using the SASEHAVR interface engine on your Windows machine, then it is necessary to follow these setup instructions. If you have already used the SASEHAVR interface, then just check the file version number of your already installed dlxapi32.dll (or dlxapi64.dll). For 32-bit installations, the file version is 1.1.9.0, and for 64-bit installations, the file version is 2.0.0.1. The Haver API version number appears in the SAS log the first time you assign a SASEHAVR libref. In Windows Explorer, you can see a file’s properties, including its version number, by hovering the mouse pointer over the file icon. Alternatively, you can right-click on the file icon to bring up the properties and click the Details tab to see the version number.
To set up the Haver Analytics API on your machine, visit the SAS Technical Support download site at the following URL:
http://ftp.sas.com/techsup/download/base/
First, create a folder on your system drive (usually designated as C:), and name the folder HAVER. Create an environment variable named HAVER as follows:
HAVER=C:\HAVER\
If your SAS system is 32-bit, then download the files dlxapi32.h, dlxapi32.dll, and dlxapi32.lib to your HAVER folder. If your SAS system is 64-bit, then download the files dlxapi64.h, dlxapi64.dll, and dlxapi64.lib to your HAVER folder. Second, prepend the location of your HAVER folder to the system environment variable (%PATH%) as follows, so that the SASEHAVR engine can find your downloaded Haver API files:
PATH=C:\HAVER\;%PATH%
Reboot your system to complete the Haver API setup.