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
Using the SAS DATA Step
If desired, you can store your selected time series in a SAS data set by using the SAS DATA step. You can further subset your data by using the WHERE, KEEP, or DROP statements in your DATA step.
For more efficient subsetting of time series by Haver variables, by Haver groups, by Haver sources, by Haver short sources, by Haver long sources, or by Haver geographic codes, you can use the corresponding KEEP=, GROUP=, SOURCE=, SHORTSOURCE=, LONGSOURCE=, GEOGCODE1=, or GEOGCODE2= option in the LIBNAME libref SASEHAVR statement. To see the available Haver selection key values including geographic codes, short sources, and long sources for your database, use the OUTSELECT=ON option. From the OUTSELECT output, you can use convenient wildcard symbols to create the selection list for your next LIBNAME libref SASEHAVR statement.
There are three wildcard symbols: '*', '?' and '
'. The '*' wildcard corresponds to any character string and includes any string pattern that corresponds to that position
in the matching variable name. The '?' stands for any single alphanumeric character. Lastly, the '' wildcard corresponds to a single numeric character.
You can also deselect time series by Haver variables, by Haver groups, by Haver sources, by Haver short sources, by Haver long sources, or by Haver geographic codes, by using the corresponding DROP=, DROPGROUP=, DROPSOURCE=, DROPSHORT=, DROPLONG=, DROPGEOG1=, or DROPGEOG2= option. These options also support wildcards.
After your selected data is stored in a SAS data set, you can use it as you would any other SAS data set.