The SASEFAME Interface Engine

This example shows how to use the TUNEFAME= option, the TUNECHLI= option, and a RANGE= option to select pricing time series in the TRAINTEN database. The selected time series are written to the SAS output data set. The Fame database engine’s virtual memory is given in megabytes (MB), so this example sets the cache size to 100 MB. The Fame CHLI engine’s virtual memory is also given in megabytes (MB), so this example sets the CHLI cache size to 100 MB. These two settings correspond to the default settings. Both the Fame 4GL engine and the Fame CHLI engine can use a cache size that ranges from 0.1 MB to 17,592,186,000,000 MB.

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 Timeseries, TUNEFAME=NODES and TUNECHLI=NODES Options';
proc print data=trout;
run;

proc contents data=trout;
run;

Output 47.17.1 and Output 47.17.2 show the results.

For more information about tuning the use of virtual memory, read about TUNE CACHE nodes in the section "TUNE CACHE Option" in the online document Fame 10 Online Help.