Remote FAME Access Using FAME CHLI
/*----------------------------------------------------------------
SAS Sample Library
Name: famex07.sas
Description: Example program from SAS/ETS User's Guide,
The SASEFAME Interface Engine
Title: Remote FAME Access Using FAME CHLI
Product: SAS/ETS Software
Keys: FAME data extraction, Remote access of FAME data.
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 driecon.db file (FAME database).
To assign a fileref to the external file to be processed,
use the following form of the libname statement:
libname test1 sasefame '#5555@stones $FAME/util';
----------------------------------------------------------------*/
options ls=78;
title1 "DRIECON Database, Using FAME with Remote Access Via CHLI";
options validvarname=any;
libname test1 sasefame '#5555@stones $FAME/util';
data a;
set test1.driecon;
keep YP ZA ZB;
where date between '01jan98'd and '31dec03'd;
run;
proc means data=a n;
run;