The SASEFAME Interface Engine

Example 41.12 Selecting Numeric Case Series with the FAMEOUT= Option

This example extracts numeric case series. In addition to the already existing numeric case series in the Fame database, you can also have formulas that expand to numeric 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 numeric case series to the SAS data set CSOUT:

libname lib5 sasefame "%sysget(FAME_DATA)"
   fameout=case wildcard="?" ;

data csout;
   set lib5.alltypes;
run;

title1 'Using FAMEOUT=CASE Option without Range';
title2 'ALLTYPES, FAMEOUT=CASE and Open Wildcard for Numeric Case Series';
proc contents
   data=csout;
run;

proc print
   data=csout;
run;

Output 41.12.1 and Output 41.12.2 show the results.

Output 41.12.1: Contents of OUT=CSOUT Using FAMEOUT=CASE and Open Wildcard for Numeric Case Series

Using FAMEOUT=CASE Option without Range
ALLTYPES, FAMEOUT=CASE and Open Wildcard for Numeric Case Series

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
# Variable Type Len
1 FRM1 Num 8
2 NUM0 Num 8
3 NUM1 Num 8
4 NUM2 Num 8
5 NUMM Num 8
6 NUM_RES Num 8
7 PRC0 Num 8
8 PRC1 Num 8
9 PRC2 Num 8
10 PRCM Num 8
11 PRC_RES Num 8



Output 41.12.2: Listing of OUT=CSOUT Using FAMEOUT=CASE and Open Wildcard for Numeric Case Series

Using FAMEOUT=CASE Option without Range
ALLTYPES, FAMEOUT=CASE and Open Wildcard for Numeric Case Series

Obs FRM1 NUM0 NUM1 NUM2 NUMM NUM_RES PRC0 PRC1 PRC2 PRCM PRC_RES
1 0.00000 -9 0 1.33333 0 . -18 0 1.33333 0 .
2 1.00000 -8 1 1.00000 1 . -16 1 1.00000 1 .
3 0.66667 -7 2 0.66667 1.7014E38 . -14 2 0.66667 1.7014E38 .
4 3.00000 -6 3 0.33333 3 . -12 3 0.33333 3 .
5 4.00000 -5 4 0.00000 4 . -10 4 0.00000 4 .
6 . -4 5 . 5 . -8 5 . 5 .
7 . -3 6 . 6 . -6 6 . 6 .
8 7.00000 -2 7 . 7 . -4 7 . 7 .
9 . -1 . -1.33333 . . -2 . -1.33333 . .
10 . 0 . . . . 0 . . . .
11 . 1 . . . . 2 . . . .
12 . 2 . . . . 4 . . . .
13 . 3 . -2.66667 . . 6 . -2.66667 . .
14 . 4 . . . . 8 . . . .
15 . 5 . . . . 10 . . . .
16 . 6 . . . . 12 . . . .
17 . 7 . -4.00000 . . 14 . -4.00000 . .
18 . 8 . . . . 16 . . . .
19 . 9 . . . . 18 . . . .
20 . 10 . . . . 20 . . . .