The SASEFAME Interface Engine: Extracting Source for Formulas

The SASEFAME Interface Engine

Example 36.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 36.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 36.15.1 and Output 36.15.2 show the results.

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

Top of Page