Resources

Optimizing Cache Sizes with TUNEFAME and TUNECHLI Options

/*----------------------------------------------------------------

                   SAS Sample Library

        Name: famex17.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEFAME Interface Engine
   Title: Optimizing Cache Sizes with TUNEFAME and TUNECHLI Options
 Product: SAS/ETS Software
    Keys: FAME data extraction, TUNEFAME=NODES, TUNECHLI=NODES
   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 trainten.db file (FAME database).
        To assign a fileref to the external file to be processed,
        use the following form of the libname statement:

libname lib5 sasefame "%sysget(FAME_DATA)"
  wildcard="?UHIGH"
  tunefame=nodes 100
  tunechli=nodes 100
  convert=(frequency=business technique=constant)
  range='23jul1997'd - '25jul1997'd;
----------------------------------------------------------------*/
title1 '***TRAINTEN DB, Pricing Time Series, TUNEFAME=NODES and TUNECHLI=NODES Options';
options validvarname=any;

%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);


libname lib5 sasefame "%sysget(FAME_DATA)"
  wildcard="?UHIGH"
  tunefame=nodes 100
  tunechli=nodes 100
  convert=(frequency=business technique=constant)
  range='23jul1997'd - '25jul1997'd
  ;

data trout(drop=C:);
   set lib5.trainten;
run;
title1 'TRAINTEN DB, Pricing Time Series, TUNEFAME=NODES and TUNECHLI=NODES Options';
proc print data=trout;
run;

proc contents data=trout;
run;