The SASEFAME Interface Engine

Example 41.13 Selecting Date Case Series with the FAMEOUT= Option

This example shows how to extract date case series. In addition to the existing date case series in your Fame database, you can have formulas that resolve to date 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 date case series to your SAS data set.

libname lib6 sasefame "%sysget(FAME_DATA)"
   fameout=datecase wildcard="?" ;

data cdout;
   set lib6.alltypes;
run;

title1 'Using FAMEOUT=DATECASE Option without Range';
title2 'ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series';
proc contents 
   data=cdout;
run;

proc print 
   data=cdout;
run;

Output 41.13.1 and Output 41.13.2 show the results.

Output 41.13.1: Contents of OUT=CDOUT Using FAMEOUT=DATECASE

Using FAMEOUT=DATECASE Option without Range

ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series

The CONTENTS Procedure

Alphabetic List of Variables and Attributes
#	Variable	Type	Len	Format	Informat
1	DAT0	Num	8	YEAR4.	4.
2	DAT1	Num	8	YEAR4.	4.
3	DAT2	Num	8	YEAR4.	4.
4	DATM	Num	8	YEAR4.	4.
5	FRM2	Num	8	YEAR4.	4.

Output 41.13.2: Listing of OUT=CDOUT Using FAMEOUT=DATECASE

Using FAMEOUT=DATECASE Option without Range

ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series

Obs	DAT0	DAT1	DAT2	DATM	FRM2
1	1991	1981	1987	1981	1987
2	1992	1982	1986	1982	1986
3	1993	1983	1985	1983	1985
4	1994	1984	1984	1984	1984
5	1995	1985	1983	1985	1983
6	1996	1986	.	1986	.
7	1997	1987	.	1987	.
8	1998	1988	.	1988	.
9	1999	.	1979	.	1979
10	2000	.	.	.	.
11	2001	.	.	.	.
12	2002	.	.	.	.
13	2003	.	1975	.	.
14	2004	.	.	.	.
15	2005	.	.	.	.
16	2006	.	.	.	.
17	2007	.	1971	.	.
18	2008	.	.	.	.
19	2009	.	.	.	.
20	2010	.	.	.	.