
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 49.2.1.
Output 49.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 |