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
S.DFRM |
Char |
27 |
S.FRM1 |
Char |
27 |
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
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.
Copyright © SAS Institute, Inc. All Rights Reserved.