Resources

Extracting Source for Formulas

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

                   SAS Sample Library

        Name: famex15.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEFAME Interface Engine
   Title: Extracting Source for Formulas
 Product: SAS/ETS Software
    Keys: FAME data extraction, FAMEOUT= formula option
   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 alltypes.db file (FAME database).
        To assign a fileref to the external file to be processed,
        use the following form of the libname statement:

libname lib8 sasefame "%sysget(FAME_DATA)"
   fameout=formula wildcard="?" ;
----------------------------------------------------------------*/
title1 '***famallt: FAMEOUT option, Different Type Values***';
options validvarname=any;

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

libname lib8 sasefame "%sysget(FAME_DATA)"
   fameout=formula wildcard="?" ;

data cforout;
   set lib8.alltypes;
run;

title1 'Using FAMEOUT=FORMULA Option without Range';
proc contents
   data=cforout;
run;


title3 'ALLTYPES, FAMEOUT=FORMULA, and Open Wildcard for FORMULA Series';
proc print
   data=cforout noobs;
run;