The SASEHAVR Interface Engine

Example 49.3 Viewing Monthly Time Series from a Haver Database

The following statements convert weekly time series to a monthly frequency:

libname lib1 sasehavr "%sysget(HAVER_DATA)"
        freq=monthly
        start=20040401
        end=20041231
        force=freq;

data hwoutm;
   set lib1.haverw;
run;

title1 'Haver Analytics Database, Frequency=monthly, infile=haverw.dat';
title2 '  Define a range inside the data range for OUT= dataset';
title3 '  Using the START=20040401 END=20041231 LIBNAME options.';

proc print data=hwoutm;
run;

The result from using the range of April 1, 2004, to December 31, 2004, is shown in Output 49.3.1.

Output 49.3.1: Defining a Range inside the Data Range for Monthly Time Series

Haver Analytics Database, Frequency=monthly, infile=haverw.dat
Define a range inside the data range for OUT= dataset
Using the START=20040401 END=20041231 LIBNAME options.

Obs DATE FA FCM1M FM1 FTA1MA FTB3 LICN
1 APR2004 7703.8 0.9140 1325.73 16.946 0.93900 317.36
2 MAY2004 7704.7 0.9075 1332.96 25.043 1.03375 297.00
3 JUN2004 7769.8 1.0275 1339.50 12.547 1.26625 315.45
4 JUL2004 7859.5 1.1840 1330.13 21.823 1.34900 357.32
5 AUG2004 7890.0 1.3650 1347.84 25.213 1.48000 276.70
6 SEP2004 7949.5 1.5400 1352.40 21.549 1.65000 270.70
7 OCT2004 7967.6 1.6140 1355.28 21.322 1.74750 304.24
8 NOV2004 8053.4 1.9125 1366.06 21.862 2.05625 335.85
9 DEC2004 7950.5 1.9640 1365.60 13.019 2.20200 441.16