The SASEFAME Interface Engine

Example 47.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 WILDCARD="?" options. The following statements show the source of all formulas written to the SAS data set CFOROUT. Another example of the FAMEOUT=FORMULA option is shown in Example 47.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 47.15.1 and Output 47.15.2 show the results.

Output 47.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 47.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. For more information about merging SAS data sets, see SAS Language Reference: Concepts.