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
APR2004 |
7703.8 |
0.9140 |
1325.73 |
16.946 |
0.93900 |
317.36 |
MAY2004 |
7704.7 |
0.9075 |
1332.96 |
25.043 |
1.03375 |
297.00 |
JUN2004 |
7769.8 |
1.0275 |
1339.50 |
12.547 |
1.26625 |
315.45 |
JUL2004 |
7859.5 |
1.1840 |
1330.13 |
21.823 |
1.34900 |
357.32 |
AUG2004 |
7890.0 |
1.3650 |
1347.84 |
25.213 |
1.48000 |
276.70 |
SEP2004 |
7949.5 |
1.5400 |
1352.40 |
21.549 |
1.65000 |
270.70 |
OCT2004 |
7967.6 |
1.6140 |
1355.28 |
21.322 |
1.74750 |
304.24 |
NOV2004 |
8053.4 |
1.9125 |
1366.06 |
21.862 |
2.05625 |
335.85 |
DEC2004 |
7950.5 |
1.9640 |
1365.60 |
13.019 |
2.20200 |
441.16 |