The SASEHAVR Interface Engine: Examining the Contents of a HAVER Database

The SASEHAVR Interface Engine

Example 35.1 Examining the Contents of a HAVER Database

To see which time series are in your HAVER database, use PROC CONTENTS with the SASEHAVR LIBNAME statement to read the contents.

   libname lib1 sasehavr "%sysget(HAVER_DATA)" 
           freq=yearly start=19920101 
           end=20041231 
           force=freq;
           
   data hwouty;
      set lib1.haverw;
   run;
      title1 'Haver Analytics Database, HAVERW.DAT';
   title2 'PROC CONTENTS for Time Series converted to yearly frequency';
   proc contents data=hwouty;
   run;

In the preceding example, the HAVER database is called haverw and it resides in the directory referenced in lib1. The DATA statement names the SAS output data set hwouty, which will reside in saswork. All time series in the HAVER haverw database are listed alphabetically in Output 35.1.1.

Output 35.1.1 Examining the Contents of HAVER Analytics Database, haverw.dat

Haver Analytics Database, HAVERW.DAT

PROC CONTENTS for Time Series converted to yearly frequency

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
#	Variable	Type	Len	Format	Label
1	DATE	Num	8	YEAR4.	Date of Observation
2	FA	Num	8		Total Assets: All Commercial Banks (SA, Bil.$)
3	FCM1M	Num	8		1-Month Treasury Bill Market Bid Yield at Constant Maturity (%)
4	FM1	Num	8		Money Stock: M1 (SA, Bil.$)
5	FTA1MA	Num	8		Treasury 4-Week Bill: Total Amount Accepted (Bil$)
6	FTB3	Num	8		3-Month Treasury Bills, Auction (% p.a.)
7	LICN	Num	8		Unemployment Insurance: Initial Claims, State Programs (NSA, Thous)

You could use the following SAS statements to create a SAS data set named hwouty and to print its contents.

   libname lib1 sasehavr "%sysget(HAVER_DATA)" 
          freq=yearly 
          start=19920101 
          end=20041231 
          force=freq;
          
   data hwouty;
      set lib1.haverw;
   run;
   
   title1 'Haver Analytics Database, Frequency=yearly, infile=haverw.dat';
   title2 'Define a range inside the data range for OUT= dataset,';        
   title3 'Using the START=19920101 END=20041231 LIBNAME options.';
     
   proc print data=hwouty;
   run;

The preceding LIBNAME lib1 statement specifies that all time series in the haverw database be converted to yearly frequency but to only select the range of data from January 1, 1992, to December 31, 2004. The resulting SAS data set hwouty is shown in Output 35.1.2.

Output 35.1.2 Defining a Range Inside the Data Range for Yearly Time Series

Haver Analytics Database, Frequency=yearly, infile=haverw.dat

Define a range inside the data range for OUT= dataset,

Using the START=19920101 END=20041231 LIBNAME options.

Obs	DATE	FA	FCM1M	FM1	FTA1MA	FTB3	LICN
1	1992	3466.3	.	965.31	.	3.45415	407.340
2	1993	3624.6	.	1077.69	.	3.01654	344.934
3	1994	3875.8	.	1144.85	.	4.28673	340.054
4	1995	4209.3	.	1142.70	.	5.51058	357.038
5	1996	4399.1	.	1106.46	.	5.02096	351.358
6	1997	4820.3	.	1069.23	.	5.06885	321.513
7	1998	5254.8	.	1079.56	.	4.80726	317.077
8	1999	5608.1	.	1101.14	.	4.66154	301.581
9	2000	6115.4	.	1104.07	.	5.84644	301.108
10	2001	6436.2	2.31368	1136.31	11.753	3.44471	402.583
11	2002	7024.9	1.63115	1192.03	18.798	1.61548	402.796
12	2003	7302.9	1.02346	1268.40	16.089	1.01413	399.137
13	2004	7950.5	1.26642	1337.89	13.019	1.37557	345.109

Top of Page