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

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

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

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