The SASEFAME Interface Engine: Reading Other FAME Data Objects with the FAMEOUT= Option

The SASEFAME Interface Engine

Example 34.6 Reading Other FAME Data Objects with the FAMEOUT= Option

Suppose you want to see the source for your formulas or you are interested in string case series instead of numeric time series. You can designate the data objects that are output to your SAS data set using the FAMEOUT= option. In this example, the FAMEOUT=FORMULA option selects the formulas and their source definitions to be output as shown in Output 34.6.1. Note that the RANGE= option is ignored since no time series are selected when FAMEOUT=FORMULA is specified.

   options validvarname=any ls=90;
   
   %let FAME=%sysget(FAME);
   %put(&FAME);
   %let FAMETEMP=%sysget(FAME_TEMP);
   %put(&FAMETEMP);
   
   libname lib6 sasefame "%sysget(FAME_DATA)"
      fameout=formula
      convert=(frequency=business technique=constant)
      range='02jan1995'd - '25jul1997'd
      wildcard="?YIELD?" ;
   
   data crout;
      set lib6.training;
      keep 'S.GM.YIELD.A'n -- 'S.XON.YIELD.A'n ;
   run;
   
   title2 'Contents of OUT=CROUT from the FAMEOUT=FORMULA Option';
   title3 'Using WILDCARD="?YIELD?"';
   proc contents
      data=crout;
   run;

Output 34.6.1 Contents of OUT=CROUT from the FAMEOUT=FORMULA Option of the TRAINING FAME Data

famesql5: PROC SQL Dual Embedded Libraries w/ FAME option

Contents of OUT=CROUT from the FAMEOUT=FORMULA Option

Using WILDCARD="?YIELD?"

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
#	Variable	Type	Len
1	S.GM.YIELD.A	Char	82
2	S.GM__PP.YIELD.A	Char	82
3	S.HWP.YIELD.A	Char	82
4	S.IBM.YIELD.A	Char	82
5	S.INDUT.YIELD.A	Char	82
6	S.SPAL.YIELD.A	Char	82
7	S.SPALN.YIELD.A	Char	82
8	S.SUNW.YIELD.A	Char	82
9	S.XOM.YIELD.A	Char	82
10	S.XON.YIELD.A	Char	82

The FAMEOUT=FORMULA option restricts the SAS data set to include only formulas. The WILDCARD="?YIELD?" option further limits reading only those formulas whose names "YIELD" in them. This output is shown in Output 34.6.2.

   options validvarname=any linesize=79;
   
   title2 'PROC PRINT of OUT=CROUT from the FAMEOUT=FORMULA Option';
   title3 'Using WILDCARD="?YIELD?"';
   proc print 
      data=crout noobs;
   run;

Output 34.6.2 Listing of OUT=CROUT from the FAMEOUT=FORMULA Option of the TRAINING FAME Data

famesql5: PROC SQL Dual Embedded Libraries w/ FAME option

PROC PRINT of OUT=CROUT from the FAMEOUT=FORMULA Option

Using WILDCARD="?YIELD?"

S.GM.YIELD.A	S.GM__PP.YIELD.A	S.HWP.YIELD.A	S.IBM.YIELD.A	S.INDUT.YIELD.A	S.SPAL.YIELD.A	S.SPALN.YIELD.A	S.SUNW.YIELD.A	S.XOM.YIELD.A	S.XON.YIELD.A
(%SPLC2TF(C37044210X01, IAD_DATE.H, IAD.H)/C37044210X01.CLOSE)*C37044210X01.ADJUST	(%SPLC2TF(C37044210X01, IAD_DATE.H, IAD.H)/C37044210X01.CLOSE)*C37044210X01.ADJUST	(%SPLC2TF(C42823610X01, IAD_DATE.H, IAD.H)/C42823610X01.CLOSE)*C42823610X01.ADJUST	(%SPLC2TF(C45920010X01, IAD_DATE.H, IAD.H)/C45920010X01.CLOSE)*C45920010X01.ADJUST	(%SPLC2TF(C00000110X00, IAD_DATE.H, IAD.H)/C00000110X00.CLOSE)*C00000110X00.ADJUST	(%SPLC2TF(C00000117X00, IAD_DATE.H, IAD.H)/C00000117X00.CLOSE)*C00000117X00.ADJUST	(%SPLC2TF(C00000117X00, IAD_DATE.H, IAD.H)/C00000117X00.CLOSE)*C00000117X00.ADJUST	(%SPLC2TF(C86681010X60, IAD_DATE.H, IAD.H)/C86681010X60.CLOSE)*C86681010X60.ADJUST	(%SPLC2TF(C30231G10X01, IAD_DATE.H, IAD.H)/C30231G10X01.CLOSE)*C30231G10X01.ADJUST	(%SPLC2TF(C30231G10X01, IAD_DATE.H, IAD.H)/C30231G10X01.CLOSE)*C30231G10X01.ADJUST

Top of Page