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 |