Reading Time Series from the FAME Database
/*----------------------------------------------------------------
SAS Sample Library
Name: famex02.sas
Description: Example program from SAS/ETS User's Guide,
The SASEFAME Interface Engine
Title: Reading Time Series from the FAME Database
Product: SAS/ETS Software
Keys: FAME data extraction
Procs: SASEFAME
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, FAME_DATA, to the path of your
writeable folder containing
the subecon.db file (FAME database).
To assign a fileref to the external file to be processed,
use the following form of the libname statement:
libname lib1 sasefame "%sysget(FAME_DATA)"
wildcard="wspca?"
convert=(technique=constant freq=twicemonthly );
----------------------------------------------------------------*/
options validvarname=any;
%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);
libname lib1 sasefame "%sysget(FAME_DATA)"
wildcard="wspca?"
convert=(technique=constant freq=twicemonthly );
libname lib2 "%sysget(FAME_TEMP)";
data lib2.twild(label='Annual Series from the FAMEECON.db');
set lib1.subecon;
where date between '01jan93'd and '31dec93'd;
/* keep only */
keep date wspca;
run;
proc contents data=lib2.twild;
run;
proc print data=lib2.twild;
run;