The SASEFAME Interface Engine

Example 41.11 Selecting Boolean Case Series with the FAMEOUT= Option

This example shows how to extract all Boolean case series from the ALLTYPES Fame database. The following statements write all Boolean case series to the SAS data set BOOOUT:

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;

title1 'ALLTYPES FAMEOUT=BOOLCASE for Boolean Case Series';
title2 'Using FAMEOUT=CASE BOOLEAN Option without Range';
proc contents
   data=booout;
run;

proc print
   data=booout;
run;

Output 41.11.1 and Output 41.11.2 show the results for the Boolean case.

Output 41.11.1: Contents of OUT=BOOOUT Using FAMEOUT=BOOLCASE for Boolean Case Series

ALLTYPES FAMEOUT=BOOLCASE for Boolean Case Series
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



Output 41.11.2: Listing of OUT=BOOOUT Using FAMEOUT=BOOLCASE for Boolean Case Series

ALLTYPES FAMEOUT=BOOLCASE for Boolean Case Series
Using FAMEOUT=CASE BOOLEAN Option without Range

Obs BOO0 BOO1 BOO2 BOOM BOO_RES
1 0 1 0 1 .
2 0 0 1 0 .
3 0 0 0 251 .
4 0 1 1 1 .
5 0 1 0 1 .
6 0 0 . 0 .
7 0 0 . 0 .
8 0 1 . 1 .
9 0 . 0 . .
10 0 . . . .
11 1 . . . .
12 1 . . . .
13 1 . 1 . .
14 1 . . . .
15 1 . . . .
16 1 . . . .
17 1 . 0 . .
18 1 . . . .
19 1 . . . .
20 1 . . . .