Using the KEEP Option to Subset Time Series from a Haver Database
/*----------------------------------------------------------------
SAS Sample Library
Name: havex08.sas
Description: Example program from SAS/ETS User's Guide,
The SASEHAVR Interface Engine
Title: Using the KEEP Option to Subset Time Series from a Haver Database
Product: SAS/ETS Software
Keys: SASEHAVR
Procs:
Notes: Read this before you run this sample.
The database resides in the ets/sasmisc folder. You
must copy the database to a writeable folder before
using it. Then define your Windows system environment
variable, HAVER_DATA, to the path of your
writeable folder containing
the haverd.dat and haverd.idx files (Haver database files).
To assign a fileref to the external file to be processed,
use the following form of the libname statement:
libname lib1 sasehavr "%sysget(HAVER_DATA)"
freq=daily
start=20041101
end=20041231
keep="FCM*";
----------------------------------------------------------------*/
libname lib1 sasehavr "%sysget(HAVER_DATA)"
freq=daily
start=20041101
end=20041231
keep="FCM*";
data hwoutd;
set lib1.haverd;
run;
title1 'Haver Analytics Database, Frequency=daily, infile=haverd.dat';
title2 ' Define a range inside the data range for OUT= dataset';
title3 ' Using the START=20041101 END=20041231 LIBNAME options.';
title4 ' Subset further: Using keep="FCM*" LIBNAME option ';
proc print data=hwoutd;
run;