Example 40.11 Selecting Boolean Case Series with the FAMEOUT= Option

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

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 40.11.1 and Output 40.11.2 show the results for the Boolean case.

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