Previous Page | Next Page

The SASEFAME Interface Engine

Example 36.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. SASEFAME resolves 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.

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 36.14.1 and Output 36.14.2 show the results.

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

Previous Page | Next Page | Top of Page