The SASEFAME Interface Engine

Example 41.14 Selecting String Case Series with the FAMEOUT= Option

This example shows how to extract string case series. In addition to the existing string case series in your Fame database, you can have formulas that resolve to string case series. The SASEFAME engine resolves all formulas that belong to the class and type of series data object that you specify in the FAMEOUT= option. The following statements write all string case series to the SAS data set CSTROUT:

libname lib7 sasefame "%sysget(FAME_DATA)"
   fameout=stringcase wildcard="?" ;

data cstrout;
   set lib7.alltypes;
run;

title1 'Using FAMEOUT=STRINGCASE Option without Range';
title2 'ALLTYPES, FAMEOUT=STRINGCASE and Open Wildcard for String Case Series';
proc contents
   data=cstrout;
run;

proc print
   data=cstrout;
run;

Output 41.14.1 and Output 41.14.2 show the results.

Output 41.14.1: Contents of OUT=CSTROUT Using FAMEOUT=STRINGCASE and Open Wildcard for String Case Series

Using FAMEOUT=STRINGCASE Option without Range
ALLTYPES, FAMEOUT=STRINGCASE and Open Wildcard for String Case Series

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
# Variable Type Len
1 STR0 Char 16
2 STR1 Char 16
3 STR2 Char 16
4 STRM Char 16



Output 41.14.2: Listing of OUT=CSTROUT Using FAMEOUT=STRINGCASE and Open Wildcard for String Case Series

Using FAMEOUT=STRINGCASE Option without Range
ALLTYPES, FAMEOUT=STRINGCASE and Open Wildcard for String Case Series

Obs STR0 STR1 STR2 STRM
1 -9 0 1.333333 0
2 -8 1 1 1
3 -7 2 0.6666667 2
4 -6 3 0.3333333 3
5 -5 4 0 4
6 -4 5   5
7 -3 6    
8 -2 7   7
9 -1   -1.333333  
10 0      
11 1      
12 2      
13 3   -2.666667  
14 4      
15 5      
16 6      
17 7   -4  
18 8      
19 9      
20 10