Previous Page | Next Page

The SASEHAVR Interface Engine

Example 35.3 Viewing Monthly Time Series from a HAVER Database

Suppose you want to convert your time series to a monthly frequency like this:

   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 35.3.1.

Output 35.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

Previous Page | Next Page | Top of Page