The SASEHAVR Interface Engine

Example 42.2 Viewing Quarterly Time Series from a Haver Database

The following statements specify a quarterly frequency conversion of all time series for the period spanning April 1, 2001, to December 31, 2004:

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

data hwoutq;
   set lib1.haverw;
run;

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

proc print data=hwoutq;
run;

The resulting SAS data set hwoutq is shown in Output 42.2.1.

Output 42.2.1: Defining a Range inside the Data Range for Quarterly Time Series

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

Obs DATE FA FCM1M FM1 FTA1MA FTB3 LICN
1 2001Q2 6225.4 . 1115.75 . 3.68308 356.577
2 2001Q3 6425.9 2.98167 1157.90 12.077 3.27615 368.408
3 2001Q4 6436.2 2.00538 1169.62 11.753 1.95308 477.685
4 2002Q1 6396.3 1.73077 1186.92 22.309 1.72615 456.292
5 2002Q2 6563.5 1.72769 1183.30 17.126 1.72077 368.592
6 2002Q3 6780.0 1.69231 1189.89 21.076 1.64769 352.892
7 2002Q4 7024.9 1.37385 1207.80 18.798 1.36731 433.408
8 2003Q1 7054.5 1.17846 1231.41 24.299 1.15269 458.746
9 2003Q2 7319.6 1.08000 1262.24 14.356 1.05654 386.185
10 2003Q3 7238.6 0.92000 1286.21 16.472 0.92885 361.346
11 2003Q4 7302.9 0.91538 1293.76 16.089 0.91846 390.269
12 2004Q1 7637.3 0.90231 1312.43 21.818 0.91308 400.585
13 2004Q2 7769.8 0.94692 1332.75 12.547 1.06885 310.508
14 2004Q3 7949.5 1.34923 1343.79 21.549 1.49393 305.862
15 2004Q4 7950.5 1.82429 1362.60 13.019 2.01731 362.171