The SASEFAME Interface Engine

This example shows how to use two Fame namelists to perform selection. Note that fame_namelist1 could be easily generated using the Fame WILDLIST function. For more about WILDLIST, see the section “The WILDLIST Function” in the Fame Command Reference Volume 2, Functions. In the following statements, four tickers are selected in fame_namelist1, but when you use the KEEP statement, the resulting data set contains only the desired IBM ticker.

libname lib8 sasefame "%sysget(FAME_DATA)"
        convert=(frequency=business technique=constant)
        crosslist=(
           { IBM,SPALN,SUNW,XOM },
           { adjust, close, high, low, open, volume,
             uclose, uhigh, ulow,uopen,uvolume }
                   );

data trout;
   /* eleven companies, keep only the IBM ticker this time */
   set lib8.training;
   where date between '01mar02'd and '20mar02'd;
   keep IBM: ;
run;

title1 'TRAINING DB, Pricing Timeseries for IBM Ticker in CROSSLIST=';
proc contents
   data=trout;
run;
 
proc print
   data=trout;
run;

Output 41.8.1 and Output 41.8.2 show the results.