Example 40.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 40.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 40.15.1 and Output 40.15.2 show the results.

Output 40.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 40.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.