Example 40.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 out to numeric 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 numeric case series to your SAS data set.

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 40.12.1 and Output 40.12.2 show the results.

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