Previous Page

|

Next Page

The SASEFAME Interface Engine

Example 34.11 Selecting Series Using FAMEOUT= Option

This example shows how to read case series instead of time series. Case series can be numeric, boolean, string, date, or formulas that resolve to series. SASEFAME resolves all formulas that belong to the type of series data object that you specify in your FAMEOUT= option. If these object types are not specified, the FAMEOUT= option defaults to time series.

The first case shows writing of all boolean case series to your SAS data set, while the second shows selection of numeric case series; the third shows writing all date case series to your SAS data set, while the fourth shows selection of all the string case series. The last case shows output of the SOURCE for all the formula case series in the ALLTYPES data base.

In the first example, suppose you prefer to extract all boolean case series from your FAME data base. The following statements write all boolean case series to your SAS data set. The results are shown in Output 34.11.1 and Output 34.11.2.

   title1 '***famallt: FAMEOUT option, Different Type Values***';
   options validvarname=any;
   
   %let FAME=%sysget(FAME);
   %put(&FAME);
   %let FAMETEMP=%sysget(FAME_TEMP);
   %put(&FAMETEMP);
   
   libname lib4 sasefame "%sysget(FAME_DATA)"
      fameout=boolcase wildcard="?" ;
   
   data booout;
      set lib4.alltypes;
   run;
   
   title2 'Contents of OUT=booout';
   title3 'Using FAMEOUT=CASE BOOLEAN option without range';
   proc contents 
      data=booout;
   run;
   
   title2 'ALLTYPES FAMEOUT=BOOLCASE and open wildcard for BOOLEAN CASE Series';
   title3 'OUT=BOOOUT from the PRINT Procedure';
   proc print 
      data=booout;
   run;

Output 34.11.1 Contents of OUT=BOOUT Using FAMEOUT=BOOLCASE and Open Wildcard for Boolean Case Series

***famallt: FAMEOUT option, Different Type Values***

Contents of OUT=booout

Using FAMEOUT=CASE BOOLEAN option without range

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
#	Variable	Type	Len
1	BOO0	Num	8
2	BOO1	Num	8
3	BOO2	Num	8
4	BOOM	Num	8
5	BOO_RES	Num	8

Suppose instead of boolean case series, you prefer to see numeric case series. Case series can be numeric or boolean or string series or date series. In addition to the existing case series in your FAME database, you can have formulas that resolve to numeric case series. SASEFAME will resolve all formulas that belong to the class and type of series data object that you specify in your FAMEOUT= option. The following statements write all numeric case series to your SAS data set. The results are shown in Output 34.11.3 and Output 34.11.4.

   libname lib5 sasefame "%sysget(FAME_DATA)"
      fameout=case wildcard="?" ;
   
   data csout;
      set lib5.alltypes;
   run;
   
   title2 'Contents of OUT=csout';
   title3 'Using FAMEOUT=CASE option without range';
   proc contents 
      data=csout;
   run;
   
   title2 'ALLTYPES, FAMEOUT=CASE and open wildcard for Numeric Case Series';
   title3 'OUT=CSOUT from the PRINT Procedure';
   proc print 
      data=csout;
   run;

Instead of numeric case series, you could decide to extract date case series. Case series can be numeric or boolean or string series or date series. In addition to the existing case series in your FAME database, you can have formulas that resolve to date case series. SASEFAME will resolve all formulas that belong to the class and type of series data object that you specify in your FAMEOUT= option. The following statements write all date case series to your SAS data set. The results are shown in Output 34.11.5 and Output 34.11.6.

   libname lib6 sasefame "%sysget(FAME_DATA)"
      fameout=datecase wildcard="?" ;
   
   data cdout;
      set lib6.alltypes;
   run;
   
   title2 'Contents of OUT=cdout';
   title3 'Using FAMEOUT=DATECASE option without range';
   proc contents 
      data=cdout;
   run;
   
   title2 'ALLTYPES, FAMEOUT=DATECASE and open wildcard for Date Case Series';
   title3 'OUT=CDOUT from the PRINT Procedure';
   proc print 
      data=cdout;
   run;

The next example shows how to extract string case series. Case series can be numeric or boolean or string series or date series. In addition to the existing string case series in your FAME database, you can have formulas that resolve to string case series. SASEFAME will resolve all formulas that belong to the class and type of series data object that you specify in your FAMEOUT= option. The following statements write all string case series to your SAS data set. The results are shown in Output 34.11.7 and Output 34.11.8.

   libname lib7 sasefame "%sysget(FAME_DATA)"
      fameout=stringcase wildcard="?" ;
   
   data cstrout;
      set lib7.alltypes;
   run;
   
   title2 'Contents of OUT=cstrout';
   title3 'Using FAMEOUT=STRINGCASE option without range';
   proc contents 
      data=cstrout;
   run;
   
   title2 'ALLTYPES, FAMEOUT=STRINGCASE and open wildcard for STRING CASE Series';
   title3 'OUT=CSTROUT from the PRINT Procedure';
   proc print 
      data=cstrout;
   run;

Suppose you prefer to extract all the source for the formulas in your FAME database. The following statements show the source of all formulas written to your SAS data set. The results are shown in Output 34.11.9 and Output 34.11.10. Another example of FAMEOUT=FORMULA option is shown in Example 34.6.

   libname lib8 sasefame "%sysget(FAME_DATA)"
      fameout=formula wildcard="?" ;
   
   data cforout;
      set lib8.alltypes;
   run;
   
   title2 'Contents of OUT=cforout';
   title3 'Using FAMEOUT=FORMULA option without range';
   proc contents 
      data=cforout;
   run;
   

   title2 'ALLTYPES, FAMEOUT=FORMULA and open wildcard for FORMULA Series';
   title3 'OUT=CFOROUT from the PRINT Procedure';
   proc print 
      data=cforout noobs;
   run;

If you want all series of every type, you can merge the resulting data sets together. For more about merging SAS data sets, see SAS Language Reference: Concepts.

Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.