The SASEFAME Interface Engine

Example 41.15 Extracting Source for Formulas

This example shows how to extract the source for all the formulas in the Fame database by using the FAMEOUT=formula and the WILDCARD=? options. The following statements show the source of all formulas written to your SAS data set. Another example of FAMEOUT=FORMULA option is shown in Example 41.6.

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;

Output 41.15.1 and Output 41.15.2 show the results.

Output 41.15.1: Contents of OUT=CFOROUT Using FAMEOUT=FORMULA and Open Wildcard

Using FAMEOUT=FORMULA option without range

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
# Variable Type Len
1 S.DFRM Char 27
2 S.FRM1 Char 27
3 S.FRM2 Char 27


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

Output 41.15.2: Listing of OUT=CFOROUT Using FAMEOUT=FORMULA and Open Wildcard

Using FAMEOUT=FORMULA option without range
 
ALLTYPES, FAMEOUT=FORMULA and open wildcard for FORMULA Series

S.DFRM S.FRM1 S.FRM2
IF DBOO THEN DPRC ELSE DNUM IF BOO1 THEN NUM1 ELSE NUM2 IF BOO0 THEN DAT1 ELSE DAT2


If you want all series of every type, you can merge the resulting data sets together. For more information about merging SAS data sets, see SAS Language Reference: Concepts.