The following statements convert weekly time series to a monthly frequency:
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 42.3.1.
Output 42.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 |