The SASEHAVR Interface Engine |
Example 37.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 37.2.1.
Output 37.2.1
Defining a Range inside the Data Range for Quarterly Time Series
2001Q2 |
6225.4 |
. |
1115.75 |
. |
3.68308 |
356.577 |
2001Q3 |
6425.9 |
2.98167 |
1157.90 |
12.077 |
3.27615 |
368.408 |
2001Q4 |
6436.2 |
2.00538 |
1169.62 |
11.753 |
1.95308 |
477.685 |
2002Q1 |
6396.3 |
1.73077 |
1186.92 |
22.309 |
1.72615 |
456.292 |
2002Q2 |
6563.5 |
1.72769 |
1183.30 |
17.126 |
1.72077 |
368.592 |
2002Q3 |
6780.0 |
1.69231 |
1189.89 |
21.076 |
1.64769 |
352.892 |
2002Q4 |
7024.9 |
1.37385 |
1207.80 |
18.798 |
1.36731 |
433.408 |
2003Q1 |
7054.5 |
1.17846 |
1231.41 |
24.299 |
1.15269 |
458.746 |
2003Q2 |
7319.6 |
1.08000 |
1262.24 |
14.356 |
1.05654 |
386.185 |
2003Q3 |
7238.6 |
0.92000 |
1286.21 |
16.472 |
0.92885 |
361.346 |
2003Q4 |
7302.9 |
0.91538 |
1293.76 |
16.089 |
0.91846 |
390.269 |
2004Q1 |
7637.3 |
0.90231 |
1312.43 |
21.818 |
0.91308 |
400.585 |
2004Q2 |
7769.8 |
0.94692 |
1332.75 |
12.547 |
1.06885 |
310.508 |
2004Q3 |
7949.5 |
1.34923 |
1343.79 |
21.549 |
1.49393 |
305.862 |
2004Q4 |
7950.5 |
1.82429 |
1362.60 |
13.019 |
2.01731 |
362.171 |
Copyright © SAS Institute, Inc. All Rights Reserved.